ADO and ADO.NET differences?
Answers were Sorted based on User's Feedback
Answer / srinivasreddy
ADO Is the Connected Architecture but ADO.NET is the
disconnected architecture.
in ado we cant retrieve the more than one table at a time
but in ado.net we can retrieve many tables as per user
requirement.
in ado we have recordset for the retrieving data but in
ado.net we have Dataset.
in ado xml integration is not possible but in ado.net we
can use xml.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / saritha
ado doesnot support database connectivity with purely
dissconnected architecture and xml intigration
where
ado.net supports database connectivity with purely
dissconected architecture and xml intiration
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / baroda
i have apply for post off clark please send me clerical
staff qustions &answer
| Is This Answer Correct ? | 3 Yes | 2 No |
how do u connect ado.net to sql server
Command objects uses, purposes and their methods.
How do you connect to sql server database without using sqlclient?
What is the difference between data grid and data repeater?
Explain which name space is used to get assembly details?
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 a column variable?
How is entity framework different from ado.net?
What is disconnected architecture in ado.net?
What is sqldatareader?
If i am expecting a single result from sqlserverdatabase then what command should i follow ?sqlcommand.executereader (commandbehaviour.singleresult)or sqlcommand.executescalar()
Does dapper use ado.net?
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)