Home > DeveloperSection > Forums > What is ADO.NET?
yash Singh
yash Singh

Total Post:15

Points:105
Posted on    December-07-2010 5:37 AM

 ADO.Net ADO.Net 
Ratings:


 2 Reply(s)
 1197  View(s)
Rate this:

What is ADO.NET?



Pushpendra Singh

Total Post:9

Points:63
Posted on    December-07-2010 6:12 AM

What is Ado.net

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



Uttam Misra

Total Post:124

Points:888
Posted on    December-14-2010 2:46 AM

Yash you can post conceptual question in Interview Section of MindStick.
Thanks!

Don't want to miss updates? Please click the below button!

Follow MindStick