Using OLEDB or ODBC & Native Driver

Question

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

Vulpes · Answer

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

antoni rich · Answer

Thank you Sir...