Specify Linq To SQL ConnectionString explicitly
- by Michael Freidgeim
When modifying Linq to Sql data model in Visual Studio 2010, it re-assigns ConnectionString that is available on developer’s machine. Because the name can be different on different machines, Designer often replace it with something like ConnectionString1, which causes errors during deployment.It requires developers to ensure that ConnectionString stays unchanged. More reliable way is to use context constructor with explicit ConnectionString name instead of parameterless default constructor GOOD: var ctx = new MyModelDataContext(Settings.Default.ConnectionString);Not good: var ctx = new MyModelDataContext();
