What two types of data providers does ADO.NET supply? What determines which one you should use?
Answer / Neetu Kuma
ADO.NET supplies two main types of data providers: SQL Server provider and OLE DB provider. The choice between the two depends on your specific database system. If you are working with a Microsoft SQL Server, you would typically use the SQL Server provider for better performance. If you need to access multiple databases or are unsure about the underlying database system, you might opt for the OLE DB provider.
| Is This Answer Correct ? | 0 Yes | 0 No |
Differentiate between Dataset and Recordset.
What is a sqldataadapter?
What are the different ado.net namespaces are available in .net?
What is ado data control?
What are the usages of the command object in ado.net?
describe about the ado.net object model
Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!
What is openrowset?
How to identify the updated rows in a dataset?
Give an example of a .net application which connects to microsoft access database using ado.net classes.
what is the syntax code for oldb to connect oracle
differences between ADO and 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)