Data provider classes in ADO.NET

Question

Hi friends I want to know that what are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET?

Jignesh Trivedi · Answer

hi SQLServer.NET data provider is high-speed and robust but requires SQL Server license purchased from Microsoft. OLE-DB.NET is universal for accessing other sources like Oracle DB2 Microsoft Access and Informix but it is a .NET layer on top of OLE layer so not the fastest thing in the world. ODBC.NET is a deprecated layer provided for backward compatibility to ODBC engines. please refer http://msdn.microsoft.com/en-us/library/904fck4k%28v=vs.71%29.aspx hope this help.

Vulpes · Answer

The advantages of ADO.NET are set out in this MSDN link: http://msdn.microsoft.com/en-us/library/3y0bb1zd(VS.80).aspx You wouldn't expect Microsoft to list any disadvantages for their own product and the only real one is that it's purely a managed technology - it can't be used from unmanaged code. At one time there weren't many data providers (initially just SQL Server OleDb and Oracle). However nowadays there are third-party data providers for most of the commonly used relational databases.

Satyapriya Nayak · Answer

Hi Amit .NET Framework Data Provider for OLE DB is universal for accessing other sources like Oracle DB2 Microsoft Access and Informix but it's a .NET layer on top of OLEDB layer Performance is not so faster. .NET Framework Data Provider for SQL Server is used only for sql server database is high-speed and robust.Performance is faster. .NET Framework Data Provider for Oracle is used only for Oracle database is high-speed and robust.Performance is faster. Refer http://msdn.microsoft.com/en-us/library/a6cd7c08.aspx Thanks