SqlClient data provider gives maximum performance - ADO.NET

Q.  Which Data Provider gives the maximum performance when connect to SQL Server?
- Published on 27 Jul 15

a. The SqlClient data provider.
b. The OLE DB data provider.
c. The Oracle data provider
d. All of the above.

ANSWER: The SqlClient data provider.
 

    Discussion

  • Ramesh   -Posted on 19 Oct 15
    The SqlClient data provider gives the maximum performance when connect to SQL Server. It is optimized for accessing SQL Server. It uses Tabular Data Stream (TDS) protocol for direct communication.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)