Multiple database support

  • Thread starter Thread starter Me
  • Start date Start date
M

Me

How do most people support multiple database types such as SQLServer,
Oracle, Access, etc.? Mainly I am wanting to just support MS (SQLServer and
Access) but may need others in the future.

I am currently looking at creating a simple class that has a few methods for
creating and accessing any database (just an API) and then implementing it
for each DB type I need. Is there a better way?

Thanks
 
Hello,
you just use some ado.net classes IDbConnection IDbCommand from dotnet
framework. This are base classes for that are implemented by sqlCommand and
sqlconnection. Means this are base classes for any type you are using odbc,
oledb, oracle and sql server.

Just find how to write data access layre.

I think this will solve your problem
 
Sounds like it might be what I am looking for.

The only thing I do not like is that it requires you to perform an install
in order to get access to it (call me crazy but I dont trust that type of
thing very much).

Is this available in a form that is not an executable - just a zip file with
source code would be great? I will check SourceForge.net to see if it is on
there, since it is open source, but I doubt it.

Thanks
 
It's OpenSource, so complete source is available in VB.Net and C#. They just
decided to make a msi installer out of it, but yes, you could repack the
code yourself for your own use, it would work no problem.
 
Back
Top