Programming Microsoft ADO.NET 2.0 Core Reference [Paperback]

David Sceppa (Author)

Book Description

ISBN-10: 073562206X | ISBN-13: 978-0735622067 | Publication Date: August 30, 2006 | Edition: 2nd

Build your expertise as you move beyond the basics—and delve into the essential topics of programming with ADO.NET 2.0. This comprehensive reference offers expert guidance, hands-on instruction, and code samples in Microsoft Visual C# and Visual Basic to help advance your mastery of developing database applications for Microsoft Windows and the Web.

Discover how to:

• Work with design-time data access features in Microsoft Visual Studio 2005
• Use Microsoft .NET Framework 2.0 data providers to connect to databases
• Build connection strings and enable connection pooling
• Execute queries, including parameterized and asynchronous queries, and retrieve their results
• Create DataSet objects to work with offline data and explore common usage scenarios
• Use the new Common Language Runtime features and XML data type in Microsoft SQL Server 2005
• Generate logic and use stored procedures for simple to advanced updating scenarios
• Design Web applications with new data access features in ASP.NET 2.0—including code-free data-binding capabilities

PLUS—Get Visual Basic and C# code samples, and a Microsoft .NET Data Provider on the Web

Editorial Reviews

From the Publisher

Completely revised for ADO.NET 2.0, this essential reference illustrates the intricacies and applications of the technology—in a single, definitive volume.

Key Book Benefits:

• Completely updated for ADO.NET 2.0, this book delves into essential development topics in a practical reference/tutorial format

• Examines new ADO.NET features such as generics, code snippets, and My Namespace in depth, while also providing the latest information on classic features such as classes and execution flow

• Provides hands-on code examples to illustrate concepts and build skills mastery

About the Author

Author of two previous editions of this book, David Sceppa is currently working as a Program Manager on the Microsoft SQL Server team, working with the new data features in the product as well as with ADO .NET itself. David has previously worked on Microsoft’s Visual Basic® data team and in Developer Support as a technical lead, helping customers (and coworkers) with issues regarding building database applications with Visual Basic. He is also Microsoft certified and has a background in teaching.

Product Details

• Paperback: 864 pages
• Publisher: Microsoft Press; 2nd edition (August 30, 2006)
• Language: English
• ISBN-10: 073562206X
• ISBN-13: 978-0735622067
• Product Dimensions: 9.4 x 7.4 x 1.5 inches
• Shipping Weight: 2.2 pounds (View shipping rates and policies)
• Average Customer Review: 4.7 out of 5 stars  See all reviews (13 customer reviews)
• Amazon Best Sellers Rank: #796,471 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

35 of 36 people found the following review helpful:

5.0 out of 5 stars Breath of fresh air, January 6, 2007

By 

Terry Hutt (Running Springs, CA) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: Programming Microsoft ADO.NET 2.0 Core Reference (Paperback)

I normally buy Wrox books and up until .NET I was very happy with them, but their .NET books (ASP.NET 2.0 and VB.NET particularly) were poorly organized with massive numbers of errors in them. I wanted an ADO.NET book but the customer reviews of the Wrox title were poor so I kept looking and found this book that has much better reviews. I'd not bought a Microsoft Press book recently because I didn't like the last one I tried so this was an act of faith for me.

I have to say, thought, that this book is an order of magnitude better than the recent Wrox books I have bought. I don't know if the single author approach simply results in a better book or if the particular author (David Sceppa) can take the credit. Either way, I think Wrox needs to stop publishing books with multiple authors.

The problem with ADO.NET is that everything is intermingled and it's hard to discuss, say, DataSets without mentioning DataTables or DataAdapters. David (or someone) say down and very carefully figured out the sequence to explain stuff with the minimum of forward referencing. This means there are only a few unresolved references I have to hold in my brain at a time for which I am very grateful. On the down-side, this means there is some repetition as he discusses the same class relationship from different perspectives in different chapters. At first I found this annoying until I realized that this was actually making my life as the reader much easier.

I have yet to find a single error and the sample code in particalar seems to be error free which is in stark contrast to the Wrox .NET books. The samples themselves are compact and clean and writen in both VB and C# which is a handy way for a VB programmer like me to learn a little C# on the cheap. I certainly never found myself thinking 'The purpose of this sample is to add 10 unncecessary pages to this book' unlike other books *cough*XML Bible*cough*.

I'm only about one third of the way through right now but I am very impressed.

I really hope someone from Wrox reads this because I'd like the old Wrox back that published great technical books.

25 of 27 people found the following review helpful:

5.0 out of 5 stars Absolutely superb, October 5, 2006

By 

William G. Ryan "Uber Book Nerd" (Atlanta, GA) - See all my reviews
(VINE VOICE)    (REAL NAME)   

This review is from: Programming Microsoft ADO.NET 2.0 Core Reference (Paperback)

I am a huge ADO.NET nut and David's first book was absolutely priceless. After his last book, he set a very high bar that was going to be hard to meet, yet that's exactly what he did.

Pros:

- He discusses every facet of the ADO.NET library and does it well
- He doesn't shy away from difficult topics and in particular, goes straight at them in his Advanced Update section
- Excellent flow
- Won't leave you hanging if you don't know the 1.x framework but doesn't bog itself down in it either.
- Stellar writing style. David is interesting and always keeps you wanting to read more. He's concise, to the point yet does both without ever leaving you wanting for more.

CONS
-Calling this a con is probably a bit unfair but if there's one thing I didn't like was the coverage to TableAdapters. This has nothing to do with Sceppa's coverage and everything to do with the objects themselves. Since I never use them I have a bias against them. With that said, I doubt you could do a Core Reference without covering them so this doesn't really count.

The specific areas that this book really does a great job in is Transactions, Advanced Updates and client side data manipulation. Items like the syntax for DataTable.Select are covered in such stellar detail there's probably no situation that you will be unprepared for. Transactions are another complex area and this section alone makes the book worth its price. Advanced updates are a must in any ADO.NET book and history repeated itself here.

Pure Gold plain and simple.

15 of 17 people found the following review helpful:

5.0 out of 5 stars Accessing a Database from the .NET Environment, September 30, 2006

By 

John Matlock "Gunny" (Winnemucca, NV) - See all my reviews
(REAL NAME)   

This review is from: Programming Microsoft ADO.NET 2.0 Core Reference (Paperback)

This book is intended for people writing data access code in a Microsoft .NET application. ADO (Active Data Object) .NET is a set of libraries within the Microsoft .NET framework that helps you to communicate with various data sources from .NET applications.

The newest version of ADO.NET which comes with Visual Studio 2005 is the first major release that does not introduce a new object model. This implies that the fundamental technology is reaching a point of stability in spite of several problems that users are requesting such as better support for XML.

Most of the illustrations in the book use the SQL Server Express Edition which is free, and redistributable. As such, it is helpful if you have at least a bit of knowledge about programming in SQL. The more work you can get done in SQL, the faster your application will run. I would recommend the purchase of an additional book on T-SQL, the specific version of the SQL language used with SQL Server. This book is more concerned with connecting to your database with a program that you might write.