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

Define bubbled event?

515


Which object is used to add relationship between two Datatables?

580


What are the connected and disconnected modes in ado.net?

491


What is DataRowCollection?

629


What are the classes in System.Data.Common Namespace?

709






Describe the command object and its method.

526


Explain the dataadapter class in ado.net?

664


What is executenonquery ado.net?

502


What is difference between entity framework and ado.net?

482


What is dataadapter in ado.net?

501


Explain what is datagrid with an example?

588


What is the default provider in ado.net?

519


What are three methods for displaying data in a syncfusion datagrid

614


What are ado.net objects?

532


What provider ado.net use by default? Explain the role of data provider in ado.net?

530