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

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

-- 
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"Max André Bündchen"  wrote in 
message news:D3DF113D-85B7-4821-B011-BF627ABDDA07@microsoft.com...

> 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.

On Aug 15, 10:12 am, Max André Bündchen
 wrote:

> 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!