What is ADO.NET

ActiveX Data Objects (ADO.NET) is an application program interface developed by Microsoft which allows programmers to have access to a relational or non-relational database from both Microsoft and other database providers. ADO has a set of Component Object Model (COM) objects for accessing data sources.

ADO is a part of MDAC (Microsoft Data Access Components), which provides a middleware layer between programming languages and OLE DB. ADO allows a developer to write programs that can access data without knowing how the database is implemented or constructed; except developers must be aware of the database for connection only.

No knowledge of SQL is required to access a database when using ADO, even though you can use ADO to execute SQL commands directly. For instance, if you wanted to write a program that would provide users of your Web site with data from an IBM DB2 database or an Oracle database, you could include ADO program statements in an HTML file that you then saved as an Active Server Page. Then, when a user requested the page from the Web site, the page sent back would contain exact data from a database, obtained using ADO code...READ MORE >>>
Credits: SIITGO