Join Amazon Prime and ship Two-Day for free and Overnight for $3.99. Already a member? Sign in.

 

or
Sign in to turn on 1-Click ordering.
 
 
More Buying Choices
42 used & new from $29.99

Have one to sell? Sell yours here
 
   
ADO.NET 3.5 Cookbook (Cookbooks (O'Reilly))
 
 
Tell the Publisher!
I’d like to read this book on Kindle

Don’t have a Kindle? Get yours here.
 
  

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

by Bill Hamilton (Author)
Key Phrases: binding data, asynchronous processing, merging data, Initial Catalog, Data Set, Solution Use (more...)
4.6 out of 5 stars See all reviews (7 customer reviews)

List Price: $54.99
Price: $37.11 & this item ships for FREE with Super Saver Shipping. Details
You Save: $17.88 (33%)
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
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.

Want it delivered Monday, July 20? Choose One-Day Shipping at checkout. Details
29 new from $30.37 13 used from $29.99
Also Available in: List Price: Our Price: Other Offers:
Digital (Download: PDF) $43.99 $43.99
Like this book? Find similar titles from O'Reilly and Partners in our O'Reilly Bookstore.

Best Value

Buy Programming Entity Framework and get ADO.NET 3.5 Cookbook (Cookbooks (O'Reilly)) at an additional 5% off Amazon.com's everyday low price.

Programming Entity Framework + ADO.NET 3.5 Cookbook (Cookbooks (O'Reilly))
Buy Together Today: $69.89

Show availability and shipping details

  • Programming Entity Framework

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details

  • This item: ADO.NET 3.5 Cookbook (Cookbooks (O'Reilly))

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details


Customers Who Bought This Item Also Bought

C# 3.0 Cookbook

C# 3.0 Cookbook

by Jay Hilyard
4.0 out of 5 stars (6)  $32.72
Programming Entity Framework

Programming Entity Framework

by Julia Lerman
4.7 out of 5 stars (19)  $34.64
Pro LINQ: Language Integrated Query in C# 2008 (Windows.Net)

Pro LINQ: Language Integrated Query in C# 2008 (Windows.Net)

by Jr., Joseph C. Rattz
4.7 out of 5 stars (38)  $28.34
Pro C# 2008 and the .NET 3.5 Platform, Fourth Edition (Windows.Net)

Pro C# 2008 and the .NET 3.5 Platform, Fourth Edition (Windows.Net)

by Andrew Troelsen
4.4 out of 5 stars (56)  $37.79
Programming .NET 3.5

Programming .NET 3.5

by Jesse Liberty
4.4 out of 5 stars (7)  $29.69
Explore similar items

Editorial Reviews

Product Description
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.

About the Author
Bill Hamilton is a software architect specializing in designing, developing and implementing distributed applications using .NET and J2EE technologies. Over the last ten years, he has provided consulting services in B2B, B2C, B2E, data integration, and portal initiatives for banking, retail, accounting, manufacturing, and financial services. An early technology adopter, he frequently evaluates, recommends, and helps his clients use new technologies effectively. Bill has designed and helped build several award winning software packages.

Product Details

  • Paperback: 980 pages
  • Publisher: O'Reilly Media, Inc.; 2 edition (March 28, 2008)
  • Language: English
  • ISBN-10: 0596101406
  • ISBN-13: 978-0596101404
  • Product Dimensions: 9.1 x 7 x 1.8 inches
  • Shipping Weight: 3 pounds (View shipping rates and policies)
  • Average Customer Review: 4.6 out of 5 stars See all reviews (7 customer reviews)
  • Amazon.com Sales Rank: #349,425 in Books (See Bestsellers in Books)

    Popular in these categories: (What's this?)

    #57 in  Books > Computers & Internet > Microsoft > Databases
    #73 in  Books > Computers & Internet > Microsoft > Development > Visual Basic > .Net

Inside This Book (learn more)

What Do Customers Ultimately Buy After Viewing This Item?


Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
Check the boxes next to the tags you consider relevant or enter your own tags in the field below.
(6)
(4)
(4)

Your tags: Add your first tag
 
Help others find this product — tag it for Amazon search
No one has tagged this product for Amazon search yet. Why not be the first to suggest a search for which it should appear?

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

 

Customer Reviews

7 Reviews
5 star:
 (5)
4 star:
 (1)
3 star:
 (1)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
4.6 out of 5 stars (7 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
5 of 5 people found the following review helpful:
5.0 out of 5 stars Review from a tech reviewer, April 14, 2008
By Louis Franco (Northampton, MA USA) - See all my reviews
(REAL NAME)   
(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 Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
6 of 7 people found the following review helpful:
5.0 out of 5 stars Review from a "professional" reviewer, May 31, 2008
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.
Comment Comment (1) | Permalink | Was this review helpful to you? Yes No (Report this)



 
2 of 2 people found the following review helpful:
5.0 out of 5 stars Great Resource For .NET DB Developers, June 12, 2008
By Daniel McKinnon (Tewksbury, MA USA) - See all my reviews
(TOP 500 REVIEWER)      
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.

***** HIGHLY RECOMMENDED
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
Ad
 
Most Recent Customer Reviews

3.0 out of 5 stars Not a comprehensive source for ADO.NET
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. Read more
Published 2 months ago by Horton Deakins

5.0 out of 5 stars Great Book, Great Job
I recently purchased this book, and I must confess, it's fantastic. I saw a small review by Scott Michell in MSDN magazine and decided to give it a try. Glad I did. Read more
Published 3 months ago by Adedamola Adeogun

5.0 out of 5 stars The Real ADO.NET 3.5 Book
I finally come across a very good ADO.NET textbook. The author has done an excellent job explaning everything that ADO.NET 3.5 has to offer. Read more
Published 9 months ago by Gregory J. Fequiere

4.0 out of 5 stars Really good for ADO.NET programmers
[Also posted on my blog: http://msmvps.com/blogs/luisabreu/archive/2008/06/11/book-review-ado-net-3-5-cookbook. Read more
Published 13 months ago by Luis Abreu

Only search this product's reviews



Customer Discussions

 Beta (What's this?)
New! See all customer communities, and bookmark your communities to keep track of them.
This product's forum (0 discussions)
  Discussion Replies Latest Post
  No discussions yet

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


Active discussions in related forums
   


Product Information from the Amapedia Community

Beta (What's this?)



Look for Similar Items by Category


An Explosion of Popcorn Flavor!

Fireworks Popcorn & Seasoning Set
Munchies have never been better. The Fireworks Popcorn & Seasoning Set gives you four popcorn types and four seasonings, including white cheddar, butter burst, caramel pecan, and popcorn salt--all for $15.49.
 

Best Books of 2008

Best of 2008
Find our top 100 editors' picks as well as customers' favorites in dozens of categories in our Best Books of 2008 Store.
 

Be Prepared for a Deep Freeze

Shop for freeze alarms
Keep pipes safe during the cold season with a freeze alarm. Avoid bursting pipes and pricey cleanup.

Shop for freeze alarms

 

Best Books

Best of the Month
See our editors' picks and more of the best new books on our Best of the Month page.
 
Ad

 

Feedback

If you need help or have a question for Customer Service, contact us.
 Would you like to update product info or give feedback on images?
Is there any other feedback you would like to provide?

Your comments can help make our site better for everyone.


Where's My Stuff?

Shipping & Returns

Need Help?

Your Recent History

  (What's this?)
You have no recently viewed items or searches.

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.

Look to the right column to find helpful suggestions for your shopping session.

Continue shopping: Top Sellers
Free
Free by Chris Anderson
Paranoia
Paranoia by Joseph Finder
My Soul to Lose
My Soul to Lose by Rachel Vincent
Glenn Beck's Common Sense

Conditions of Use | Privacy Notice © 1996-2009, Amazon.com, Inc. or its affiliates