Forums Programming Assignment Help What are advantages and disadvantages of Microsoft provided data provider classes in ADO.NET

This topic contains 1 reply, has 1 voice, and was last updated by  Aakanksha 7 years ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #4323

    Aakanksha
    Participant

    What are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET?

    #11638

    Aakanksha
    Participant

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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.