Best class to access database

[AlejandroGG]

Hi,

I will create a visual basic .net 2010 application that needs to be independent of the type of database. Specifically databases are access and sql server 2008.

Therefore, need a class that can access multiple database types. I have read that there are two classes that do this: OdbcConnection and OleDbConnection

What class is best to use in a matter of performance? OdbcConnection or OleDbConnection?

I have read that it is better to use OdbcConnection but I'm not sure.

Is there much difference in performance compared to native classes like SqlConnection?

Thanks.

 

[Galaxiom]

Microsoft encouraged OLEDB for several years but now they are going back to ODBC and dropping OLEDB support in future releases of SQL Server.