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