Home All Groups Group Topic Archive Search About
Author
2 Jun 2009 10:41 AM
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

Author
2 Jun 2009 3:43 PM
joecool1969
On Jun 2, 6:41 am, Robert Miller <rob***@radiokili.org> wrote:
Show quoteHide quote
> 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

Are you talking ab out something like NHibernate?
Author
3 Jun 2009 1:24 PM
Robert Miller
joecool1***@live.com schrieb:
> On Jun 2, 6:41 am, Robert Miller <rob***@radiokili.org> wrote:
>> Hi,
>>
>> [... ]"independence of database" [...]
>
> Are you talking ab out something like NHibernate?

Thanks for the interesting link! Yes, that's it!

Robert
Author
3 Jun 2009 11:49 AM
Screaming Eagles 101
Not the Robert Miller from Texas I reccon... ?
--
Filip
http://www.ww2airborne.net/
Official Site of the 101st Airborne - 463rd PFA
skype: airborne463pfa-fiwi
[It's nice to be important, but it's more important to be nice!]
Author
3 Jun 2009 1:24 PM
Robert Miller
Screaming Eagles 101 schrieb:
> Not the Robert Miller from Texas I reccon... ?

No - I am not from Texas :-)

Robert