C# linq to sql connection string changed to default setting

Question

In a C# desktop application, I am using linq to sql to connect to a sql server 2008 r2 database. The application 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:

place the using system.configuration code back into *.designer.cs file
change the code so the database connection info is obtained from the app.config file
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?

@JeremyThompson - I don't think you understand what he's saying, the designer is the only place to tell the dbml not to use its own generated connection string , but to force it to use another , and in the code when you write using(datacontext)... it will automatically use the conn. ctring from the dbml — Scott Selby
– Scott Selby, Commented May 27, 2013 at 2:24

Scott Selby · Accepted Answer · 2013-05-27 02:23:25Z

1

I have to do this everytime I update the dbml file, its a real pain. There are 2 things you can try.

First - after updating the dbml, right click anywhere in the dbml, go to properities, then under connection string you should be able to see the one from the web.config, or app.config that you want.

If it is not in the list , then set it to none, then go into the designer file and do what you have been doing.

answered May 27, 2013 at 2:23

Scott Selby

9,58012 gold badges63 silver badges97 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Diane Stein Over a year ago

I tried what you recommend, but I still have this problem all the time

Collectives™ on Stack Overflow

C# linq to sql connection string changed to default setting

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related