WHAT Are the major major compnents of a data provider in
ADO.net.
Answers were Sorted based on User's Feedback
Answer / niti
Major components of data provider in ADO.net indlude:
SQLDataProvider
OLEDBDataProvider
ODBCDataProvider
Various objects of the data provider include:
Connection object,
Command object,
Data Adapter,
Data Set,
Data Table
| Is This Answer Correct ? | 17 Yes | 1 No |
Answer / puneet sharma
....dataadapter is the major comp of dataprovider
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / ranjeet kumar panda
.NET Framework data provider, which is a set of components:
Connection objects,
Command objects,
DataReader objects,
DataAdapter objects
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / 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 |
Answer / tubax
command object
connection object
datareader
dataset
dataadapter
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / sanjogita
The two major components of data provider are:-
1)command
2)connection
3)data reader
4)data adapter
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / nivedita
components are
command
connection
reader
adopter
| Is This Answer Correct ? | 0 Yes | 0 No |
What is disconnected architecture in ado.net?
How can we add/remove row's in "datatable" object of "dataset"?
What is ado.net object model?
Difference between OLEDB Provider and SqlClient ?
What are the steps you will take to improve performance? Will you use dataset or datareader?
Difference between function and trigger?
Features and disadvantages of dataset?
2 Answers CarrizalSoft Technologies, Infosys, Microsoft, Sampath Software,
Which property is used to check whether a DataReader is closed or opened?
Define Execute Reader?
Which is better ole db or odbc?
What is a serialized object?
Explain the ADO . Net Architecture ( .Net Data Provider) ?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)