describe about the ado.net object model
Answers were Sorted based on User's Feedback
Answer / priya
ADO object model includes five components.
They are:
SqlConnection Object,SqlCommand Object,SqlDataReader
object,Dataset object,SqlDataAdapter object.
| Is This Answer Correct ? | 26 Yes | 2 No |
Answer / prakash
Not Sql ADO Object Model Only.But ADO.Net has the following
methods also
1.OLEDBProvider
2.SQLProvider
3.ODBCProvider
the above all has the Connection,Command,Data Reader, Data
Set, Data Adapter Also.So Finally List Only Common Object
Models , They are
1. Connection Objects
2. Command Objects
3. DataReader Object
4. DataSet Object
5. DataAdapter Object
| Is This Answer Correct ? | 10 Yes | 2 No |
Answer / sandyni
The main object model of an ADO.Net architecture is "Data
Provider". It provides data access to SQl server ,Oracle,
Access in order to retreive,update and insert data in the
datastore.
the main objects of ADO.Net object model are....
1.connection object : used to establish connection to
database.
2.command object: it is used to execute commands and stored
procedures.
3.dataAdapter object: used to establish connection between
datastore and dataset.
4.dataReader object: used to read data from dataset in
forward only.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / michael jerold
connection object
command object
dataadapter object
datareader object
| Is This Answer Correct ? | 2 Yes | 0 No |
What's the difference between Dataset.clone and Dataset.copy?
What are the advantages and drawbacks of using ado.net?
Explain different methods and Properties of DataReader which you have used in your project?
how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?
How can we add/remove row's in "datatable" object of "dataset"?
Which is faster datareader or dataadapter?
What is the difference between oledb sql server and oledbdotnet provider?
Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!
Explain what a diffgram is and its usage ?
Explain how can we load multiple tables in to dataset?
What is Serialization in .NET? what are the types of Serialization?
What are all the different authentication techniques used to connect to MS SQL Server?
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)