C# linq to sql default appears
-
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?
-
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?
You cannot modify the designer files at all. Any code you put in there WILL be overwritten and destroyed. The stuff your'e talking about always goes into your Form.cs files, not the designer files.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak -
You cannot modify the designer files at all. Any code you put in there WILL be overwritten and destroyed. The stuff your'e talking about always goes into your Form.cs files, not the designer files.
A guide to posting questions on CodeProject[^]
Dave KreskowiakSo what you are saying if I place the code in form.cs, then the db connection string values will not be overriden? If so, can you show me some code I can use as a reference?
-
So what you are saying if I place the code in form.cs, then the db connection string values will not be overriden? If so, can you show me some code I can use as a reference?
Serisouly?? If you need this kind of help, you REALLY need to pickup a beginners book on C# and work through it. It's no different than if you were putting the same code in the designer file.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak