Difference between OLEDB and ADO.net

Question

Hi What are the main differences between OLEDB and ADO.net and LINQ? Which one is good to use? Darma

Satyapriya Nayak · Answer

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