ADO.NET revolutionized the way data was accessed through SQL Server, Oracle, and MySQL. With Microsoft's release of ADO.NET 2, ADO and the .NET Framework are integrated with SQL Server for the first time-enabling you to program .NET applications directly within the SQL Server database.
Packed with sample code and recommended best practices for using ADO.NET 2, this code-intensive book explores the new data types that are available in the 2.0 Framework and discusses the appropriate time and way to use them. You'll learn how to make repetitive, mundane tasks much simpler and you'll walk away with a solid foundation for developing database-driven applications.
What you will learn from this book
The basics of creating a connection, executing a query, and returning a result
Best uses for Oracle in the ADO.NET Framework
The many new features that are available for XML
How to use the full text search capabilities of Microsoft(r) SQL Server 2005
Methods for retrieving data and presenting it in various ways
Why MySQL is a viable option for data storage
Who this book is for
This book is for experienced database developers who want to learn the latest release of ADO.NET 2.0. Knowledge of ADO.NET 1.0, general .NET development, and Microsoft SQL Server is necessary.
Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.
Customer Reviews:
Avg. Customer Rating: 3.0 / 5.0
A good ADO.Net reference:
This book has a lot of good information. I found myself skimming forward just a little but there was still lots of good info to make me want to keep reading. I wish there was sometimes more explanation of why the author feels a certain way but all and all this is book worth owning.
What a letdown:
I have 16 years experience as an adjunct instructor at a community college. I have a BS in Engineering and I'm 3 credits away from my Master's in Comp Sci.
I'm taking time from my class prep to write this review...
I have been assigned to teach a Visual Basic programming class with this book. Had I been given the opportunity to read the text beforehand, I would have fought hard to use some other book. The example code is formatted so poorly that I am embarassed to use it in class. Some of the... more info
Could not get download code to work. Wiley no help!:
I had hoped that working through this book would bring extra insight and new techniques. After all, I have been a database consultant for 15 years and designed, programed and implemented many large solutions. I found that the book left much unsaid and detailed instructions non existant. I had problems with the download code. It appears to be tied up with VS team system, so if you are a home or small business who is unfamiliar with tem system then you may have problems. I contacted Wiley Customer... more info
If your work with databases, get this book!:
There are a number of great things about this book, from my perspective. For me, perhaps the best chapter was the one on the custom ADO.NET provider. Even if you do not want to create a custom provider (and honestly, I do not think I will), reading through that chapter helps explain how the various standard interfaces work. In addition to covering ADO.NET 2.0 proper, the book covers specifically how you can use ADO.NET in very practical ways, interacting with SQL Server, as well as doing server side... more info
