<div>
<div class="content wysiwyg-content">
I am using VS2005 and SQL 2005.<br />
If I change connection string in AppConfig in runtime the app needs to be restarted to connect to new database.<br />
Databases are completly the same schema but with different amount of data.<br />
Strong type tableadapters do not have connection string property exposed.<br />
<br />
So how to change active database in runtime??
</div>
</div>


I am using VS2005 and SQL 2005.
If I change connection string in AppConfig in runtime the app needs to be restarted to connect to new database.
Databases are completly the same schema but with different amount of data.
Strong type tableadapters do not have connection string property exposed.

So how to change active database in runtime??

How to change database in runtime??

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).