How Can I Declare Multiple Db In Single Connectionstring In Config File

Question

0.00/5 (No votes)

See more:

, +

can anyone tell that how can i declare multiple db in single connectionstring in config file.
[FROM OP'S COMMENT]
I Use two Data Base and connection string is

XML

<connectionstrings>
  <add name="ora" connectionstring="Your Path" providername="System.Data.Oracleclient" />
  <add name="sql" connectionstring="Your Path" providername="System.Data.sqlclient" />
</connectionstrings></connectionstrings>

[/FROM OP'S COMMENT]

Posted 8-Dec-14 0:50am

Anurag Prajesh

Updated 8-Dec-14 1:14am

Kornfeld Eliyahu Peter

v2

Add a Solution

Comments

Praveen Kumar Upadhyay 8-Dec-14 6:52am

You can have multiple User key variable(<appsettings> to store different different connection string rather storing it in <connectionstring> section.

Tushar sangani 8-Dec-14 6:59am

I Use two Data Base and connection string is
<connectionstrings>
<add name="ora" connectionstring="Your Path" providername="System.Data.Oracleclient">
<add name="sql" connectionstring="Your Path" providername="System.Data.sqlclient">

Praveen Kumar Upadhyay 8-Dec-14 7:25am

Yes this is the way you have to handle it as you have mentioned it in your code.

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kornfeld Eliyahu Peter · Answer 1 · 2014-12-08T00:59:00

Solution 1

One connection string can connect you to one database...You can have more than one connection strings to use when fit...

Posted 8-Dec-14 0:59am

Kornfeld Eliyahu Peter

Ankur^\m/ · Answer 2 · 2014-12-08T01:16:00

Multiple databases in one connection string doesn't make programming sense. You will need to declare a connection string for each Database.
You will have to do this like below in your web.config file:

XML

<connectionStrings>
    <add name="DBConnectionString1" connectionString="YourFirstConnectionStringHere" />
    <add name="DBConnectionString2" connectionString="YourSecondConnectionStringHere" />
</connectionStrings>

George Jonsson · Answer 3 · 2014-12-08T01:01:00

Solution 2

You don't specify which database provider you are using, so here is a link where you can find connection string examples to basically any database:
The Connection Strings Reference[^]

It should give you a place to start.

Posted 8-Dec-14 1:01am

George Jonsson

mudgilsks · Answer 4 · 2014-12-08T01:09:00

hi,

try this

XML

<add name="connectionString1" connectionstring="Data Source=DBSERVER;Initial Catalog=DBNAME1;Persist Security Info=True;User ID=sa; password=PASSWORD; Min Pool Size=20; Max Pool Size=6000; Enlist=False;Load Balance Timeout=180" />

<add name="connectionString2" connectionstring="Data Source=DBSERVER;Initial Catalog=DBNAME2;Persist Security Info=True;User ID=sa; password=PASSWORD; Min Pool Size=20; Max Pool Size=1000; Enlist=False;Load Balance Timeout=180" />

   <add name="connectionString3" connectionstring="Data Source=DBSERVER;Initial Catalog=DBNAME3;Persist Security Info=True;User ID=sa; password=PASSWORD; Min Pool Size=20; Max Pool Size=10000; Enlist=False;Load Balance Timeout=180" />

add more connection string

How Can I Declare Multiple Db In Single Connectionstring In Config File

4 solutions

Solution 1

Solution 4

Solution 2

Solution 3

Add your solution here

Preview 0