ASP.NET manage multiple DB connections

Question

I didn't find any useful information about this, so I will try here.

My approach is, to have different db connections on my test server and on my life server.

Right now I have one connection String

<connectionStrings>
    <clear/>
    <add name="my_life" ... />
  </connectionStrings>

Important note I had to provide the name of my string to the AspNetSqlMembershipProvider and AspNetSqlRoleProvider

<roleManager>
      <providers>
        <remove name="AspNetSqlRoleProvider"/>
        <add name="AspNetSqlRoleProvider" 
             connectionStringName="my_life" ... />
         </providers>
    </roleManager>

Is there a way to handle the db connection via env variable or maybe url?

mybirthname · Accepted Answer · 2016-10-06 08:04:28Z

1

I really prefer to use DB Aliases if you want only ip address of your db to be diferent. If you want to have different web.config with different configurations by environment you can use web.config transformations.

Check Web.config Transformation Syntax for Web Application Project Deployment

answered Oct 6, 2016 at 8:04

mybirthname

18.2k3 gold badges35 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sarav S · Accepted Answer · 2016-10-06 08:07:54Z

0

you can maintain multiple connection strings in a XML file with unique reference id and read this file to get the connection string dynamically in your code where ever you want.

Sample like

<ConnectionString>
<Connection>
<Id></Id>
<ConString></ConString>
</Connection>
</ConectionString>

answered Oct 6, 2016 at 8:07

Sarav S

161 bronze badge

2 Comments

Alexander_F Over a year ago

how to pass them to roleManager?

Sarav S Over a year ago

Please check this link stackoverflow.com/questions/12838669/…

Collectives™ on Stack Overflow

ASP.NET manage multiple DB connections

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related