What is ADO.NET

  • Interview Candidate
  • 27
  • 5542

Editorial / Best Answer

Ranjit  

  • Member Since Oct-2005 | Nov 28th, 2005

ADO.NET is the primary relational data access model for Microsoft .NET-based applications. It may be used to access data sources for which there is a specific .NET Provider, or, via a .NET Bridge Provider, for which there is a specific OLE DB Provider, ODBC Driver, or JDBC Driver. ADO.NET is sometimes considered an evolution of ADO technology, but it is important to note that some major changes were made between the two.

Showing Answers 1 - 27 of 27 Answers

kulwant kumar Fatehpur Gaya

  • Oct 4th, 2005
 

 

ADO.NET—the data-access component of the Microsoft .NET Framework—works with any component on any  platform that understands XML.

  Was this answer useful?  Yes

kokilavani

  • Oct 20th, 2005
 

ADO.NET is the primary relational data access model for Microsoft .NET-based applications. It may be used to access data sources for which there is a specific .NET Provider, or, via a .NET Bridge Provider, for which there is a specific OLE DB Provider, ODBC Driver, or JDBC Driver.

parikshit

  • Oct 20th, 2005
 

ado.net is disconneted ado. unlike ado u dont have to be connected always to reterive the data it is fast. all these things can be achieved using dataset,dataadapter,datareader etc

  Was this answer useful?  Yes

harish

  • Nov 3rd, 2005
 

This Kind of Technical questions are very help full to us ..

Thanks

Harish

  Was this answer useful?  Yes

ramana606

  • Nov 7th, 2005
 

Access Data Object

  Was this answer useful?  Yes

sanker

  • Nov 9th, 2005
 

ADO.NET consists of classes that make up the DataSet (such as tables, rows, columns, relations, and so on), .NET Framework data providers, and custom type definitions (such as SqlTypes for SQL Server).

  Was this answer useful?  Yes

Ranjit

  • Nov 28th, 2005
 

ADO.NET is the primary relational data access model for Microsoft .NET-based applications. It may be used to access data sources for which there is a specific .NET Provider, or, via a .NET Bridge Provider, for which there is a specific OLE DB Provider, ODBC Driver, or JDBC Driver. ADO.NET is sometimes considered an evolution of ADO technology, but it is important to note that some major changes were made between the two.

Simeptk

  • Dec 17th, 2005
 

ADO.NET is also a part of the .NET Framework. ADO.NET is used to handle data access. With ADO.NET you can work with databases.

  Was this answer useful?  Yes

balaji

  • Feb 18th, 2006
 

Activex Data Object

  Was this answer useful?  Yes

krish_saravana

  • Mar 28th, 2006
 

ADO.NET is an recentand effective Data Access Techclogies for .NET framework comes under the way of ODBC API.

It provide the disconnected may of manipulating data across the application

  Was this answer useful?  Yes

Jayashree .N Ragavan

  • Apr 8th, 2006
 

Like ADO, ADO.NET  is a application Programming Interface(API) to access data & information. ADO.NET is the primary library for building  solutions within the .NET framework. It is true that ADO.NET is based on the ADO Model but there is a lot of difference, the principal difference being that ADO.NET supports disconnected data access, thus accommodates scalabilty by encouraging programmers to conserve limited resources through disconnected access. The ADO.NET uses XML format for transmission of data

  Was this answer useful?  Yes

akhilesh kumar srivastava

  • Apr 16th, 2006
 

1.ado.net is successor to ado.

2.ADO.net does not depend on continuosly live connections.

3.Database connection/interactions are performed using data connections.

4.Data can be Cached in Datasets.

5.Datasets are independent of Data Source.

6.Data is persisted as xml.

7.Schemas define data structures.

8.It access the native library so it is much faster then oracle & oledb provider ,it was written with the lost of help from the SQL SERVER team.

  Was this answer useful?  Yes

Mangesh

  • Apr 22nd, 2006
 

Don't misguide. The full form of ADO is ActiveX Data Object.

  Was this answer useful?  Yes

Natarajan

  • Apr 24th, 2006
 

Thanks Very useful

  Was this answer useful?  Yes

Dipesh Gandhi

  • Apr 26th, 2006
 

ADO.NET is a set of classes that expose data access services to the .NET programmer. ADO.NET provides functionality to developers writing managed code similar to the functionality provided to native COM developers by ADO. ADO.NET provides consistent access to data sources such as Microsoft? SQL Server?, as well as data sources exposed through OLE DB and XML. Data-sharing consumer applications can use ADO.NET to connect to these data sources and retrieve, manipulate, and update data.

ADO.NET provides a rich set of components for creating distributed, data-sharing applications. It is an integral part of the .NET Framework, providing access to relational data, XML, and application data. ADO.NET supports a variety of development needs, including the creation of front-end database clients and middle-tier business objects used by applications, tools, languages, or Internet browsers.

  Was this answer useful?  Yes

skumar

  • May 23rd, 2006
 

ado.net is a technology designed to let a .net program access with data.typically we use ado.net to accessa relational database.but u could also use it to work with raw xml information

  Was this answer useful?  Yes

vamsi krishna

  • Jun 13th, 2006
 

ADO.Net is a object library to communicate with Database

  Was this answer useful?  Yes

Manju D J

  • Jun 19th, 2006
 

 ADO.NET is the Data Access Technology Built into the .NET Framework.

  Was this answer useful?  Yes

sahu

  • Mar 29th, 2007
 

Hi All,


Ans:


ADO.NET is Consists of  Classes , by using classes like (SqlConnection,SqlDataAdapter etc), , it help to create relationship between  Bussines Logic and Database.

  Was this answer useful?  Yes

scorpiansarath

  • Apr 16th, 2007
 

ado.net is a disconnected architecture,i.e every time we need not to connect to database.A copy of database table is taken from database to application by data set

  Was this answer useful?  Yes

prabhakar

  • Jun 5th, 2007
 

ADO.NET is disconnected model to any database or datasource, no need to connect continuously.

  Was this answer useful?  Yes

puneet verma

  • Sep 11th, 2007
 

ADO is all about accesing database that includes tables and the various ways to format them

  Was this answer useful?  Yes

shravanmadhastu

  • May 24th, 2008
 

ADO.NET stands Active X Data Objects.Net.
It is used in microsoft.net to communicate with datastore.
ADO.NET is inherited from System.Data.dll name space
ADO.NET has two components
they are 1. .Net Data providers
              2. Data set

.Net data provider is used in  Connection  oriented  architecture,Data set is used in  Connection less  architecture(Disconnected architecture) with XML integration while retrieving data from the data store.

Microsoft is providing following dotnet data providers
1. OLEDB .Net data provider
    
  .Net Application-------->OLEDB.NET------->OLEDB Provider------->Data store

2. ODBC .Net data provider
  .Net Application-------->ODBC.NET-------->ODBC driver--------->Data store

3. SQL SERVER .Net data provider
  .Net Application-------->SQL SERVER.NET---->TDS------------>SQL SERVER 7.0 or Later

4. Oracle .Net data provider
   .Net Application-------->Oracle.NET-------->TNS-------------->Oracle 8.0 or Later


 

  Was this answer useful?  Yes

Pendurti

  • Sep 11th, 2008
 

ADO.NET is something that allows us to interact with relational databases and other data sources. It is a technology that ASP.NET applications use to communicate with a database, whether we need to add a new customer record, make a  purchase, or display a product catalog. 

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.