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

Explain all the classes those are used for database connections between sql server and asp.net?

507


What are all the commands used with Data Adapter?

518


What is the use of connection object in ado.net?

566


What is the difference between a datareader and a dataset?

518


What are the ado.net objects?

510






How to check if a datareader is closed or opened? IsClosed()

586


What is executequery?

496


What is microsoft ado.net?

578


What are three methods for displaying data in a syncfusion datagrid

612


How do you merge 2 datasets into the third dataset in a simple manner?

537


What is Data view?

562


What is Data Provider?

570


What is linq and entity framework?

514


Define connection string?

586


What is the DataTableCollection?

575