Search code examples
c#asp.net-coreentity-framework-coremigrationmicroservices

Could not load assembly 'CommonBaseData'. Ensure it is referenced by the startup project 'CommonBaseType'


I want create micro service architecture solution so I add some services for my solution. All my services must have one table in my database in there models so I add write this migrations for add one table from my database:

 Scaffold-DbContext -Connection "Server=DESKTOP-9Q51Q00\TMF;Database=DataModelSection;Trusted_Connection=True;" -Provider Microsoft.EntityFrameworkCore.SqlServer -OutputDir Model -Tables tblCommonBaseType -Context "Contexts"

The table which I want from my database successfully:

enter image description here

but when I create project #2 and I want to use this migration, and add one more table, I get an error and the build fails.

 Scaffold-DbContext -Connection "Server=DESKTOP-9Q51Q00\TMF;Database=DataModelSection;Trusted_Connection=True;" -Provider Microsoft.EntityFrameworkCore.SqlServer -OutputDir Model -Tables tblCommonBaseData -Context "Contexts" 

enter image description here


Solution

  • This error often caused when the current project is not the startup project.

    You can right click the project and click 'set as a startup project'

    Looks like you want to share the same database between two projects?

    You can move the Entity Framework code into a shared class library and reference it in

    two projects, no need to scaffold twice with the same database, it may occur some conflicts.