AlejandroGG
New member
- Local time
- Today, 05:05
- Joined
- Oct 4, 2013
- Messages
- 6
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.
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.