Sample ADO.NET Scenarios

This section includes information about common scenarios in applications working with relational data, and how ADO.NET and the .NET Framework can be used to create a solution.

In This Section

• Retrieving Identity or Autonumber Values
  Provides an example of mapping the value generated for an Identity field in a Microsoft SQL Server table, and an Autonumber field in a Microsoft Access table, to a column of an inserted row in a table.
• Optimistic Concurrency
  Describes the optimistic concurrency model and provides an example of how to test for optimistic concurrency violations using ADO.NET.
• Consuming a DataSet from an XML Web Service
  Provides an example of an XML Web service that returns data from a data source as a DataSet, as well as receives an updated DataSet and resolves the changes back to the data source.
• Paging Through a Query Result
  Provides an example of viewing the results of a query as pages of data.
• Conserving Resources When Writing BLOB Values to SQL Server
  Provides an example of writing a binary large object (BLOB) to a SQL Server database in "chunks" to preserve system memory.

Related Sections

• Accessing Data with ADO.NET
  Describes the ADO.NET architecture and components and how to use them to access existing data sources, as well as to manage application data.