Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Can you explain the difference between an ADO.NET Dataset
and an ADO Recordset?

Answers were Sorted based on User's Feedback



Can you explain the difference between an ADO.NET Dataset and an ADO Recordset?..

Answer / thangaraj.r

. 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 ?    7 Yes 0 No

Can you explain the difference between an ADO.NET Dataset and an ADO Recordset?..

Answer / kvnvani

1. In ADO recordset(in memory representation of data) looks
like single table
where as
in ADO.NET dataset(in-memory representation of data) is a
collection of one or more tables(use JOIN Query).
2. In ADO you communicate with the database by making the
calls to an OLEDB Provider
where as
in ADO.NET you communicate with the database through a Data
Adapter(an OledbDataAdapter,SQLDataAdapter,OdbcDataAdapter
or OracleDataAdapter object) which make calls to an OLEDB
Provider or the API's provided by the underlying datasource.
3. In ADO recordset objects operate in a fully connected
state
where as
in ADO.NET dataset operate in disconnected state.
4. ADO requires COM marshalling to transmit records sets
among components, does require that ADO data types be
converted to COM data types.
where as
ADO.NET does not require data-type conversions.
5. In ADO it is sometime sproblematic firewalls( firewalls
are typically configured to allow HTML text to pass, but to
prevent system-level requests (such as COM marshalling)
from passing) prevent many types of requets
where as
in ADO.NET datasets using XML, firewalls can allow datasets
to pass.

Is This Answer Correct ?    4 Yes 1 No

Can you explain the difference between an ADO.NET Dataset and an ADO Recordset?..

Answer / sathish

Recordset is that where we can access only one table
information. Recordset is also that we can access record
sequentially and any record in middle has to go thro all
first beginning records.So only sequential access is alowwed.

Dataset is we can point to multiple tables.Any record can be
accessed at any instant of time.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More ASP.NET Interview Questions

From which base class all web forms are inherited?

0 Answers  


what is CLR?

3 Answers   PrimeLine,


how can create login from create and written conde in asp.net

0 Answers  


Describe SOA and the tenets of it?

0 Answers   Siebel,


What is the compiled object?

0 Answers   eXensys,


What is the use of session?

0 Answers  


What are the various types of validation controls provided by asp.net?

0 Answers  


On Age field how many Asp.Net validation controls will be suit?

7 Answers   NTTF Nettur Technical Training Foundation, Quest,


Describe the sequence of action takes place on the server when ASP.NET application starts first time?

0 Answers   CDC,


Explain the difference between singleton and single call?

0 Answers  


Describe the difference between inline and code behind - which is best in a?

0 Answers  


Explain the concept of MVC Scaffolding?

0 Answers   B-Ways TecnoSoft,


Categories