0

I have asp. net mvc 4 web api application. in sql server, i have one Database named clientDBManager which has different clients with one connection string per client...

eg.

clientDBManager has, 1) client name : steve, connectionString : sql connection string which points to steve's individual db named clientDBSteve

2) client name : john, connectionString : sql connection string which points to john's individual db named clientDBJohn

and so on....

Scenario is, IN SQL server i have one clientDBManager which has it own one or two tables. while on other side DBs like clientDBSteve and clientDBJohn have similar no of tables around 50tables(having same schema)...

i want to add .edmx file to project and want to use different clients dbs (having same schema) in just one go dynamically...

is it possible?

if not what should i do????

with clientDBManager i will identify which user is logged in.
if Steve is logged in then clientDBSteve should be used for data manipulation.

if john is logged in then clientDBJohn should be used for data manipulation.

this should be done dynamically....

pls help how to do it.....

Improve this question
4
  • duplicate:stackoverflow.com/a/27256440/4304188 Commented Dec 9, 2014 at 19:08
  • suggested way is not working... Commented Dec 10, 2014 at 4:06
  • can you pls help me further? Commented Dec 10, 2014 at 4:06
  • when i write dbCopy. Database..... in c# it doesnt not resolve .Database keyword anyhow. which namespace is used to resolve .Database keyword?????u Commented Dec 10, 2014 at 4:08
Related questions
2
Connecting to multiple databases in MVC web application
0
How to connect to different databases?
0
asp.net mvc entity framework with multiple databases
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.