Professional ADO.NET 2: Programming with SQL Server 2005, Oracle, and MySQL

Rank: #20[SQL] , #43 [pl,sql]
Paperback: 648 pages
Publisher: Wrox (December 5, 2005)
Language: English
ISBN-10: 0764584375
ISBN-13: 978-0764584374
Product Dimensions: 9.1 x 7.5 x 1.5 inches







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.

From the Back Cover
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.

User Review:

I was really looking forward to this book, for both ASP.Net and WinForms development, since I really thought that's what the book was really about. Boy was I surprised. if that was all it had, I'd probably be very happy. However - that was just the tip of the iceberg! It has quite a wide focus, so, in some cases, it was kind of dificult to know where the book is going.

However, The reader is somewhat warned right off the bat, that the book focuses mainly on the new features of ADO.Net 2.0, so prior knowledge of ADO.Net is expected, but I believe there is still a lot of text that covers a lot of the basics - just without a hand-held experience.

For those so inclined, there's quite a bit of information concerning subjects like usinc CLR objects, TSQL Enhancements, Notification Services, Service Broker and Reporting Services, though it's definitely not JUST about SQL Server. There is quite a bit on the popular open source databases like MySQL and PostgreSQL, along with a chapter on Oracle, just for good measure.

Many times, on different forums, I find questions concerning how to create a Database/table/etc, in code. Professional ADO.Net 2 has this plus a whole lot more about SQL Server server-side programming

Going into the book, I knew there were quite a few new features of ADO.Net, but I really had no idea concerning the extent of new features. This book contains 584 pages of great information. Though what I'd consider a bit wordy, at times, I'll definitely keep this book around.

If all you do is ASP.Net web page development, maybe this isn't the book for you - but if you do a lot more and really like 'nuts and bolts', and widening your experience, I think it's a go!

If you are like me, you struggle every time Microsoft changes ADO. We have to rely on "experts" and their books to help us through the ADO direction of year. Unfortunately, I would not use "ADO.Net 2 - Programming with SQL Server 2005, Oracle and MySQL" as one of them. After a slow start with database fundamentals not related to .Net, the book seems to start in the right direction and then quickly derails. The authors make a serious point about how ADO.Net 2 is suppose to help us develop against any database system, but then spends the rest of the pages bypassing this ability without informing the reader. So not surprising, the examples are confusing; not database agnostic, disconnected, abstracted and difficult to follow. Nearly all the example code only works for SQL Server 2005. The book attempts to recover with specific chapters for Oracle and MySQL, but is thin and short on examples.

I found something interesting from each chapter, but I personally would rather have just one reference book on each subject. With this book, you might end up needed additional references.

Free Download: