how to connect multiple sql databse in 1 project

Question

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

Gajendra Jangid · Answer

string s = DropDownList1.SelectedValue.ToString(); if (s= 'Sql' ) connectionstringName = 'SqlConnectionstring' ; else if (s= 'Sql1' ) connectionstringName = 'SqlConnectionstring1' ; SqlConnection con = new SqlConnection( ConfigurationManager.ConnectionStrings[connectionstringName].ConnectionString); SqlDataAdapter da = new SqlDataAdapter( "SELECT * FROM Table1 where name=depat" , con); DataTable dt = new DataTable(); da.Fill(dt); GridView1.DataSource = dt; GridView1.DataBind();

Kalyani Shevale · Answer

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 Arif · Answer

Yes you can easily make this. as you create first same like you have to create new connection as you create your first connection.

how to connect multiple sql databse in 1 project

Answers (3)