WHAT IS ADO.NET?

yash Singh

Total Post:15

Points:105
Posted by  yash Singh
 1489  View(s)
Ratings:
Rate this:

What is ADO.NET?

  1. Pushpendra Singh

    Post:9

    Points:63
    Re: What is ADO.NET?

    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


  1. Uttam Misra

    Post:126

    Points:906
    Re: What is ADO.NET?

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

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!