More about Database Independence

[Guest]

In a new system based on .Net 2.0 I have some tech goal like database
independence and the use of typed datasets. So I'm looking for some material
on web but I did not found anything interesting.

My scenario:

I had work with some OR solutions for the .Net platform but I need to work
with typed datasets instead of Business Entities. In the other hand, I would
not make a separated layer with specific table adapters because we would work
with more than 3 RMDBs and the schemas will change with a regular basis as
the project has no closed scope.

Well, the paradise here is generate the typed datasets and use the DBFactory
in the table adapters instead the provider-specific ado.net classes but it
isn't possible in VS 2005 with .Net 2.0.

Sorry for the bad english but it's my third language! :-s

 

[Miha Markic]

datasets are database independent, but the adapters and other classes aren't
as you've discovered.
Why can't you use factory pattern?

 

[mark.troester]

In a new system based on .Net 2.0 I have some tech goal like database
independence and the use of typed datasets. So I'm looking for some material
on web but I did not found anything interesting.

My scenario:

I had work with some OR solutions for the .Net platform but I need to work
with typed datasets instead of Business Entities. In the other hand, I would
not make a separated layer with specific table adapters because we would work
with more than 3 RMDBs and the schemas will change with a regular basis as
the project has no closed scope.

Well, the paradise here is generate the typed datasets and use the DBFactory
in the table adapters instead the provider-specificado.netclasses but it
isn't possible in VS 2005 with .Net 2.0.

Sorry for the bad english but it's my third language! :-s

You might want to check out the resources on DataDirect's ADO.NET
developer - http://www.datadirect.com/developer/net/index.ssp. This
site contains a lot of technical articles about ADO.NET including
information about developing apps for multiple databases. In
addition, DataDirect provides a complete set of ADO.NET providers to
support various databases, the providers can be downloaded for trial
here - http://www.datadirect.com/downloads/registration/connect_net/index.ssp

Good luck!