Distributed query... Is it possible with EntLib 5?

Topics: Data Access Application Block
Nov 12, 2010 at 1:34 PM

Hello,

Is it possible to get one result (DataSet) from several databases? 

Egsample: I have connected to Ms SQL Server and Oracle. Ms SQL Server has table TableA and Oracle - TableB.

For a while I would like to get result similar to this:

select TableA.*, TableB.* from TableA, TableB 
Any ideas? Thanks in advise.

Nov 15, 2010 at 12:23 AM
Edited Nov 15, 2010 at 1:06 AM

This is not really an EntLib question.  I think if this is possible by just executing a stored procedure in either sql or oracle, then EntLib can handle that. I suggest posting this in either Oracle or SQL forum.

 

Sarah Urmeneta
Global Technologies and Solutions
Avanade, Inc.
entlib.support@avanade.com