I am trying to figure out the architecture to have a VB.NET program that interacts with a database. I issue which most people face is to be able to work with multiple Databases (a quick shopping list SQLite, MySQL, DB2, Oracle, and MS SQLServer).
I did some playing around with SQLite and it seems I needed to use some SQLite-specific code which has me all confused and concerned.
So basically my question is how can I setup my database connections and interaction to be abstracted from all Databases? Is there any good resources for this?
I've done it in Java where i just define the Driver at the beginning and the code is the same from then on, but cannot figure out how to do the same/similar thing in VB.NET