EntityFramework 7 Migrations 迁移命令

本文详细介绍了如何使用Entity Framework Core进行数据库迁移操作,包括如何运行命令、理解命令参数及其作用,并通过实际代码示例展示了迁移过程。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

示例代码:

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



本文转自田园里的蟋蟀博客园博客,原文链接:http://www.cnblogs.com/xishuai/p/ef7-migrations-commands.html,如需转载请自行联系原作者

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值