Using OLEDB or ODBC & Native Driver

Hi, someone can explain to me, please.
What should I use, if I want connect to Database SQl Server, MySql or Oracle, using OleDb or Odbc, or others way ?

And then what is Native Driver, someone can give me sample code for using Native Driver to access Database (SQL Server, Mysql or Oracle) from C#.

Thanks before

As a general rules it's better to use a 'data provider' which has been specially written for and provides direct access to the database that you want to connect to.

This should give better performance and expose more features than if you use the generic ODBC or OleDB providers to connect indirectly to the database.

There are a number of these 'native' data providers including ones for SQL Server, Oracle and MySql. Check this link for a list:

http://msdn.microsoft.com/en-us/data/dd363565.aspx

For more details on choice of data provider, I'd also read this article by Mahesh:

http://www.c-sharpcorner.com/uploadfile/mahesh/how-do-i-choose-a-data-provider/

For a short example of using the SQL Server data provider, see this link:

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.aspx

As a general rules it's better to use a 'data provider' which has been specially written for and provides direct access to the database that you want to connect to.

This should give better performance and expose more features than if you use the generic ODBC or OleDB providers to connect indirectly to the database.

There are a number of these 'native' data providers including ones for SQL Server, Oracle and MySql. Check this link for a list:

http://msdn.microsoft.com/en-us/data/dd363565.aspx

For more details on choice of data provider, I'd also read this article by Mahesh:

http://www.c-sharpcorner.com/uploadfile/mahesh/how-do-i-choose-a-data-provider/

For a short example of using the SQL Server data provider, see this link:

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.aspx

Using OLEDB or ODBC & Native Driver

2 Replies

Using OLEDB or ODBC & Native Driver

2 Replies