how to connect multiple sql databse in 1 project

Kalyani Shevale

I want to access 2 SQL server in one project hoe to access in MVC 5 please help me.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kalyani Shevale7y ago
I have Created 2 database in 1 project in LINQ c#. but another database multiple tables that all table depend on each table using foreign key n unique key I want only two tables in another database but now because of key 20 table code required in my project so this solution is not suitable.
if any other solution then tells me or how to manage foreign key n unique key in LINQ using code first data model.

please help me ASAP.
Mohsin Arif7y ago
Yes you can easily make this. as you create first same like you have to create new connection as you create your first connection.
Gajendra Jangid7y ago
1. string s = DropDownList1.SelectedValue.ToString();
3. if(s='Sql')
4. connectionstringName = 'SqlConnectionstring';
5. else if(s='Sql1')
6. connectionstringName = 'SqlConnectionstring1';
8. SqlConnection con = new SqlConnection(
9. ConfigurationManager.ConnectionStrings[connectionstringName].ConnectionString);
10. SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM Table1 where name=depat", con);
11. DataTable dt = new DataTable();
12. da.Fill(dt);
13. GridView1.DataSource = dt;
14. GridView1.DataBind();