ADO.NET in a Nutshell

  Author:    Matthew MacDonald, Bill Hamilton
  ISBN:    0596003617
  Sales Rank:    447401
  Published:    2003-04
  Publisher:    O'Reilly Media, Inc.
  # Pages:    704
  Binding:    Paperback
  Avg. Rating:    5.0 based on 10 reviews
  Used Offers:    15 from $7.15
  Amazon Price:    $29.67
  (Data above last updated:  2008-11-18 10:04:43 EST)
  
  
Sort customer reviews by:
  
Show All Reviews on Page      Hide All Reviews on Page
   
  
ADO.NET in a Nutshell
  
Written by experts on the Microsoft® .NET programming platform, ADO.NET in a Nutshell delivers everything .NET programmers will need to get a jump-start on ADO.NET technology or to sharpen their skills even further. In the tradition of O'Reilly's In a Nutshell Series, ADO.NET in a Nutshell is the most complete and concise source of ADO.NET information available. ADO.NET is the suite of data access technologies in the .NET Framework that developers use to build applications services accessing relational data and XML. Connecting to databases is a fundamental part of most applications, whether they are web, Windows®, distributed, client/server, XML Web Services, or something entirely different. But ADO.NET is substantially different from Microsoft's previous data access technologies--including the previous version of ADO--so even experienced developers need to understand the basics of the new disconnected model before they start programming with it. Current with the .NET Framework 1.1, ADO.NET in a Nutshell offers one place to look when you need help with anything related to this essential technology, including a reference to the ADO.NET namespaces and object model. In addition to being a valuable reference, this book provides a concise foundation for programming with ADO.NET and covers a variety of issues that programmers face when developing web applications or Web Services that rely on database access. Using C#, this book presents real world, practical examples that will help you put ADO.NET to work immediately. Topics covered in the book include:
  • An Introduction to ADO.NET
  • Connections, Commands and DataReaders
  • Disconnected Data
  • Advanced DataSets
  • Transactions
  • DataViews and Data Binding
  • XML and the DataSet
Included with the book is a Visual Studio .NET add-in that integrates the entire reference directly into your help files. When combining ADO.NET in a Nutshell with other books from O'Reilly's .NET In a Nutshell series, you'll have a comprehensive, detailed and independent reference collection that will help you become more productive.
                  Reader Reviews 1 - 10 of 10                 
  
  
Review
Date
Review
Rating(5 High)
Review
Helpful
to:
Customer Review Reviewer
Info
Permanent
Link
Reader Reviews Below Sorted by Newest First
08-25-07 5 (NA)
(Hide Review...)  The best way to learn ADO.NET
Reviewer Permalink
The bitter, Faster, and Lighter way to learn ADO.NET , the book contains and explain ALL ADO.NET Classes in simple way , of course the book written by experts in Microsot .NET .
I advise every one who want to learn ADO.NET in the fastest time to Buy this book .

(Review Data Last Updated: 2008-11-19 04:41:56 EST)
05-28-06 5 (NA)
(Hide Review...)  A long time Oracle and Mysql programmer learns the basics of ADO.NET
Reviewer Permalink
--A Concise Reference with only the useful information. ADO.NET really does take a different approach from the other database API's. I have worked alot with JDBC, MySql (via java and PHP), Oracle and ODBC. In ADO.NET, the concept of a disconnected Dataset forces you to rely heavily upon Microsoft's Object model. The alternative to this book seemed to be either: Search through MSDN's reference material Or Purchase one of the many books which regurgitate the steps in using the wizards. The MSDN reference material really did not show me the expected "idioms" or paradigms in writing function db applications. This book helped me to understand what is really happening beneath these opaque designs. It helped me to understand and solve some of the necessities in creating data driven ASP.NET DB applications.
(Review Data Last Updated: 2007-10-14 11:39:27 EST)
07-26-05 5 1\1
(Hide Review...)  Microsoft MVP 2005 - Visual C# loves this one
Reviewer Permalink
I own over 50 books on .NET including several on ADO.NET. This book is my favorite on ADO.NET. Thus, it is the one I use most often. It has a great blend of discussion, documentation, and code samples. It is much easier and more thorough than much of the MSDN documentation or most other books. I've yet to run into a situation where the answer I need isn't either in this book or gives me a great starting point to find that answer.

Virtually every ADO.NET oriented class, method, event, and property is covered.

This book is definitely worth purchasing.
(Review Data Last Updated: 2006-07-07 13:07:23 EST)
04-28-04 5 3\3
(Hide Review...)  Incredible!
Reviewer Permalink
I've owned this book for 3 days and cannot put it down! I have not been a big fan of O'Reilly over the years, but this book is "incredible". It goes into the detail that most books seem to omit and it's those details that we "developers" desperately need.

I would recommend this book to ANY and ALL .NET developers who are writing code that hits against a database. There are topics covered in this book that Microsoft's own MSDN and VS.NET help system seem to fail at properly explaining. It's because of this that I've found myself (all too often) going to codeguru.com and google groups to get answers to ADO.NET questions that this book actually covers.

My hat goes off to authors Matthew MacDonald and Bill Hamilton on a job well done.

Coming from a Visual Basic background and now working in VB.NET and C#.NET, this book should satisfy both the VB.NET and C# developer.

(Review Data Last Updated: 2006-07-07 13:07:23 EST)
03-14-04 5 6\6
(Hide Review...)  Excellent reference, and a good introduction to ADO
Reviewer Permalink
This book is classic O'Reilly. It's separated into three sections. The first being a thorough but brief introduction to all aspects of the API. The second section is an API reference. And the third a quick reference. This third section is included on the CD that comes with the book and will integrate into Visual Studio.

Don't expect the first section of the book, which is an introduction to ADO.NET to give you a gentle introduction to the subject. That's not the Nutshell form. If you don't know ADO at all you will want to buy both this book and an introductory book. If you know related APIs, or you know ADO.NET and you need a refresher or have weak spots you will find some new things in the first section. For me it was the support for disconnect access and also the integration with the XML features of SQL Server 2000.

Although this book stays true to the Nutshell form it is a little longer in the introduction than the usual. The introductory section is seventeen chapters and is almost half of the length of the book. So if you are an intermediate or advanced engineer I think you could probably learn enough ADO directly from this book without any other introductory book.

(Review Data Last Updated: 2006-07-07 13:07:23 EST)
12-10-03 3 12\15
(Hide Review...)  Not for beginners, academic interest for advanced.
Reviewer Permalink
The first third of the book discusses, with code samples, how the component parts (connections, data providers, data readers, data sets etc.) fit together. This is interesting.

The next third analyses the classes themselves but can be seen as a help rehash (altho' this is a little harsh since it does go into more detail than the standard help).

And the last third lays out the namespaces themselves and shows the classes within them, tabulating their members without further comment. Not useful.

In the end, I still didn't feel confident enough to develop even a simple application (except with the data grid, as in many samples). Why would I want to merge two data sets, and why do I get duplicates in the data set but not the underlying data base? What exactly happens when I Update, or EndEdit()? When I do a Fill() on a dataset, am I really sucking the entire data into memory?! Is this efficient, what is Best Practice on this?

ADO.NET puts a large, complex, flexible abstraction between the developer and the database itself, and what is needed is someone to show the "correct" way to use all these bits in real-world programs.

(Review Data Last Updated: 2006-07-07 13:07:23 EST)
11-21-03 5 4\6
(Hide Review...)  Another MacDonald Classic
Reviewer Permalink
Not too long ago, I thought I didn't like O'Reilly titles. I've since done a 180 and have really grown to like them. This book is one of the reason's why. I'm a big fan of the Authors and bought it just because I try to read every ADO.NET title that I can get my hands on, and try to buy everything MacDonald writes.

The book is concise and too the point.. It's not a definitive reference to ADO.NET (If you haven't bought David Sceppa's book or Bill Vaughn's --- buy those two and this one!) but it's a very practical how to guide for a lot of common tasks. If you are familiar with Matt's stuff, it's very typical of his style. I think he's one of the more interesting writers out there and this book keeps your attention. I'm an ADO.NET nut, so I'm highly opininated on such literature, but this book really lived up to my expectations.

Basically, if you are looking for a concise and very 'to the point' book on ADO.NET, particularly if you have a decent understanding of the technology, you'll be glad you bought this book. I have bought and loved every title MacDonald has written, and this book is a great example of why.

(Review Data Last Updated: 2006-07-07 13:07:23 EST)
08-12-03 5 4\5
(Hide Review...)  Strong Addition
Reviewer Permalink
This nutshell book is a strong addition to the line. If you've had the opportunity to use these books before, then you'll be in a good position to take advantage of what this one can offer. Although this book was written as both an introduction as well as a reference, I found that it was much more beneficial to use it when encountering specific situations. The authors take time to ensure that there are examples for every topic and I found that the add-in provided in the CD was invaluable...
(Review Data Last Updated: 2006-07-07 13:07:23 EST)
07-06-03 5 8\9
(Hide Review...)  Lives up to the tradition of other Nutshell books
Reviewer Permalink
I have always been a fan of the O'Reilly Nutshell series, and this book lives up to the tradition of its predecessors. However, this book actually goes one step further: all the content in the book is provided on an accompanying CD, which integrates an electronic version of the book directly into Visual Studio .NET. This means that (like the regular MSDN documentation), the O'Reilly documentation becomes a part of your context-sensitive help. Now that's pretty cool!

The book is current with the 1.1 version of the Framework, which is a big deal, since there were some pretty significant changes to XML in this release (which is integral to ADO.NET). Like all the other Nutshell books, this one begins out with a quick introduction to all of the more popular classes in ADO.NET through explanation and examples of use. I personally enjoyed the section on DataTables, as there is a lot of discussion on things I don't normally do in conjunction with DataTables, like computing aggregate calculations and merging data sets.

Even though this is an ADO.NET book, the authors realize that you can't talk about just ADO.NET, you really need some discussion on implementing the data in a GUI (like using a DataGrid). The authors actually spend some time discussing various issues in data binding and various methods for retrieving and displaying data via this mechanism.

Finally, there is considerable discussion (for a Nutshell book) on the relationship between a DataSet and XML. This discussion also includes the basics of using an XSLT to transform XML.

(Review Data Last Updated: 2006-07-07 13:07:23 EST)
06-23-03 4 3\4
(Hide Review...)  Very Helpful.
Reviewer Permalink
I have thumbed through a few .net and one ado.net books and this has been pretty much the most useful for me. The other ado.net book by David Sceppa was ok, but typical for Microsoft, its heavy on the wizards and stuff so I didn't learn as much as I might have. Plus, in my case, the wizards didnt always work because I was trying to hook up to FoxPro, not SqlServer. This book has a tendency to see things from Sqlservers point of view too, even though ado.net can work with alot of rdbmss. Anyway, if you are familiar with Oreillys nutshell books, Unix in a Nutshell for example, you will have an idea of what is up with this book. Its an excellent addition to Oreillys line.
(Review Data Last Updated: 2006-07-07 13:07:23 EST)
  
                  Reader Reviews 1 - 10 of 10                 
  
  
  
  
  
  

Because the data used to generate this site come from outside sources, VeryWellSaid.com cannot guarantee the completeness or accuracy of the data.
Search VeryWellSaid™
Google
Web VeryWellSaid™
New subjects are added every week.
View Subjects Below by:
* Top Selling
 (click category name, left)
* Top-Rated Top Sellers
 (click 'Top Rated', right)
In the news...  
Dubai\UAE Top Rated
Influenza\Bird Flu Top Rated
Iraq Top Rated
Supreme Court Top Rated
All Books Top Rated
Arts Top Rated
Photography Top Rated
Digital Photography Top Rated
Digital Cameras Top Rated
Biography Top Rated
Business Top Rated
Management Top Rated
Marketing Top Rated
Sales Top Rated
Stocks Top Rated
Bonds Top Rated
Real Estate Top Rated
Trading Top Rated
Commodities Trading Top Rated
Time Management Top Rated
Starting A Business Top Rated
Children's Top Rated
Comics Top Rated
Computers Top Rated
PC Top Rated
Mac Top Rated
Programming Top Rated
Design Patterns Top Rated
.Net Top Rated
C# Top Rated
Vb.Net Top Rated
Asp.Net Top Rated
Java Top Rated
Python Top Rated
PHP Top Rated
Perl Top Rated
Javascript Top Rated
Ajax Top Rated
CSS Top Rated
Open Source Top Rated
SQL Top Rated
Databases Top Rated
Oracle Top Rated
MySql Top Rated
Sql Server Top Rated
IIS Top Rated
Apache Top Rated
Linux Top Rated
Windows Server Top Rated
Project Management Top Rated
HTML Top Rated
UML Top Rated
IT Certifications Top Rated
Cisco Certifications Top Rated
MCSE Top Rated
MCSD Top Rated
Cooking Top Rated
Italian Cooking Top Rated
Vegetarian Cooking Top Rated
Wine Top Rated
Engineering Top Rated
Entertainment Top Rated
Health Top Rated
Nutrition Top Rated
Dieting Top Rated
Sex Top Rated
History Top Rated
Military History Top Rated
British History Top Rated
Middle East History Top Rated
Land Battles Top Rated
Naval Warfare Top Rated
Air Warfare Top Rated
9/11 Top Rated
Terrorism Top Rated
Home Top Rated
Mortgage\Home Equity Loan Top Rated
Cars Top Rated
Car Buying Top Rated
Sports Cars Top Rated
Cat Top Rated
Humor Top Rated
Horror Top Rated
Law Top Rated
IP Law Top Rated
Legal History Top Rated
Fiction Top Rated
Oprah's Book Club Top Rated
Medicine Top Rated
Cancer Top Rated
Stroke Top Rated
Heart Disease Top Rated
Fertility Top Rated
Diabetes Top Rated
Pharmacology Top Rated
Back Problems Top Rated
Menopause Top Rated
Thyroid Top Rated
Pain Top Rated
Organic Chemistry Top Rated
Immune System Top Rated
Mystery Top Rated
Nonfiction Top Rated
Outdoors Top Rated
Running Top Rated
Radio Control Models Top Rated
Guns Top Rated
Parenting Top Rated
Divorce Top Rated
Professional Top Rated
Reference Top Rated
Religion Top Rated
Romance Top Rated
Science Top Rated
Physics Top Rated
Chemistry Top Rated
Astronomy Top Rated
Psychology Top Rated
Science Fiction Top Rated
Sports Top Rated
Teens Top Rated
Travel Top Rated
USA Top Rated
Europe Top Rated
France Top Rated
Italy Top Rated
England Top Rated
China Top Rated
All Books Arts Biography Click Here For An A-Z Index Of All 213 Best-Seller Subjects Business Children's Comics
Computers Cooking Engineering Entertainment Health History Home Horror Humor Law Fiction Medicine Mystery
Nonfiction Outdoors Parenting Professional Reference Religion Romance Science Sci-Fi Sports Teens Travel
In Association with Amazon.com

Cache miss
(not cached)