Introduction to ADO.NET

  • Vidya Vrat Agarwal


In industry, most applications can’t be built without having interaction with a database. Databases serve the purpose of data storage so the data can be retrieved later via either a SQL query or a database application. Almost every software application running interacts with either one or multiple databases. Therefore, the front end needs a mechanism to connect with databases, and ADO.NET serves that purpose. Most of the .NET applications that require database functionality are dependent on ADO.NET. In this chapter, we’ll cover the following:
  • Understanding ADO.NET

  • The motivation behind ADO.NET

  • Moving from ADO to ADO.NET

  • Understanding ADO.NET architecture

  • Understanding the SQL Server data provider

  • Understanding the OLE DB data provider

  • Understanding the ODBC data provider

  • Data providers as APIs


Data Provider Class Class Connected Architecture Component Object Model Database Connection 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Vidya Vrat Agarwal 2012

Authors and Affiliations

  • Vidya Vrat Agarwal

There are no affiliations available

Personalised recommendations