Hi,

I just wondering if using LINQ to replace the DAL, if the development Data base server is different from Test and production data base server, how the application knows to switch from Development Database to test and production database in the DBML. It seems the connection to database is built right in the DBML. After compile it, how to change the connection? (If use ADO, the connection string can be changed in web.config file, or use Key in Appsettings to indicate weather it is development, or test, or production, the connection string can be dynamically built in code by testing the Key value)

You can use any connection string you want by specifying it in an overload of the DataContext constructor. That way, the DBML will ignore its own connection string use the one you supply to it.

So, instead of this:

MyDataContext context = new MyDataContext();

You would use:

MyDataContext context = new MyDataContext(myConnectionString);

Thanks!