C# linq to sql uses a default setting
In a C# desktop application, I am using linq to sql to connect to a sql server 2008 r2 database. The applicatiion is setup to point to various databases depending upon the value in the app.config file.
The problem is code in the *.designer.cs gets overrriden somehow by 'defaults' in the .net problem framework. When this happens the 'using system.configuration' gets removed from the application and the 'default settings' values are used to get the database connection string values.
When I notice this problem occurs, I need to do the following: 1. place the 'using system.configuration' code back into *.designer.cs file, 2. change the code so the database connection info is obtained from the app.config file, 3. remove the property settings so the 'default' database connections are not used.
Thus can you tell me what is causing this problem to occur and how to solve the problem?