Get in-depth coverage and expert insights on advanced ADO.NET programming topics such as optimization, DataView, and large objects (BLOBs and CLOBs). Targeting experienced, professional software developers who design and develop enterprise applications, this book assumes that the reader knows and understands the basic functionality and concepts of ADO.NET 2.0 and that he or she is ready to move to mastering data-manipulation skills in Microsoft Windows®. The book is structured so readers can jump in for reference on each topic as needed, complete with pragmatic and instructive code examples.

Amazon.com® Reader Reviews (Ranked by Helpfulness)

Average Amazon.com® Rating:  Based on 9 Ratings

Good not Great... - 2006-07-17
Reviewer Rating:
Glenn Johnson has a very good book here on ADO.NET 2.0. Unfortunately, it just good not great. Here are my pros and cons:

Pros:

1. Well written and thought out.
2. Excellent coverage of ADO.NET Trace Logging.
3. Coverage of LOBs/BLOBs/CLOBs is very well thought out.
4. Discussion of Connection Pooling is very good.
5. Coverage of writting your own classes that work with System.Transactions is invalulable.

Cons:

1. Too many basic topics covered for an "Advanced Topics" book.
2. ASP.NET GridView/WinForms GridView chapters are unnecessary and incomplete.
3. Code examples are terse and somewhat unreadable (no blank lines).
4. Some information inaccurate (e.g. Suggestion of using Database Mirroring in SQL Server 2005 which was dropped as a supported feature.)
5. SQL Server Specific...lackluster Oracle, ODBC, OleDb coverage.
6. Data Caching only discusses caching with SqlDependencyCache. There are a myriad of caching options, and this is only one of them.

While not really a problem with the book, I disagree with the author in a number of assertions:

- He pushes the idea of GUIDs as keys, but never discusses the index fragmentation issue with GUIDs as keys.
- His discussion of SQLCLR doesn't warn the users enough (I know "enough" is a subjective phrase) that they shouldn't write all their code in SQLCLR.
- Mentions that "The 8,000-byte limit is much higher than you should ever need." when discussing SQLCLR User Defined Types. -- I disagree since a single object might not reach that, but a shallow object graph will reach 8K very easily.
- No comparison between SQLCLR UDT's and XML Typed XML.
- Using XML in SQL Server is touted instead of disuaded. More often than not, storing your XML in SQL Server just to have it there (or without dissecting it into relational data) will just hurt performance and raise the complexity of a system.

I gave the book a four out of five starts on Amazon.com because I think it will be a valuable resource for most developers. But it is not a perfect book.

Not quite what I was expecting. - 2006-06-30
Reviewer Rating:
This book does delve deep into the plumbing of ADO.Net 2.0, but I must admit that when I read the "Advanced Topics" part of the title, I thought that it would actually cover more complicated versions of some scenarios that might be found in "beginners" ADO.Net books such as handling many-to-many data relationships with bound controls and possibly designing and building a data access layer. While data access layers were covered to some degree, the described methods involved intensive interaction with SQL Server system tables - something I don't tend to make a practice of.

The information in the book is good, just not what I was hoping to find.

Ok book. Not so advanced - 2007-01-18
Reviewer Rating:
Here it is. It's an ok book. But I have to agree with one of the previous post about the GUId Keys. I also found that the grid topics were not need it as well as the overview (the first two chapters.) If is advanced, I'm assuming the reader knows that or has another book.
I think that saving 4 to 6 chapters that were not need it, they could have extended the book to be far more advanced and concentrate in transactions, SQLCLR and so on.

Great book, missing practical use. - 2006-05-03
Reviewer Rating:
Great book for ado.net. I wish this book has covered "how to use new features of ado.net with business layer. There should be some more chapter(s) for data acesss layer utilizing ado.net.

Very good book, lacks some in depth topic - 2008-04-07
Reviewer Rating:
This is a very good book, well written, the author has a clean style that I enjoyed very much. All topics are extensively covered with small but very useful examples. No pages of code: Just what is needed.
I give 4 stars only because it lacks explaining some in depth argument such as subclassing datasets or typed datatables. I expect a new edition with add-ins that will cover those new topics.

Browse Similar Topics

Top Level Categories:
Internet/Online

Sub-Categories:
Internet/Online > .Net
.Net > ADO.NET