EntityFramework 7 Migrations 遷移命令 - xishuai－IT工程師數位筆記本

文章出處

示例代碼：

using Microsoft.Data.Entity;
using System.Collections.Generic;

namespace ClassLibrary1
{
    public class BloggingContext : DbContext
    {
        public DbSet<Blog> Blogs { get; set; }
        public DbSet<Post> Posts { get; set; }

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            optionsBuilder.UseSqlServer(@"Server=DESKTOP-2P9GHDD\SA;Database=BloggingContextDb;User ID=sa;Password=123456;");
        }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            // Make Blog.Url required
            modelBuilder.Entity<Blog>()
                .Property(b => b.Url)
                .IsRequired();
        }
    }

    public class Blog
    {
        public int BlogId { get; set; }
        public string Url { get; set; }

        public List<Post> Posts { get; set; }
    }

    public class Post
    {
        public int PostId { get; set; }
        public string Title { get; set; }
        public string Content { get; set; }

        public int BlogId { get; set; }
        public Blog Blog { get; set; }
    }
}

project.json 配置代碼：

{
  "version": "1.0.0-*",
  "description": "ClassLibrary1 Class Library",
  "authors": [ "xishuai" ],
  "tags": [ "" ],
  "projectUrl": "",
  "licenseUrl": "",

  "frameworks": {
    "dnx451": { }
  },
  "dependencies": {
    "EntityFramework.Core": "7.0.0-rc1-final",
    "EntityFramework.Commands": "7.0.0-rc1-final",
    "EntityFramework.MicrosoftSqlServer": "7.0.0-rc1-final"
  },
  "commands": {
    "ef": "EntityFramework.Commands"
  }
}

命令行轉到程序目錄，運行 dnx ef，如果出現“找不到命令”提示，先運行 dnvm upgrade。

dnvm upgrade
dnu restore
cd src\MyProject

dnx ef
dnx ef migrations add MyMigration
dnx ef database update

dnx ef 命令：

dnx ef migrations add MyMigration 命令：

dnx ef database update 命令：

dnx ef migrations --help 幫助：

database
- update–Updates the database to a specified migration
dbcontext
- list–List your DbContext types
- scaffold–Scaffolds a DbContext and entity type classes for a specified database
migrations
- add–Add a new migration
- list–List the migrations
- remove–Remove the last migration
- script–Generate a SQL script from migrations