Automotive Holiday Deals Books Gift Guide Books Gift Guide Shop Men's Athletic Shoes Learn more nav_sap_SWP_6M_fly_beacon Prime Music Sweepstakes egg_2015 All-New Amazon Fire TV Grooming Deals Gifts Under $50 Amazon Gift Card Offer cm15 cm15 cm15 $30 Off Amazon Echo $30 Off Fire HD 6 Kindle Cyber Monday Deals Holiday Music in CDs & Vinyl Shop Now HTL
ADO.NET 3.5 Cookbook (Cookbooks (O'Reilly)) and over one million other books are available for Amazon Kindle. Learn more

Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

  • List Price: $54.99
  • Save: $16.00 (29%)
Only 1 left in stock (more on the way).
Ships from and sold by Gift-wrap available.
ADO.NET 3.5 Cookbook (Coo... has been added to your Cart
Condition: Used: Like New
Comment: Unbeatable customer service, and we usually ship the same or next day. Over one million satisfied customers!
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

ADO.NET 3.5 Cookbook (Cookbooks (O'Reilly)) Paperback – April 7, 2008

13 customer reviews

See all 3 formats and editions Hide other formats and editions
New from Used from
"Please retry"
"Please retry"
"Please retry"
$8.47 $1.53

Take an Extra 30% Off Any Book
$38.99 FREE Shipping. Only 1 left in stock (more on the way). Ships from and sold by Gift-wrap available.

Frequently Bought Together

  • ADO.NET 3.5 Cookbook (Cookbooks (O'Reilly))
  • +
  • Microsoft ADO.NET 4 Step by Step (Step by Step Developer)
Total price: $73.40
Buy the selected items together

Special Offers and Product Promotions

  • Take an Extra 30% Off Any Book: Use promo code HOLIDAY30 at checkout to get an extra 30% off any book for a limited time. Excludes Kindle eBooks and Audible Audiobooks. Restrictions apply. Learn more | Shop now

Editorial Reviews

About the Author

Bill Hamilton is a technology and management consultant who specializes in assessing business objectives and company processes and designing and restructuring technology strategy and enterprise architecture. Bill has been designing and implementing enterprise solutions using both SQL Server and Oracle for over a decade. Bill is the author of other O'Reilly titles including the highly praised Programming SQL Server 2005 and ADO.NET Cookbook, and he also writes for the Microsoft Developer Network. You can email Bill at


Hero Quick Promo
Holiday Deals in Kindle Books
Save up to 85% on more than 1,000 Kindle Books. These deals are valid until November 30, 2015. Learn more

Product Details

  • Series: Cookbooks (O'Reilly)
  • Paperback: 982 pages
  • Publisher: O'Reilly Media; Second Edition edition (April 7, 2008)
  • Language: English
  • ISBN-10: 0596101406
  • ISBN-13: 978-0596101404
  • Product Dimensions: 7 x 1.6 x 9.2 inches
  • Shipping Weight: 3 pounds (View shipping rates and policies)
  • Average Customer Review: 4.0 out of 5 stars  See all reviews (13 customer reviews)
  • Amazon Best Sellers Rank: #1,228,817 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

9 of 10 people found the following review helpful By Lou Franco on April 14, 2008
Format: Paperback
(Full Disclosure: I was a tech reviewer for this book and received a free copy)

I've been using the various incarnations of Microsoft data access technologies for quite some time and have been using ADO.NET for a few years, so I wondered whether I was going to learn anything new from this book. It covers all of the territory to get started (connection strings, basic usage of ADO.NET classes, etc.), but what I really appreciated was that it topics that advanced ADO.NET users would find useful and I certainly learned a few new tricks.

The topic on writing provider and database independent code (Section 10.22) which covers how to do it right if you are targeting .NET 1.1 (which we do) was particularly useful to me. Chapter 10 (Optimizing .NET Data Access) is just generally a good chapter no matter what your level and covers asynchronous SQL calls (executing and cancelling), ASP.NET data caching, paging queries, SQL Server stored procedure debugging and more.

Since my job was to actually run every code snippet, I can vouch for their quality. Most are built off the AdventureWorks sample database that comes with SQL Server Express, so they are ready to run. The rest come with full DDL to create what you need (databases, stored procedures, etc), and the code and SQL is available online so you don't have to type it in.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
10 of 12 people found the following review helpful By Michael Taylor on May 31, 2008
Format: Paperback
I received a copy of this book from the publisher for a review by a "technical expert". I really liked how the book was laid out with a problem-solution-reasoning approach (known as a recipe). Each one was generally useful for those unaware of how to do things in ADO.NET. The examples were short and too the point. The topics were quite varied so just about everyone will find something in this book. In particular the recipes on getting schema information programmatically will really benefit a lot of people because it is neither common nor easy.

I had only a few complaints about the book. The first complaint is with the title. It says ADO.NET v3.5 but in reality almost all the recipes cover any version of ADO.NET from v2 on. This might cause some people to shy away from the book. This book is really for anybody using ADO.NET.

This leads me to the second complaint. There really was no 3.5 content mentioned. LINQ and SQL 2008 were mentioned a few times but they aren't specific to ADO.NET v3.5. LINQ itself seemed out of place for the topic.

The final complaint I had was that the recipes are mostly designed to be copy and pasted into working code. The code samples don't really follow what I would consider an appropriate pattern for professional code. Therefore simply copy/paste will cause more problems than not. It really would have required no additional lines of code and would not have complicated things to have "done it right". Still this seems to be standard practice for most technical books so I can't harp too much.

Overall I recommend this book for anyone who works with (or will) ADO.NET of any version.
1 Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
2 of 2 people found the following review helpful By Dan McKinnon VINE VOICE on June 12, 2008
Format: Paperback
The 'ADO.NET 3.5 Cookbook' is a great resource for every .NET database developer out in the world. With 950+ pages of content you will not be reading thin, as this goodies book comes with 222 tidbits of information that will help you in your everyday work.

Subjects covered include:

- connecting to a variety of data sources
- working with disconnected data objects (datasets)
- querying data
- executing functions and stored procedures
- using LINQ
- searching and filtering data
- adding and updating data
- copying/transferring data
- database integrity
- binding data to web forms
- XML data
- optimizing .NET data access
- debugging stored procedures
- doing batch updates
- enumerating SQL servers
- SQL Server CLR integration

I feel that is an outstanding companion book for .NET database developers that are looking for a resource that specifically outlines tasks into a neat, organized manner. Instead of thumbing through a book to figure out a particular way to do something, these common tasks and questions are broken up for ease of use and efficiency. If you are a .NET DB developer you definitely owe it to yourself to add this great book to your collection of technical books immediately.

Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
2 of 2 people found the following review helpful By bibliomanic on April 19, 2012
Format: Paperback Verified Purchase
There's no question this book is a first-rate reference insofar as books on this subject are concerned. ADO.NET has been Microsoft's core data provider API since the inception of .NET and that's not going to change in the near future--particularly with its implementation and tight coupling with the powerful Entity Framework.

I'm typically not a fan of the "Cookbook" approach but I make an exception in this case. Mr. Hamilton's presentation is organized into clear, cohesive chunks. He begins with the key aspects of connecting to a variety of data tiers, moves on to working with disconnected data objects, and then proceeds through data operations, enhanced form/web UI's and database object enumeration. It also includes working with XML and optimizing data access for .NET. There's even sections on working with data to maintain its integrity and normalization within SQL Server.

Bottom line, this book has been an invaluable reference for me and I find myself constantly pulling it from my shelf at work and home to prime or simply refresh me on a particular topic. The code samples are extensive. I highly recommend this book for any .NET developers looking to leverage the power of ADO.NET in their applications.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Recent Customer Reviews

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
ADO.NET 3.5 Cookbook (Cookbooks (O'Reilly))
This item: ADO.NET 3.5 Cookbook (Cookbooks (O'Reilly))
Price: $38.99
Ships from and sold by

What Other Items Do Customers Buy After Viewing This Item?

Want to discover more products? Check out this page to see more: .net programming