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 @   田园里的蟋蟀  阅读(2183)  评论(0编辑  收藏  举报
编辑推荐:
· Linux系列:如何用 C#调用 C方法造成内存泄露
· AI与.NET技术实操系列(二):开始使用ML.NET
· 记一次.NET内存居高不下排查解决与启示
· 探究高空视频全景AR技术的实现原理
· 理解Rust引用及其生命周期标识(上)
阅读排行:
· 阿里最新开源QwQ-32B,效果媲美deepseek-r1满血版,部署成本又又又降低了!
· 单线程的Redis速度为什么快?
· SQL Server 2025 AI相关能力初探
· 展开说说关于C#中ORM框架的用法!
· AI编程工具终极对决:字节Trae VS Cursor,谁才是开发者新宠?
历史上的今天:
2014-11-25 【记录】AutoMapper Project To not support ResolveUsing
点击右上角即可分享
微信分享提示