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...

Difference between ADO and ADO.Net

Answer Posted / sandyni

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is ado recordset?

945


What is the maximum pool size in ado.net connection string?

913


What are the Data providers in ADO.Net?

978


Describe the disconnected architecture of ADO.NET’s data access model.

1029


How can we add relation between tables in a dataset?

961


How does ado.net work?

891


Describe connection object in ado.net

1009


Explain the difference in record set and dataset?

907


Can datareader hold data from multiple tables?

1145


What is data reader in ado.net?

974


What does executenonquery () method return?

904


Explain the advantages and disadvantages of using datalist?

1044


Why is stored procedure used in ado.net?

1068


Explain ado.net features? Benefits? Drawbacks?

1015


What is dao and ado?

899