WHAT Are the major major compnents of a data provider in
ADO.net.

Answer Posted / tejas mer

DataAdapter and DataSet are major parts of ADO.NET


DataReader is connected architecture and it's read-only, forward only type, so when you just want to display the data better to use it, it consumes less memory with compare to dataset as well.

DataSet is we can say in-memory representation of the data.
It's disconnected architecture.
Contains DataTables, which are further divided into Datarows and Datacolumns.
Also contains DataRelationships and Contraints...

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is different between sqlcommand object and command behavior object?

519


What is an ADO.Net?

549


What is command class in ado.net?

457


What is ole data type?

487


How to check if the Dataset has records ?

516






How to aggregating data across related tables?

534


Why do we use sqldataadapter?

459


What is the use of sqldatareader class?

451


How can we load multiple tables in a dataset?

510


What is the difference between executequery and executenonquery?

487


What is data relation?

484


Define isolation?

520


Which provider is used to connect ms access, oracle, etc…?

502


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

479


What is namespace in ado.net?

484