Entity Framework not using connection string in app.config

Question

My error message states

The underlying provider failed on Open

and the InnerException states that the database cannot open by the requested login.

The strange thing is that my connectionString is showing a different login than what's mentioned in the error. Why is the application using an incorrect connectionString than the one that's explicitly defined in my App.Config?

How many projects are there in your solution? Which project has the app.config file, and which project has the WPF or web pages? The connection string should be in the same project as the one that has the user interface. — user8128167
– user8128167, Commented Nov 4, 2014 at 20:16

John · Accepted Answer · 2014-11-04 20:17:59Z

1

Few common reasons why:

1) You aren't using that project as your StartUp Project

2) You didn't match the name in the config

<connectionStrings>
    <add name="YourContext"... >
</connectionStrings>

3) You are hard coding it in the YourContext.cs

answered Nov 4, 2014 at 20:17

John

6,6014 gold badges41 silver badges59 bronze badges

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

Collectives™ on Stack Overflow

Entity Framework not using connection string in app.config

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