Best class to access database
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?