During my team's development process we have 3 databases we work with. Development, Test, and Production. Right now I have Action and Retrieval procedures in the database.

My question is: Is there a way to generate the DAL from LLBLGEN so that we do not have to make changes in the config files for the different connectionstrings and in the DB Specific files where it adds [Dev].[dbo].[GetProc]. The DB name is different for each physical DB during our staged process.

Thanks, Wade

Okay, I looked at the link for another post: Catalog name overwriting (SqlServer, Sybase ASE).

My questions are:

1. Do I do this only in the DB generated Config?
2. If so, will it be replaced/removed when we do a new generation with the designer?
3. Or do we only put the entries in the App.config at the UI Level?

Thanks, Wade

The correct answer is:

1. Or do we only put the entries in the App.config at the UI Level?

Thanks!