ADO.NET, an object oriented data access technology, is essentially a collection of classes used to communicate between an application and a database. ADO.NET provides consistent access to data sources such as Microsoft SQL Server. The ADO.NET classes are found in System.Data.dll.
DataProvider in Ado.net
The following are the supported DataProviders:
• Odbc Data Provider
• OleDb Data Provider
• Oracle Data Provider
• SqlServer Data Provider
Connection
The following are the supported Connection classes:
• OleDbConnection
• OdbcConnection
• OracleConnection
• SqlConnection
Command
The Command object is used to send the SQL Statements to the database. Commands are used to insert data, retrieve data and execute stored procedures in the database. The following are the methods of the Command class:
• ExecuteScalar
• ExecuteReader
• ExecuteNonQuery
• ExecuteXmlReader
Liked By
Write Answer
What is ADO.NET?
Join MindStick Community
You have need login or register for voting of answers or question.
Uttam Misra
14-Dec-2010Thanks!
Pushpendra Singh
07-Dec-2010ADO.NET, an object oriented data access technology, is essentially a collection of classes used to communicate between an application and a database. ADO.NET provides consistent access to data sources such as Microsoft SQL Server. The ADO.NET classes are found in System.Data.dll.
DataProvider in Ado.net
The following are the supported DataProviders:
• Odbc Data Provider
• OleDb Data Provider
• Oracle Data Provider
• SqlServer Data Provider
Connection
The following are the supported Connection classes:
• OleDbConnection
• OdbcConnection
• OracleConnection
• SqlConnection
Command
The Command object is used to send the SQL Statements to the database. Commands are used to insert data, retrieve data and execute stored procedures in the database. The following are the methods of the Command class:
• ExecuteScalar
• ExecuteReader
• ExecuteNonQuery
• ExecuteXmlReader