javascript - How to access multiple database dynamically using Entity framework 6.1(Power Tool Beta 4) with ASP.NET web api -


i've created project using asp.net mvc 4 => web api...

i have integrated angularjs in it. , i'm using single page app.

i'm using entity framework 6.1.

for database connectivity, i'm using entity framework power tool beta 4 target particular db , generate dbcontext.

now scenario is:

there 1 other application end user can register himself. when it, new database generated database server "projectname+clientname" name eg. missteve,misjohn...

this new user entry goes misdbmanager database there in database server new connectionstring , new user.

so, misdbmanager has clientname , relevant connectionstring.

so overall. in database, 1 misdbmanager has different registered users db connection strings.

eg,

   (clientname)  -          (connectionstring)            bv      - data source=pdev-3\xyz;initial catalog=misbv;integrated security=true           steve   - data source=pdev-3\xyz;initial catalog=missteve;integrated security=true  

now problem , question is,

when run application, logging page comes. user enters credentials. power tool beta 4, through reverse engineering, have generated misdbmanagerdbcontext against check whether credential valid or not. till here works fine.

but want is, if username & password valid, want connect valid user relevant db.

as have stated i'm using ef 6.1, powertool beta 4 , reverse engineering can target fixed client. not valid project.

i want connect valid client 1 db (generated & stored different tables database server).

with static approach, can target 1 client. when comes dynamic approach dont't know how it.

means, shown here if bv(clientname) gets logged in, can redirect him dashboard because have generated fixed misbvdbcontext. if other user gets logged can it. if i'm having thousand users can't generate thousand dbcontext. dynamic approach needed connect client database.

please me things done. please let me know if other way there connect client db.

help appreciated.


Comments

Popular posts from this blog

ruby on rails - RuntimeError: Circular dependency detected while autoloading constant - ActiveAdmin.register Role -

c++ - OpenMP unpredictable overhead -

javascript - Wordpress slider, not displayed 100% width -