Entity Framework using different connection strings?

Question

I have 2 projects in my solution:

Server.API

This is a web api project. The web.config has a section for <connectionStrings>, and there's one connection string available.

Server.Model

This is where 2 models (database first) are located. The app.config also has a section for <connectionStrings>, and there are 2 connection strings, one for each model.

The initial solution was developed on one machine. Now I'm using a second machine.

When I try to update the model from the database (right-click in EF designer), I get to choose my data connection, and in the list of available connections, I get the one in the Server.API!

How does the designer know about this connection, and why doesn't it list the 2 connections that are the Server.Model project where the actual .edmx files are located?

Gert Arnold · Accepted Answer · 2014-11-01 22:21:10Z

2

You probably developed Server.API on the second machine, so Visual Studio (not the edmx) knows you previously used that specific connection for some task that required a connection (not even which task). It hasn't stored the other two yet.

Besides that, apparently the other two databases in the App.config of Server.Model are not accessible from the second machine, otherwise the Update Wizard would have used them without showing the "choose connection" page.

answered Nov 1, 2014 at 22:21

Gert Arnold

110k36 gold badges218 silver badges319 bronze badges

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

Collectives™ on Stack Overflow

Entity Framework using different connection strings?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related