ADO.NET 3.5 Cookbook (Cookbooks (O'Reilly)) and over 2 million other books are available for Amazon Kindle . Learn more

Sign in to turn on 1-Click ordering.
Trade in Yours
For a £2.76 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Image not available

Start reading ADO.NET 3.5 Cookbook (Cookbooks (O'Reilly)) on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

ADO.NET 3.5 Cookbook (Cookbooks (O'Reilly)) [Paperback]

Bill Hamilton

Price: £35.50 & FREE Delivery in the UK. Details
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 1 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.


Amazon Price New from Used from
Kindle Edition £27.30  
Paperback £35.50  
Trade In this Item for up to £2.76
Trade in ADO.NET 3.5 Cookbook (Cookbooks (O'Reilly)) for an Amazon Gift Card of up to £2.76, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Book Description

7 April 2008 0596101406 978-0596101404 2

This guide is strikingly different from other books on Microsoft ADO.NET. Rather than load you down with theory, the new edition of ADO.NET 3.5 Cookbook gives you more than 200 coding solutions and best practices for real problems you're likely to face with this technology using Visual Studio 2008 and the .NET 3.5 platform.

Organized to help you find the topic and specific recipe you need quickly and easily, this book is more than just a handy compilation of cut-and-paste C# code. ADO.NET 3.5 Cookbook also offers clear explanations of how and why each code solution works, and warns you of potential pitfalls so you can learn to adapt the book's problem-solving techniques to different situations.

This collection of timesaving recipes covers vital topics including:

  • Connecting to data
  • Retrieving and managing data
  • Transforming and analyzing data
  • Modifying data
  • Binding data to .NET user interfaces
  • Optimizing .NET data access
  • Enumerating and maintaining database objects
  • Maintaining database integrity
Ideal for ADO.NET programmers at all levels, from the relatively inexperienced to the most sophisticated, this new edition covers the significant 3.5 upgrade, including new programming tools such as LINQ. ADO.NET 3.5 Cookbook offers a painless way for those of you who prefer to learn by doing when it comes to expanding your skills and productivity.

Product details

More About the Author

Discover books, learn about writers, and more.

Product Description

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

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

There are no customer reviews yet on
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on (beta) 3.9 out of 5 stars  11 reviews
9 of 10 people found the following review helpful
5.0 out of 5 stars Review from a tech reviewer 14 April 2008
By Louis Franco - Published on
(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.
10 of 12 people found the following review helpful
5.0 out of 5 stars Review from a "professional" reviewer 31 May 2008
By Michael Taylor - Published on
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.
2 of 2 people found the following review helpful
5.0 out of 5 stars Great Resource For .NET DB Developers 12 Jun 2008
By Dan McKinnon - Published on
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.

2 of 2 people found the following review helpful
5.0 out of 5 stars Superbly written and executed 19 April 2012
By bibliomanic - Published on
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.
3 of 4 people found the following review helpful
3.0 out of 5 stars Not a comprehensive source for ADO.NET 7 May 2009
By Horton Deakins - Published on
Format:Paperback|Verified Purchase
Just make sure you know what you're getting with this book, and don't expect that it will be the be-all-to-all. If you're new to ADO.NET, you need something more basic. I would also get a plain vanilla reference manual, as it will be difficult to pick out basic structures from this book. It does show many ways to do things, but you have to know what you're looking for, and don't expect exhaustive explanations for what you find or a comprehensive index, either. You need other sources for that. But if you already knew the information from the basic sources, you might not need this book. It seems to be saying, "Look what all you can do with this," but it doesn't give you the basics. Again, if you knew the basics, you could probably write the book.
Were these reviews helpful?   Let us know

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category