Different db connections for controller in multiple areas

Asked Jul 29 '15 at 11:21

Active Jul 29 '15 at 11:42

Viewed 204 times

I have MVC5 application which has 2 areas: area1 and area2 I'd like to access 2 different db connections per each area. I've tried to add to area1\Views\web.config

    <add name="DefaultConnection_area1" providerName="System.data.SqlClient" connectionString="Data Source=xxx;Initial Catalog=DB_AREA1;Integrated Security=true;MultipleActiveResultSets=True" />

and add to area2\Views\web.config

<add name="DefaultConnection_area2" providerName="System.data.SqlClient" connectionString="Data Source=xxx;Initial Catalog=DB_AREA2;Integrated Security=true;MultipleActiveResultSets=True" />

But I am not able to retrieve DefaultConnection_area1/2 in area1/2 controllers via

ConfigurationManager.ConnectionStrings["DefaultConnection_area1(or 2)"].ConnectionString.

The only thing I can access is connection string from root Web.config

edited Jul 29 '15 at 11:42

asked Jul 29 '15 at 11:21

BreteP

Why don't you just have settings name `Area1` then `Area2` etc. asp-mvc doesn't have facilities for web.configs per area AFAIK. – gideon Jul 29 '15 at 11:24
I see web.config in Views, I've updated my question. – BreteP Jul 29 '15 at 11:42
Please see the below link. http://stackoverflow.com/questions/6491982/asp-net-mvc-multiple-connection-strings – Kishore Sahasranaman Aug 27 '15 at 07:21

Different db connections for controller in multiple areas

0 Answers0