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
.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.
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
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.
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.
Reading Data Reader Secrets
MSDN Online Voices Diving Into Data Access column on reading data readers secrets.
Transaction Control
This article describes how to run local and distributed transactions in your Microsoft .NET applications.
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.
Using Stored Procedures in Visual Basic .NET
Billy Hollis explains the benefits of stored procedures for complex systems and takes stored procedures beyond the level of demoware and provides some hands-on examples of how you can access stored procedures and start using them in your own applications.
Visual Studio Magazine - Follow the Top 10 ADO.NET Tips
Use Oracle With ADO.NET - An article that shows how to use Oracle with ADO.NET
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.
Working with MS Access Stored Procedures in VB.NET. Part 1
Shows how to use Stored Procedures, which is usually a feature of high-end databases, in Microsoft Access.
Results: Previous 1 2 3 4