I am just writing an asp.net application and i wonder how to connect and query 2 different databases with linq. 2 databases have same tables and same rows and same identicals. Only database names and data is different on them. I know linq classes mapping and creating just one db with it tables and rows. If i change connectionstring other databases which are same. Could this be possible? If anyone try this and get any issues? And how can i change connectionstring on runtime? I mean i can use combobox or something like this, but do i have to add appsettings to add connectionstring to look for or do i need to change linq mapping classes to reach dbs? i am very confused. i need your helps.
Add a comment
|
2 Answers
When using Entity Framework, when you instantiate a DataContext you get a constructor that accepts a sqlConnection object that contains a connection string. Something like (i don't know the exact syntax and class names by heart):
SqlConnection sqlcon = SqlConnection(YourConnectionString); DataContext db = DataContext(sqlcon);
In LINQ, i do think that there's also one for it. You can store a key-value pair in Web.Config with different connection string and figure out in your code how to switch from one connection to another.
Comments
Set up LINQ-to-SQL or Entity Framework (to use LINQ-to-Entities) to one of the databases. At run time you can use the DataContext/DbContext constructor overload that takes a specific connection string to decide what database to use.
