Search code examples
linq-to-sqldynamic-data

Set database name dynamically in LINQ to SQL

I am using LINQ to SQL to connect to database from my application. When I am changing environment from production to staging, I can update my connection string in web.config. But there is one more value I need to update when environment changes. That is database name. In LINQ to SQL designer file, database name is mentioned as attribute like-

[System.Data.Linq.Mapping.DatabaseAttribute(Name="somedbname")]

How can I pick up value of Name dynamically from some config file?

Any help is really appreciated.

Solution

  • as mentioned on the http://msdn.microsoft.com/en-us/library/system.data.linq.mapping.databaseattribute.name.aspx

    "The DatabaseName is used only if the connection itself does not specify the database name." so you can delete this attribute and all is gonna work fine!