| title | Microsoft ADO.NET for SQL Server | Microsoft Docs |
|---|---|
| description | Introduction to Microsoft ADO.NET for SQL Server. |
| ms.custom | |
| ms.date | 09/30/2019 |
| ms.prod | sql |
| ms.prod_service | connectivity |
| ms.technology | connectivity |
| ms.topic | conceptual |
| ms.assetid | 5e467fce-7237-4678-bafa-a16f32323d0c |
| author | David-Engel |
| ms.author | v-daenge |
| ms.reviewer | v-kaywon |
[!INCLUDEDriver_ADONET_Download]
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.
- 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