GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Microsoft  >  DotNet
Go To First  |  Previous Question  |  Next Question 
 DotNet  |  Question 60 of 165    Print  
Can you explain the difference between an ADO.NET Dataset and an ADO Recordset?

  
Total Answers and Comments: 4 Last Update: July 03, 2006   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
June 16, 2005 22:19:27   #1  
Likitha        

RE: Can you explain the difference between an ADO.NET Dataset and an ADO Recordset?
Data set is useful for large set disconnected data whereas with recordset is possible but cannot stay for longer

With dataset we can use multiple tables in one data set with recordset it is not possible.

We cannot add datarows and coloumns externally to the recordset but for data set it is possible

Also dataset supports external manipulation of datarows and columns wheeras with record set it is not possible



 
Is this answer useful? Yes | No
December 28, 2005 01:18:18   #2  
swag Member Since: December 2005   Contribution: 18    

RE: Can you explain the difference between an ADO.NET ...

You can send dataset using XML marshling where as in case of recordset use COM marshling.In case of COM marshling they have some specified data type.so before before sending the record set you have to convert the data type based on the COM marshling.As XML is open system there is no data type conversion.


 
Is this answer useful? Yes | No
January 13, 2006 07:19:06   #3  
samiksc Member Since: October 2005   Contribution: 233    

RE: Can you explain the difference between an ADO.NET ...

The points of difference are as follows:

  1. ADO.Net dataset can contain data from two or more data sources and relate it in memory. For example you may retrieve emp table from SQL Server 2000 database and salary table from an Excel sheet relate them perform any logical operations and put the integrated data to a new database in SQL server. Whereas ADO recordset will contain records resulting from one query to one data source only.
  2. ADO.Net objects are represented using XML so they can travel through networks and firewalls. That is not the case with ADO recordsets which are COM objects.
  3. Because of XML representation ADO.Net objects are lightweight as compared to ADO recordsets so application scalability improves. The .net objects can be stored in session variables without much impact on scalability of the application.

The similarities in these two are that both of them can be disconnected (actually ADO.Net follows disconnected architecture while ADO recordsets CAN BE disconnected although many times they are used in a connected manner). Both of them offer sorting filtering and batch updates.


 
Is this answer useful? Yes | No
July 03, 2006 13:53:54   #4  
satyambabu53 Member Since: July 2006   Contribution: 8    

RE: Can you explain the difference between an ADO.NET ...

Dataset:-

Data set is the Disconneted data Architecture.

Datareader:-

Datareader is the connected Data Architecture.


 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape