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 mobile phone number.

Programming Microsoft® ADO.NET 2.0 Applications: Advanced Topics (Developer Reference) 2005 ed. Edition

4.2 out of 5 stars 11 customer reviews
ISBN-13: 978-0735621411
ISBN-10: 0735621411
Why is ISBN important?
ISBN
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
Buy used On clicking this link, a new layer will be open
$13.23 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$49.99 On clicking this link, a new layer will be open
More Buying Choices
17 New from $19.90 29 Used from $0.01
Free Two-Day Shipping for College Students with Prime Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Windows10ForDummiesVideo
Windows 10 For Dummies Video Training
Get up to speed with Windows 10 with this video training course from For Dummies. Learn more.
$49.99 FREE Shipping. Temporarily out of stock. Order now and we'll deliver when available. We'll e-mail you with an estimated delivery date as soon as we have more information. Your account will only be charged when we ship the item. Ships from and sold by Amazon.com. Gift-wrap available.
click to open popover

Editorial Reviews

From the Publisher

This reference delves into more than a dozen beyond-the-basics topics that are not thoroughly explored in other books on ADO.NET 2.0, providing the guidance needed to help master advanced features.

Key Book Benefits:

• Covers advanced topics—including using ObjectSpaces, the DataView control, and security issues—not explored at length or in-depth in most other ADO.NET references

• Provides reference information as well as hands-on code explorations of complex ADO.NET topics

• Features extensive code examples on a companion Web site

About the Author

Glenn Johnson is a trainer and writer focusing on ASP.NET, ADO.NET, C#, and .NET internals. He is author of Programming Microsoft® ADO.NET 2.0 Applications: Advanced Topics.

NO_CONTENT_IN_FEATURE

The latest book club pick from Oprah
"The Underground Railroad" by Colson Whitehead is a magnificent novel chronicling a young slave's adventures as she makes a desperate bid for freedom in the antebellum South. See more

Product Details

  • Series: Developer Reference
  • Paperback: 528 pages
  • Publisher: Microsoft Press; 2005 ed. edition (November 30, 2005)
  • Language: English
  • ISBN-10: 0735621411
  • ISBN-13: 978-0735621411
  • Product Dimensions: 7.4 x 1.3 x 9 inches
  • Shipping Weight: 2.3 pounds (View shipping rates and policies)
  • Average Customer Review: 4.2 out of 5 stars  See all reviews (11 customer reviews)
  • Amazon Best Sellers Rank: #3,285,644 in Books (See Top 100 in Books)

Customer Reviews

Top Customer Reviews

By James de la Bastide on April 8, 2006
Format: Paperback
This is a nice concise book (for a programming book anyway) for ADO.NET 2.0. The book delves deep into ADO.NET 2.0 in a very clear manner. It answered many questions about how ADO.NET works that seem to have eluded me over the years. While the title is Advanced Topics, if you have developed with .NET 1.x this book will pose no problems for you. As a matter of fact I think this book will trump the Core Reference (due in July) of ADO.NET for experienced developers.

First the book dives right into ADO.NET Disconnected classes (the ones we use more Microsoft!) It gives a detailed discussion of the DataTable and DataSet, setting up relations, etc. Then it does the same for Connected ADO.NET classes. This is the general format of the book, discuss one then the same topics with the other. This makes it easier to see the differences in functionality between the disconnected and connected classes.

From there the book only gets better. It gives reasons and examples of working with ADO.NET. It goes over transactions, how to deal with concurrency, and some best practices. This book also includes a chapter on working with the new SQLCLR. It gives the pros and cons of SQLCLR and a good idea when to use it. The chapter on XML Data was of interest to me (probably because of a recent project where SQL Server 2005 and XML would have saved me a ton of heartache) and is a good read for anyone who may have a complex application that requires storage of xml data.

I highly reccomend this book for anyone working ADO.NET. A note that may also be of interest is the fact that the author tries to take advantage of SQL Server 2005 Express Edition where it can be used (which is a good majority). So if you don't have access to a full version of SQL Server 2005 this book does not exclude you.
Comment 30 people found this helpful. 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
Format: Paperback
I just got this book, and I haven't been able to put it down. I have a little experience with ADO.NET in VS2003, but I wanted to quickly get up to speed with ADO.NET 2.0 in VS2005.

The first thing that I found was that the examples were done in both VB.NET and C# so there is no need to think about converting between languages.

Next, I found that the first chapters provide a good overview of the ADO.NET objects, so you can can familiar with the object rather quickly.

After that, the chapters focus on specific topics, (mostly new ADO.NET 2.0 topics) going into detail and giving specific implementation examples.

I like this author's style, obviously this author is also an instructor. I hope to see more books from this author!
Comment 30 people found this helpful. 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
Format: Paperback
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.
Read more ›
2 Comments 35 people found this helpful. 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
Format: Paperback
I finally found an ADO.NET book that gave an example of how to perform conflict resolution that is useable. This book quickly cover the objects in ADO.NET, but then goes much further by applying covering topics that are new in ADO.NET 2.0 as well as topics that not new to ADO.NET 2.0, but are never covered in other books.

Pablo Castro wrote the forward for this book, and I agree with everything that he said about this book.
Comment 22 people found this helpful. 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
Format: Paperback Verified Purchase
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.
Comment 7 people found this helpful. 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