We have a development db and a staging db, and they have different database name. When the code generated from development db is deployed to staging db, an exception is thrown because the DAL can not find the table.

this is because the generated code includes the database name. I am wondering how to deal with this problem. Can I config it in the designer or do I need to manually rename the db name in PersistenceInfoFactory class?

Thanks!

wangchao1687 wrote:

We have a development db and a staging db, and they have different database name. When the code generated from development db is deployed to staging db, an exception is thrown because the DAL can not find the table.

this is because the generated code includes the database name. I am wondering how to deal with this problem. Can I config it in the designer or do I need to manually rename the db name in PersistenceInfoFactory class?

Thanks!

search the docs for "catalogNameToUse"

bert

To be exact: Using the generated code / Adapter / DataAccessAdapter functionality -> SqlServer specific settings