Multiple database single application with ASP.NET
<p>I created an application with Visual Studio and ASP.NET 4.0 with MSSQL 2012 Express as backend.</p>

<p>Initially there was no planning of multiple databases, so I programmed the app accordingly with single connection string for a single database.</p>

<p>Now, client's requirements has changed and he is asking for separate database for each year, <strong>DATABASE2015 for year 2015, DATABASE2016 for year 2016</strong> and so on.</p>

<p>I will migrate structure and data from previous year database to new year database and thats fine. </p>

<p><strong>But how will I connect to different database for different user as per their year selection at login time?</strong></p>

<p>Also, I am having a single connectionstring in web.config and I have referenced that connection string throughout my project in both code side and html side for asp.net controls.</p>

<p>Please advise.</p>