Best class to access database (1 Viewer)

AlejandroGG

New member
Local time
Today, 01:51
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.
 

Galaxiom

Super Moderator
Staff member
Local time
Today, 11:51
Joined
Jan 20, 2009
Messages
12,849
Microsoft encouraged OLEDB for several years but now they are going back to ODBC and dropping OLEDB support in future releases of SQL Server.
 

Users who are viewing this thread

Top Bottom