GeekInterview.com
Series: Subject: Topic:
Question: 14 of 169

ADO.NET

What is ADO .NET? Define the Data providers and classes of ADO.net and its purpose with example?
Asked by: rajula.rafeeq | Member Since Jun-2008 | Asked on: Jun 9th, 2008

View all questions by rajula.rafeeq

Showing Answers 1 - 2 of 2 Answers
priyanka roy

Answered On : Aug 27th, 2010

View all answers by priyanka roy

ADO.Net: Activex data obejct.


The most important section in ADO.NET architecture is "Data Provider". 
Data Provider provides access to datasource (SQL SERVER, ACCESS, ORACLE). 
In short it provides object to achieve functionalities like opening and closing
connection, retrieve data and update data.  In the below figure you can see
the four main sections:


Connection

Command

Dataadapter

Datareader.


  
Login to rate this answer.
sairam

Answered On : Oct 23rd, 2011

ADO.Net: Activex data obejct.
By using ADO.NET data can be retrieved from one data source and saved in another. ADO.NET is a part of .NET framework architecture.

A DATA PROVIDER is used for connecting to a database,retrieving data,storing the data in a dataset,reading data and updating the database.
four main types of data provider are:- SQL SERVER , OLE DB , ODBC , ORACLE

THE FOUR KEY COMPONENTS OF A DATA PROVIDER ARE:- connection , command, data reader, data adapter

  
Login to rate this answer.

Give your answer:

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

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.