OLEDB
provider is used to access any database and provides flexibility of changing the database at any time. SQLClient
provider is used to access only SQL Server
database but it provides excellent performance than OLEDB
provider while connecting with SQL Server database
.