Geek Answers Handbook

The difference between driver and provider

What is the difference between driver and provider in the database? Are there any explanations, we will be grateful.

sample: ADO.NET driver for MySQL vs providerName="System.Data.EntityClient"

+7
c # sql oracle
source share
2 answers

From the MSDN forum:

A driver is a program installed on a workstation or on a server; it allows programs to interact with a database management system (DBMS). For example, the JDBC driver provides a database connection through the standard JDBC application programming interface (API) available in J2EE.

A data provider is a set of libraries that are used to communicate with a data source. For example, the SQL data provider for SQL, the Oracle data provider for Oracle, the OLE DB data provider for access, excel, and MySQL. It serves as a bridge between the application and the data source and is used to extract data from the data source and to coordinate changes to this data with the data source.

Source: MSDN Forum

+6
source share

A provider is a connection to a specific database, for example Sql Server, Oracle, but we import namespaces such as using system.data.msdaora , using system.data.sqlclient .

After writing the connection class, it takes a string string connection takes 4 operators uid, pwd, database, server.

After an open connection using the cn.Open method.

After executing the statements.

After closing the connection.

-3
source share

More articles:


All Articles