ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Microsoft Related  >>  ADO.NET
 
 


 

 
 Visual Basic interview questions  Visual Basic Interview Questions
 C Sharp interview questions  C Sharp Interview Questions
 ASP.NET interview questions  ASP.NET Interview Questions
 VB.NET interview questions  VB.NET Interview Questions
 COM+ interview questions  COM+ Interview Questions
 ADO.NET interview questions  ADO.NET Interview Questions
 IIS interview questions  IIS Interview Questions
 MTS interview questions  MTS Interview Questions
 Crystal Reports interview questions  Crystal Reports Interview Questions
 BizTalk interview questions  BizTalk Interview Questions
 Dot Net interview questions  Dot Net Interview Questions
 Exchange Server interview questions  Exchange Server Interview Questions
 SharePoint interview questions  SharePoint Interview Questions
 Microsoft Related AllOther interview questions  Microsoft Related AllOther Interview Questions
Question
Difference between ADO and ADO.Net
 Question Submitted By :: Resh
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Difference between ADO and ADO.Net
Answer
# 1
ADO has the recordset and connected archtecture where as 
ADO.net has disconnected archtecture and DATASET
 
Is This Answer Correct ?    16 Yes 0 No
Ankit
 
  Re: Difference between ADO and ADO.Net
Answer
# 2
1. ADO used connected data usage, while ADO.net used  
disconnected data environment.
2. ADO used OLE DB to access data and is COM-based, while
ADO.net uses XML as the format for transmitting data to and
from your database and web application.
3. In ADO, Record set, is like a single table or query
result, while in ADO.net Dataset, can contain multiple
tables from any data source.
4. In ADO, it is sometime problematic because firewall
prohibits many types of request, while in ADO.net there is
no such problem because XML is completely firewall-proof.
 
Is This Answer Correct ?    17 Yes 0 No
Guneetinder Singh
 
 
 
  Re: Difference between ADO and ADO.Net
Answer
# 3
ADO is a com base library that supports only connected 
data. This means that when we access the data (view, edit 
and update) it is affected in real-time,since the 
connection is being used all the time. ADO uses the objects 
as reference data known as Recordset object. Hence it 
basically gives a single table view of the data. We can 
also join tables to create a new set of records in ADO.ADO 
allows to create only client-side cursors. Using ADO we can 
persist records in XML format and XML integration is not 
possible. 

ADO.NET is a CLR based library that supports disconnected 
recordsets. This means that When we access data, ADO.NET 
makes a copy of the data using XML and holds the connection 
to pull down the data or to make any requested updates as 
long as we need. The best method to follow is 
ADO.NET.ADO.NET uses various objects known as Dataset that 
allow to access data in various methods. Hence it allows to 
store the relational model of the database and helps us to 
access /update the data in each related table individually. 
ADO.NET supports both client-side and server-side cursors. 
Also the cursors are handled as classes in ADO.NET 
providing a way to create efficient applications. Using 
ADO.NET we can manupulate records in XML format. Also 
ADO.NET 2.0 provides Multiple Active ResultSets (MARS) 
which allows to have two datareader on one connection open 
at sametime.
 
Is This Answer Correct ?    4 Yes 0 No
Manumole
 
  Re: Difference between ADO and ADO.Net
Answer
# 4
Following are some major differences between both

1.As in classic ADO we had client and server side cursors 
they are no more present in ADO.NET. Note it's a 
disconnected model so they are no more applicable.

2. Locking is not supported due to disconnected model.

3. All data persist in XML as compared to classic ADO where 
data persisted in Binary format also.

4. Ado.net uses Dataset where as Ado uses RecordSet.

5.Ado.Net uses Dataproviders where as classic Ado uses COM 
model.

6.Ado.net can able to works on multiple tables where as Ado 
can works on only on etable.
 
Is This Answer Correct ?    2 Yes 0 No
Sandyni
 

 
 
 
Other ADO.NET Interview Questions
 
  Question Asked @ Answers
 
How can you implement sub data grid in a master datagrid?  1
How to generate XML from a dataset and vice versa?  2
once data is fetched into dataset connection gets closed. but in datareader connection is always maintained...then why datareader is fast and mainly recommended ?  2
What is ODP.NET ? TCS1
What is dataset and tell about its features. What are equivalent methods of previous, next etc. Of ADO in ADO.NET ? Digital-GlobalSoft1
Which is the best institute in navi mumbai to learn DotNet  1
explain connection less and with connection?diference between data reader,data set,data adapter? can we use data reader,data set in a single application? if yes explain with simple code,if no explain? Techno-Labs2
How do you handle data concurrency in .NET ?  7
If i am expecting a single result from sqlserverdatabase then what command should i follow ?sqlcommand.executereader (commandbehaviour.singleresult)or sqlcommand.executescalar()  4
Execute nonquery returns no. of afected rows.So if my stored procedure hav lot of select stmnt, delete stmnt, insert stmnt..then what does execute nonquery returns in this case?  1
What is datatable?  3
What are the two fundamental objects in ADO.NET? Ksb3
What are relation objects in dataset and how & where to use them?  1
Difference between datareader and dataset? Microsoft12
Can a DataReader be used as a DataSource for a GridView. If it is so how will you handle paging. Directi3
What is the provider and namespaces being used to access oracle database? Microsoft2
How many commands does the oledbcommand takes?what are they?  2
What is reference by value how does it works in .net? SQL-Star2
What are the Different layers in ADO.Net? eXensys7
What providers do you use to connect to oracle database ? Digital-GlobalSoft4
 
For more ADO.NET Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com