SqlClient data provider gives maximum performance from connection to SQL Server - ADO.NET
Q. Which data provider gives the maximum performance from a connection to SQL Server?- Published on 31 Aug 15a. The OLE DB data provider.
b. The JDBC data provider.
c. The SqlClient data provider.
d. The Oracle data provider
ANSWER: The SqlClient data provider.
The SqlClient data provider gives the maximum performance from a connection to SQL Server.
Data provider works as a bridge between an application and a data source.SQL Server.NET Data Provider available in the System.Data.SqlClient namespace.