database layer

  • Thread starter Thread starter Robert Miller
  • Start date Start date
R

Robert Miller

Hi,

I can connect from VB.NET 2008 a database with DMO, SMO... but all of
these connections are linking up the app to one defined database structure.
I would like to have more independence on that layer. Is there a way to
handle it free, so that I have one class or connection string to set up
the database when I want to change these database connection.

I do not want to define the meaning of "independence of database" now,
what I am looking for is might be more simple. I do not want to come
really close to an database itself, so neither SQL2005/2008 assemblies
nor anything else of such abstractions. All what I look for is a simple
way of reading data from "free to choose" data sources (DQL) and also
manipulate these data (DML). No further abstractions like select,
insert, delete, update.

By looking in msdn I found the class DbProviderFactory from ADO.NET.
Does anyone here have experience with that way to connect databases or
might be an alternative?

Thanks for reading
Robert
 
Hi,

I can connect from VB.NET 2008 a database with DMO, SMO... but all of
these connections are linking up the app to one defined database structure.
I would like to have more independence on that layer. Is there a way to
handle it free, so that I have one class or connection string to set up
the database when I want to change these database connection.

I do not want to define the meaning of "independence of database" now,
what I am looking for is might be more simple. I do not want to come
really close to an database itself, so neither SQL2005/2008 assemblies
nor anything else of such abstractions. All what I look for is a simple
way of reading data from "free to choose" data sources (DQL) and also
manipulate these data (DML). No further abstractions like select,
insert, delete, update.

By looking in msdn I found the class DbProviderFactory from ADO.NET.
Does anyone here have experience with that way to connect databases or
might be an alternative?

Thanks for reading
  Robert
Click to expand...

Are you talking ab out something like NHibernate?
 
Back
Top