How to trigger Update-Database on a DbContext in a referenced assembly (NuGet package)

c# dbcontext entity-framework entity-framework-6

Question

Using the Package Manager Console I can run a command similar to the following one

Update-Database -ProjectName: My.Project.Data

The command triggers migrations on MyDbContext defined within the project My.Project.Data located in the currently open solution. Good.

Now the project My.Project.Data resides in the same solution with project My.Project.Mvc. The problem is, My.Project.Mvc uses two db contexts. One that we already covered and another one defined within project Core.Project.Data - this one is built as a NuGet package which is then referenced by My.Project.Mvc. The diagram below should make it clear:

MySolution
├┬ My.Project.Mvc
│├─ references: My.Project.Data (in the same solution)
│└─ references: Core.Project.Data (NuGet)
└─ My.Project.Data [MyDbContext]

CoreSolution
└─ Core.Project.Data [CoreDbContext]

The question is, how can I trigger the migrations for the CoreDbContext from the Package Manager Console of MySolution. If I try to run Update-Database -ProjectName: Core.Project.Data I get the error:

Get-Project : Project 'Core.Project.Data' is not found.

Update: Using the migrate.exe instead is not an option.

1
1
7/19/2016 12:14:54 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

From the document update-database does not support dll.

You can execute EF migration tool from commandline, or add it in VS menu for conveniences.

migrate.exe Core.Project.Data.dll /startupConfigurationFile=Core.Project.Data.dll.config

or change /startupConfigurationFile to /connectionString=your-connection-string

1
7/19/2016 9:37:27 AM

Popular Answer

When migrations are first enabled by Enable-Migration, a Configuration.cs file will be added to the project. If this file exists for Core.Project.Data, tell Entity Framework to use this config:

Update-Database -ConfigurationTypeName Core.Project.Data.Migrations.Configuration -ProjectName Core.Project.Data
Georg Patscheider

Related Questions

NuGet Package - update-database error (EntityFramework.SqlMigrations)

I just used this command:...Update-Package EntityFramework -Reinstall
ef-migrations entity-framework nuget-package
asked by Alberto Monteiro

Code First Migrations for a custom NuGet package can't be executed from main application

Good news! It seems that I got it. I was looking for a way to make the NuGet package to update the database to the latest version....Well, this package comes with an Admin controller, so I added a new action called Update:...public ActionResult Update() { System.Data.Entity.Database.SetInitializer(new System.Data.Entity.MigrateDatabaseT...
code-first ef-migrations entity-framework
asked by Alfonso Muñoz

Entity framework code first - how to run Update-Database for production database

To add on what @David said already... ...Personally, I don't trust ...automatic updates... in 'live' scenarios, and I always prefer manual database administration (i.e. there is a problem with ...permissions... needed to create or alter Db - not to mention shared hosting etc.) - but from what I've seen migrations are pretty solid when it comes to ...
asp.net-mvc c# entity-framework
asked by NSGaga-mostly-inactive

Assembly 'EntityFramModel' uses EntityFramework 5.0 which has a higher version thhan the referenced assembly

For anyone who is still having this issue with Entity Framework:...Go to the specific project in a solution...Under references, delete existing reference to Entity Framework...Right-click on the project and click manage nudget package...Add a matching reference (or latest) to Entity framework...Hope this helps
asp.net entity-framework
asked by Aki

The type 'System.Data.Entity.DbContext' is defined in an assembly that is not referenced. You must add a reference to assembly 'EntityFramework 2

I found this solution suitable for me....Adding Entity Framework DLL Reference:-...Go to c:\Program Files (x86)\Microsoft ASP.NET\ASP.NETMVC 4\Packages\EntityFramework 5.0.0-rc\lib\net45...Add Entity framework DLL
.net entity-framework
asked by Mazhar Khan

How do I generate an EF6 database with migrations enabled, without using update-database?

In EF5, I relied on the fact that I could recreate my database from the model using ...Database.CreateIfNotExists()...I would generate Migrations as needed, but never check them in to source control (since they tended to be artifacts of the development cycle) Each developer would then delete and recreate their own databases, from the model as nee...
entity-framework
asked by Doug

What is the reverse for Update-Database (used in Package Manager Console)?

Update-Database –TargetMigration "lastcreatedMigrationName" ...example:...update-database -targetmigration: "entity-logs-index"
entity-framework nuget nuget-package
asked by siddhartha sharma

Entity Framework 6 Migrations: How to disable automatic Update-Database on Database initialize?

We have a project running EF6 and have now activated Migrations. The problem we have is that we ha a lot of Data that needs to be added to the database when it is created. This worked well until we needed to add data in the migration part so it is part becomes part of the SQL script. Because when we try and create a new database on our development ...
ef-migrations entity-framework-6
asked by SpaceOgre

update-database -force command is not updating the base in entity framework code -first

May be this question seems duplicate. But here are the issue that I am facing with the command....If I run this command, ...update-database -force ...the first error I gets.....There is already an object named tblAbc in the database...Then I googled and everytime I get a stackoverflow link for suggesting to run ... Add-Migration Initial -IgnoreCh...
asp.net-mvc ef-code-first entity-framework sql-server
asked by Kgn-web

Install nuget package : EntityFramework 6 in .NETStandard 2.0 class library

I installed nuget package: EntityFramework 6 in .NET Standard2.0 Class library. On building the project I am getting the below warning message:...NU1701:Package 'EntityFramework 6.2.0' was restored using '.NETFramework,Version=v4.6.1' instead of the project target framework '.NETStandard,Version=v2.0'. This package may not be fully compatible with ...
.net-standard-2.0 entity-framework-6
asked by santosh kumar patro

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow