1
Answer

Difference between OLEDB and ADO.net

darma teja

darma teja

11y
2.1k
1
Hi,

What are the main differences between OLEDB and ADO.net and LINQ?


Which one is good to use?

Darma
Answers (1)
0
Satyapriya Nayak

Satyapriya Nayak

NA 53k 8m 11y
OLE DB is a set of COM-based interfaces that expose data from a variety of sources. OLE DB interfaces provide applications with uniform access to data stored in diverse information sources, or data stores. These interfaces support the amount of DBMS functionality appropriate to the data store, enabling the data store to share its data.

http://msdn.microsoft.com/en-us/library/windows/desktop/ms722784%28v=vs.85%29.aspx

Language-Integrated Query (LINQ) is a set of features introduced in Visual Studio 2008 that extends powerful query capabilities to the language syntax of C# and Visual Basic. LINQ introduces standard, easily-learned patterns for querying and updating data, and the technology can be extended to support potentially any kind of data store. Visual Studio includes LINQ provider assemblies that enable the use of LINQ with .NET Framework collections, SQL Server databases, ADO.NET Datasets, and XML documents.

http://msdn.microsoft.com/en-us/library/vstudio/bb397926.aspx
Accepted