Code First entity framework connection string

Question

I have 3 class projects in my solutions. 1. MVC4 project 2. Domain 3. Tests

In the MVC4 project I have added a web.config file with the connection string as

<add name="EfDbContext"  connectionString="Data Source=.;Initial Catalog=SportsStore;Integrated Security=true;" providerName="System.Data.SqlClient"/>

I have a class by name EfDbContext in Domain project which inherits DbContext.

When I view the website in browser, I get the server not found error.

I debugged the EfDbContext class and found that the Database.Connection.ConnectionString is set to \SqlExpress with database as EfDbContext.

Why is that?

Adam Tuliper · Accepted Answer · 2012-10-08 03:25:05Z

17

You must have your connect string as the FULL namespace to your context when your context class is in a different project

For example:

<add name="YourClassProject.EfDbContext"  connectionString="Data Source=.;Initial Catalog=SportsStore;Integrated Security=true;" providerName="System.Data.SqlClient"/>

answered Oct 8, 2012 at 3:25

Adam Tuliper

30.2k4 gold badges56 silver badges71 bronze badges

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

1 Comment

Adam Tuliper Over a year ago

Also note that with EF6 if you want to use shared database for multiple contexts make sure your context class calls base("your content name as listed above in this post") as that will be the name of the connect string looked for as well.

Felix · Accepted Answer · 2012-10-08 03:35:35Z

11

You should create your DbContext with your connection string name passing to the constructor

public class UnicornsContext : DbContext
{
    public UnicornsContext()
        : base("EfDbContext")
    {
    }
}

http://blogs.msdn.com/b/adonet/archive/2011/01/27/using-dbcontext-in-ef-feature-ctp5-part-2-connections-and-models.aspx

answered Oct 8, 2012 at 3:35

Felix

85210 silver badges17 bronze badges

1 Comment

Khaled Musaied Over a year ago

This is the best solution for me at least :) Thanks.

Suneel Dixit · Accepted Answer · 2012-10-08 18:38:46Z

1

Finally, I realized that I added the connection entry in the web.config file created by VS in Views folder.

My bad.

answered Oct 8, 2012 at 18:38

Suneel Dixit

8892 gold badges10 silver badges17 bronze badges

Collectives™ on Stack Overflow

Code First entity framework connection string

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related