示例代码:
using Microsoft.Data.Entity;using System.Collections.Generic;namespace ClassLibrary1{ public class BloggingContext : DbContext { public DbSetBlogs { get; set; } public DbSet 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 () .Property(b => b.Url) .IsRequired(); } } public class Blog { public int BlogId { get; set; } public string Url { get; set; } public List 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 upgradednu restorecd src\MyProjectdnx efdnx ef migrations add MyMigrationdnx 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 typesscaffold
–Scaffolds a DbContext and entity type classes for a specified database
migrations
add
–Add a new migrationlist
–List the migrationsremove
–Remove the last migrationscript
–Generate a SQL script from migrations
参考资料: