- Install the Package Manager Console tools by running the following command in Package Manager Console:
Install-Package Microsoft.EntityFrameworkCore.ToolsReference: .Net Core EF Migration - https://docs.microsoft.com/en-us/ef/core/managing-schemas/migrations/ - Add connection string into appsettings.json
"ConnectionStrings": { "nopCommerce": "Data Source=.;Initial Catalog=nopdb;Integrated Security=False;Persist Security Info=False;User ID=nopuser;Password=xxxxxxxxxx;" }
- Modify NopObjectContext.cs
public NopObjectContext() :
this(new DbContextOptionsBuilder().UseSqlServer(new ConfigurationBuilder().SetBasePath(Directory.GetCurrentDirectory()).AddJsonFile("appsettings.json").Build().GetConnectionString("nopCommerce")).Options)
{
} - Add-Migration InitialMigrations
- Remove all create/drop table code, just leave the Up and Down methods empty.
- Update-Database
11/20/2018
NopCommerce 4.1 - EF Migration
Subscribe to:
Posts (Atom)