11/20/2018

NopCommerce 4.1 - EF Migration


  1. Install the Package Manager Console tools by running the following command in Package Manager Console:
    Install-Package Microsoft.EntityFrameworkCore.Tools
    Reference: .Net Core EF Migration - https://docs.microsoft.com/en-us/ef/core/managing-schemas/migrations/
  2. 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;" }
  3. Modify NopObjectContext.cs
    public NopObjectContext() :
        this(new DbContextOptionsBuilder().UseSqlServer(new ConfigurationBuilder().SetBasePath(Directory.GetCurrentDirectory()).AddJsonFile("appsettings.json").Build().GetConnectionString("nopCommerce")).Options)
    {

    }
  4. Add-Migration InitialMigrations
  5. Remove all create/drop table code, just leave the Up and Down methods empty.
  6. Update-Database