make .edmx file in MVC3 to use web.config connectionstring

Question

I am trying to develop a web application using MVC3 architecture.

I have DAL library for all database related operations and my web application is a separate application.

Now, if I update my .edmx file by drag and drop in DAL library, the app.config file of that library gets updated.

And this is fine when I am developing, but while deploying, I do not want my application to use connectionstring from app.config file, but instead from web.config file from my web application.

Can anybody give me an idea how to achieve this?

Thank you.

lahsrah · Accepted Answer · 2012-08-21 04:59:39Z

1

You can pass your connection string to the DataContext.

e.g.

using (var context = new DataContext(Setting.MyConnectionString))
{
   var query = context.MyTable.Where(s => s.Id == 1);
}

answered Aug 21, 2012 at 4:59

lahsrah

9,2135 gold badges39 silver badges70 bronze badges

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

Collectives™ on Stack Overflow

make .edmx file in MVC3 to use web.config connectionstring

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related