ADO.NET 2.0 & Datasets/Datatables

[tyreejp]

I've been looking everywhere for built in functionality in ADO.NET 2.0 to somehow query and join on two or more datatables in a single dataset.

I always see the same question that follows that question, "why don't you do the join in your sql." Easy, One table comes from DB2 and the other comes from Oracle.

So, I know there's not way to do it in versions 1.0/1.1 of the .net framework but is there something new in 2.0 that I"m not finding yet that will let me query these two datatables that's built into ADO.NET or do I have to do it manually like with previous versions?

Thanks

--
James

http://www.microsoftjr.com

 

[GeertVerhoeven]

Hi,

There is no possibility to join tables in a dataset. The only possibility you have is to add relationships to a dataset but that is not really querying.

Greetz,

Geert


Geert Verhoeven
Consultant @ Ausy Belgium

My Personal Blog

 

[cappmgr]

You could make an Oracle DB link to DB2 using Oracle Heterogeneous Services. Take a look at this thread thread759-747432 for some other options.

Marty