modify linq to sql in C#

Sie Ste

In a C# 2010 application, I used linq to sql. I did this so I could use the visual designer to drag the sql server 2008 r2 tables onto the designer suraface. This works fine if your development database is the same database where the production database is located.
However my problem is that I now need to move the code from my development database to a user acceptance database. The problem is the database connections are now hard coded into the applications.

Thus my questions are the following:
1. What can I do in the code so the database name is not hard coded? Do I need to modify a constuctor?
2. I would like the database connection information to be obtained from the app. config file.
Thus can you show me code on how to accomplish my goals?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Felipe Ramos14y ago
Accepted answer
Hello Sie, the constructor is a poor solution because everytime you change your designer you will loose it.

public static MyDataContext GetMyContext(this System.Configuration.ConnectionStringSettingsCollection settings)
{
return new MyDataContext(settings["ConfigKey"].ConnectionString);
}

This code is inside my extensions class:

public static class Extensions
{
...
}

and it extends the ConfigurationManager like so

ConfigurationManager.ConnectionStrings.GetMyContext();
0
Sie Ste14y ago
Can you tell mw what the best solution is? Should I use a constructor? Can you show me whatg part is the 'exntension' in your code?
0
Felipe Ramos14y ago
The problem with modifying the constructor is that sometimes when you make changes in the designer, it will wipe out your changes.

1. To make the change in the constructor open the DataContext designer.cs file and change the constructors to use your config or app config.

2. In my application I created an extension:

public static MyDataContext GetMyContext(this System.Configuration.ConnectionStringSettingsCollection settings)
{
return new MyDataContext(settings["ConfigKey"].ConnectionString);
}
0