ADO.NET: OLEDB and MSSQL
Notes:

Question: The .NET SDK offers data provider implementations
for OLEDB and Microsoft SQL Server. Is it possible to access a
Microsoft SQL Server database also via OLEDB? When would you
use an OLEDB implementation and when a Microsoft SQL Server
implementation?

Answer: MS SQL Server can be accessed via OLEDB. If you want to keep your
program database independent then OLEDB is the preferred way. However,
MS SQL Server offers a specialized provider implementation, which
allows a more efficient way to access data stored in an MS SQL
Server than the OLEDB implementation.

No votes yet
Related Links:ADO.NET: EfficiencyADO.NET: Storing a Data Set in an XML FileADO.NET: Connectionless Data AccessADO.NET: Connection-oriented Data AccessADO.NET: Data Update
© Copyright 2008. All Rights Reserved.