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 |
How to create dynamic gridview?
Is it possible to edit data in Repeater control?
How many major types of connection objects in ADO.NET?
What are the methods of XML dataset object?
Which object holds only data and does not interact with data source?
What is reference by value how does it works in .net?
Why do we serialize data?
What are the data access namespaces in .NET?
once data is fetched into dataset connection gets closed. but in datareader connection is always maintained...then why datareader is fast and mainly recommended ?
What is ole data type?
What does sqldatareader return?
What are the different ado.net namespaces?
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)