Add new connection in connectionString

Question

I have the next connectionstring file:

<?xml version="1.0"?>
<connectionStrings>
  <add name="DefaultConnection"
    connectionString="Application Name=CalculatorTest;Server=PC01;Initial catalog=MyDB;Integrated Security=true" />
</connectionStrings>

I want to add a new connection, for example "MyDBTest", staying:

<?xml version="1.0"?>
<connectionStrings>
  <add name="DefaultConnection"
    connectionString="Application Name=CalculatorTest;Server=PC01;Initial catalog=MyDB;Integrated Security=true" />

  <add name="NewDefaultConnection"
    connectionString="Application Name=CalculatorTest;Server=PC01;Initial catalog=MyDBTest;Integrated Security=true" />
</connectionStrings>

How do I do it from C# Mvc 5?

Please edit your post and paste your source code, configuration etc as text, not as images — Rui Jarimba
– Rui Jarimba, Commented Aug 24, 2018 at 11:56
Possible duplicate of Multiple SQL Server connection strings in app.config file — Rui Jarimba
– Rui Jarimba, Commented Aug 24, 2018 at 11:58

Tooshie Monster · Accepted Answer · 2018-08-24 20:08:59Z

0

Right click on your project and add an Entity Data Object, then enter the name you want it to be called; chose code first from database, then enter the server address and you can also select which tables from the db you want. This will create the connection string for you. I would however recommend doing this in a separate class library so it’s easier to maintain. Note: if you do use it in a separate class library, you will need to look in the Web.config and copy it over to your main application web.config. Also you will want to add the reference of it in your project references.

answered Aug 24, 2018 at 20:08

Tooshie Monster

262 bronze badges

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

3 Comments

Nico Ferrero Over a year ago

Yes yes, but I currently have the connectionstring file with one connection. I need to add new connections on the same file.

Tooshie Monster Over a year ago

Do you know the other connection string?

Nico Ferrero Over a year ago

Yes, I know all of data. I don't know how to add to the file in runtime.

Collectives™ on Stack Overflow

Add new connection in connectionString

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related