Microsoft ADO.NET for SQL Server
ADO.NET is the core data access technology for .NET languages. Use the Microsoft.Data.SqlClient namespace to access SQL Server, or providers from other suppliers to access their stores. Use System.Data.Odbc or System.Data.Oledb to access data from .NET languages using other data access technologies. Use System.Data.Dataset when you need an offline data cache in client applications. It also provides local persistence and XML capabilities that can be useful in web services.
Getting started
- Step 1: Configure development environment for ADO.NET development
- Step 2: Create a SQL database for ADO.NET development
- Step 3: Proof of concept connecting to SQL using ADO.NET
- Step 4: Connect resiliently to SQL with ADO.NET
Documentation
- ADO.NET Overview
- Getting started with the SqlClient driver
- Overview of the SqlClient driver
- Data type mappings in ADO.NET
- Retrieving and modifying data in ADO.NET
- SQL Server and ADO.NET