2

Resolved

Multiple Databases

description

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!

comments

perceiveit wrote Dec 12, 2012 at 7:07 AM

This should now be possible with the latest release.

There is DBQuery.Use("database name") statement for schema construction.

And a catalog option for the Tables, views and fields in statement construction.

DBQuery.SelectAllFields().From("catalog","owner","table") etc.

If not all statements are covered with the database - using an Alias for the table will always work.

DBQuery.SelectAllFields().From("catalog","owner","table").As("T").WhereFieldEquals("T","field",DBConst.Int32(1);

wrote Feb 14, 2013 at 7:51 PM

wrote May 16, 2013 at 9:20 AM

wrote May 16, 2013 at 9:20 AM

wrote Jun 14, 2013 at 7:12 AM