Microsoft ADO.NET for SQL Server and Azure SQL Database
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.
Getting started (SQL Server)
Getting started (Azure SQL Database)
- 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