| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic |
|---|---|---|---|---|---|---|---|---|
Microsoft ADO.NET |
Microsoft ADO.NET, for SQL Server and Azure SQL, is the core data access technology for .NET languages. Use the Microsoft.Data.SqlClient library to access SQL Server. |
David-Engel |
davidengel |
v-kaywon |
05/06/2020 |
sql |
connectivity |
conceptual |
[!INCLUDEDriver_ADONET_Download]
ADO.NET is the core data access technology for .NET languages. Use the Microsoft.Data.SqlClient library or Entity Framework 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.
::: moniker range=">=sql-server-2016||>=sql-server-linux-2017"
- 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
::: moniker-end
::: moniker range="=azuresqldb-current"
- 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
::: moniker-end