| 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. |
|