Multiple Databases

Apr 12, 2012 at 9:11 AM

Hi to everyone,

i'm trying Dynamic SQL Generator and it seems to work pretty well.

Unfortunately i've a particular need that force me to launch query which access to multiple databases simultaneously. 

Someone can tell me if Dynamic SQL can manage this kind of problem?

If not, someone have some suggestions to point me in the right direction?

 

Thank you very much in advance to everyone!

Coordinator
Apr 18, 2012 at 7:16 AM

Hi Aeusepi

DynaSQL DBTable doesn't support it, but it's easy to add as the statement builder does support full references.

DBTable.cs add a Catalog property to DBTable. Modify any of the static factory methods you need, and the BuildStatement method of DBTableRef to include this cataog option.

I've copied to a work item so that I'll include in the next release.

Coordinator
Apr 18, 2012 at 7:17 AM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.