Web Directory

» .NET Data Access Architecture Guide
   The information in this article covers the new data access objects including the DataSet and DataAdapter classes in ADO.NET.
   http://msdn.microsoft.com/en-us/library/ms978510.aspx

» A Practical Comparison of ADO and ADO.NET
   An informational comparison between ASP.NET and ASP which highlights the advantages and differences between the two. Article by Joe O'Donnell.
   http://www.devarticles.com/c/a/ADO.NET/A-Practical-Comparison-of-ADO-and-ADO.NET/

» ADO.NET Overview
   A brief overview of ADO.NET with a description of the technical terms associated with the data access technology.
   http://www.developer.com/net/vb/article.php/1540311

» ADO.NET Primer
   A tutorial that gives an overview of what ADO.NET is and how to use it with ASP.NET programming.
   http://www.aspalliance.com/aspxtreme/adonet/adonetprimer.aspx

» ADO.NET's Primary Objects
   Overview of the seven main objects in the ADO.NET data-access architecture. By Michael Otey, SQL Server Magazine.
   http://www.sqlmag.com/Articles/Index.cfm?ArticleID=16557

» Best Practices for Using ADO.NET
   Best practices for writing Microsoft ADO.NET code and suggestions for developers on using the objects available in ADO.NET.
   http://msdn.microsoft.com/en-us/library/ms971481.aspx

» Designing Data Tier Components and Passing Data Through Tiers
   Learn how to best expose your data to Microsoft .NET applications and how to implement an effective strategy for passing data between the tiers in a distributed application.
   http://msdn.microsoft.com/en-us/library/ms978496.aspx

» Getting Started with ADO.NET
   A brief introduction to ADO.NET that explains what objects are necessary for data access.
   http://www.devcity.net/Articles/14/start_ado_net.aspx

» Introduction to ADO.NET
   A descriptive introduction to ADO.NET
   http://articles.sitepoint.com/article/introduction-ado-net

» Managing an @@IDENTITY Crisis
   Discusses a strategy for returning newly created Identity values after the INSERT is executed. This applies to SQL Server and ADO.NET
   http://msdn.microsoft.com/en-us/library/ms971502.aspx

» O'Reilly Network: Multiple ResultSets in ADO.NET [Dec. 16, 2002]
   An article that shows how to get multiple results from a database to DataSets and DataReaders
   http://www.ondotnet.com/pub/a/dotnet/2002/12/16/multiresultsets_1202.html

» O'Reilly Network: Transparent Database Access with ADO.NET [Dec. 16, 2002]
   An article that shows how to use ADO.NET's different providers and transparently use it in your application without having to know the specifics of each provider.
   http://www.ondotnet.com/pub/a/dotnet/2002/12/16/transadonet.html

» Reading Data Reader Secrets
   MSDN Online Voices Diving Into Data Access column on reading data readers secrets.
   http://msdn.microsoft.com/en-us/library/ms810288.aspx

» Transaction Control
   This article describes how to run local and distributed transactions in your Microsoft .NET applications.
   http://msdn.microsoft.com/en-us/library/ms978457.aspx

» Using ADO.NET
   Discusses using ADO.NET Connection object, other ADO.NET objects, and provides examples. A 41-page article by Paul D. Sheriff of PDSA, Inc.
   http://msdn.microsoft.com/en-us/library/aa302325.aspx

» Weaning Developers from the CommandBuilder
   Examines the drawbacks of the ADO.NET CommandBuilder, and shows how to use the Visual Studio .NET DataAdapter Configuration Wizard (DACW) to write your own Command queries.
   http://msdn.microsoft.com/en-us/library/ms971491.aspx