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

Define Execute Scalar?

1023


What are the different layers of ado.net?

1083


Explain executenonquery?

1141


What is difference in record set and dataset?

1078


What is sqldatareader?

923


How would you connect to a database by using .NET?

942


Does entity framework use ado.net?

990


What is ado connection?

960


What is difference between dataset and datatable?

1183


What is data relation?

926


Explain why edit is not possible in repeater?

1040


differance between ADO vs ADO.Net?

1066


What are the advantages using ado.net?

1039


What are the differences between OLEDB and SQLClient Providers?

1165


Which is faster sqldataadapter and sqldatareader?

931