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 are the ado.net objects?
How to create data relations?
Explain the namespaces in which .net has the data functionality class.
Which object holds only data and does not interact with data source?
What is a dataview?
what are types of Dataset ?
Why do we need ado.net?
What is connection pooling and what is the maximum pool size in ado.net connection string?
What do you mean by ‘batch updates’?
What are all the different methods under sqlcommand?
What is the functionality of data provider in ado.net?
Can we load multiple tables in a dataset?
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)