Fork me on GitHub

EntityFramework 7 Migrations 迁移命令

示例代码:

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

参考资料:

posted @ 2015-11-25 17:57  田园里的蟋蟀  阅读(2179)  评论(0编辑  收藏  举报