Entity Framework generating separate databases for separate projects

Question

I have a code first database in a WCF project. I use it by calling

using (var db = new DbContext())

I have another console application. I've added a reference to the WCF project. When I use

using (var db = new DbContext())

it creates a new database in the database next to the original database.

Database Database.DbContext

How do I get them to use the same database?

Okay so the problem was that there was no connection string specified so it created one based on Namespace.DbContext. How can I share connection strings, though, to avoid any errors should the connection string change? — Matthew James Davis
– Matthew James Davis, Commented May 26, 2014 at 18:39
The connection strings typically don't change much IMO. You should have a good mechanism for managing them for different environments though. The "Ferrari" version of that is to do it through some sort of connection string replacement during automated deployments. — TGH
– TGH, Commented May 26, 2014 at 18:41

Tony Vitabile · Accepted Answer · 2014-05-26 18:33:39Z

1

I believe you need to edit the app.config files of both applications and make sure the connection strings point to the same database.

answered May 26, 2014 at 18:33

Tony Vitabile

8,66816 gold badges74 silver badges130 bronze badges

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

4 Comments

Matthew James Davis Over a year ago

I was piggy backing off the connection string in the other application.

Tony Vitabile Over a year ago

what do you mean by "piggy backing"?

Matthew James Davis Over a year ago

I didn't specify the connection string at all and it automatically started using the connection string from the other project's settings.

Tony Vitabile Over a year ago

I don't think that Entity Framework is using the connection string from the other project's settings. Unless the second project references the first, there's no way the second should know of the first's existence. Without seeing the app.config files, I can't say for sure.

TGH · Accepted Answer · 2014-05-26 18:32:57Z

1

Make sure the connection strings are the same across both applications

answered May 26, 2014 at 18:32

TGH

39.4k13 gold badges106 silver badges140 bronze badges

1 Comment

Matthew James Davis Over a year ago

I was piggy backing off the connection string in the other application.

bayram · Accepted Answer · 2014-05-26 20:24:33Z

1

Create separate class for dbContext and provide your db name in constructor method

public class dbContext : DbContext
{
public dbContext() :base("YourDbName") { }

}

After that you can create instance as below:

dbContext db = new dbContext();

Hope it helps!

answered May 26, 2014 at 20:24

bayram

642 bronze badges

Collectives™ on Stack Overflow

Entity Framework generating separate databases for separate projects

3 Answers 3

4 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related