Where clause in table mappings causes unhandled SQLException

airvineairvine Posts: 5
edited April 3, 2007 6:51AM in SQL Toolkit Previous Versions

I'm writing a database comparison and migration application that needs to filter the databases based on user input.

I iterate through the source database Tables collection and build a list of tables that reference my base table in a foreign key. Then for each of the tables found in this manner I create a tablemapping object using the tablemappings.join method. I then apply a where clause to each of these mappings and add the mapping to the mappings collection that is passed to currentSession.CompareDatabases(dbSource, dbDest, mappings). This call (even inside of a try block) will cause an unhandled SQLException to be thrown.
If I omit the where clause from the table mappings the code executes fine.

Any thoughts?




Sign In or Register to comment.