1.

What Are Advantages And Disadvantages Of Microsoft-provided Data Provider Classes In Ado.net?

Answer»

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. OLE-DB.NET is a .NET layer on TOP of the OLE layer, so it’s not as fastest and efficient as SqlServer.NET.

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. OLE-DB.NET is a .NET layer on top of the OLE layer, so it’s not as fastest and efficient as SqlServer.NET.



Discussion

No Comment Found