What Is The Difference Between Oledb Provider And Sqlclient?

1.	What Is The Difference Between Oledb Provider And Sqlclient?
Answer» With respect to usage, there is no difference between OLEDB PROVIDER and SQLCLIENT. The difference lies in their performance. SqlClient is explicitly used to connect your application to SQL server directly, OLEDB Provider is generic for VARIOUS DATABASES, such as Oracle and ACCESS including SQL Server.Therefore, there will be an overhead which leads to performance degradation. With respect to usage, there is no difference between OLEDB Provider and SqlClient. The difference lies in their performance. SqlClient is explicitly used to connect your application to SQL server directly, OLEDB Provider is generic for various databases, such as Oracle and Access including SQL Server.Therefore, there will be an overhead which leads to performance degradation.

Answer»

With respect to usage, there is no difference between OLEDB PROVIDER and SQLCLIENT. The difference lies in their performance. SqlClient is explicitly used to connect your application to SQL server directly, OLEDB Provider is generic for VARIOUS DATABASES, such as Oracle and ACCESS including SQL Server.Therefore, there will be an overhead which leads to performance degradation.

With respect to usage, there is no difference between OLEDB Provider and SqlClient. The difference lies in their performance. SqlClient is explicitly used to connect your application to SQL server directly, OLEDB Provider is generic for various databases, such as Oracle and Access including SQL Server.Therefore, there will be an overhead which leads to performance degradation.

Discussion

No Comment Found

Related InterviewSolutions

What Are All The Different Authentication Techniques Used To Connect To Ms Sql Server?
What Are The Methods Of Xml Dataset Object?
Do We Use Stored Procedure In Ado.net?
Which Provider Is Used To Connect Ms Access, Oracle, Etc…?
Is It Possible To Load Multiple Tables In A Dataset?
What Is The Difference Between Command And Commandbuilder Object?
What Is The Difference Between Dataset.clone And Dataset.copy?
What Are All The Different Methods Under Sql Command?
What Are All The Commands Used With Data Adapter?
What Are The Different Execute Methods Of Ado.net?