Difference between import System

Question

Illustrate the difference between import System.Data.SqlClient and System.Data.Oledb in brief?

Answer 1

System.Data.OleDB includes the objects which we use to connect to the data source through an OleDB provider, like OleDbConnection and OleDBCOmmand. System.Data.SqlClient includes objects which we use to connect to the data source through Tabular data stream interface given by Microsoft Sql Server. This can be usually employed to give better performance as it eliminates some of the intermediate layers needed by the OleDB provider.