C
Question: 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, but it’s 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. |
Is it helpful?
Yes
No
Most helpful rated by users:
- What’s the advantage of using System.Text.StringBuilder over System.String?
- Can you store multiple data types in System.Array?
- What’s the difference between the System.Array.CopyTo() and System.Array.Clone()?
- How can you sort the elements of the array in descending order?
- What’s the .NET datatype that allows the retrieval of data by a unique key?