Code First迁移到数据库

1 新建model

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace AtTheMovies.Models
{
    public class Movie
    {
        public int Id { get; set; }
        public string Title { get; set; }
        public int ReleaseYear { get; set; }
        public int Runtime { get; set; }
    }
}

2 新建DbContext

using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Web;

namespace AtTheMovies.Models
{ 
    public class MovieDb : DbContext
    {
        public DbSet<Movie> Movies { get; set; }
    }
}

3 打开程序包控制器控制台，输入Enable-Migrations

4 在生成的Migrations文件夹里，修改Configuration.cs

namespace WebApi_1.Migrations
{
    using AtTheMovies.Models;
    using System;
    using System.Data.Entity;
    using System.Data.Entity.Migrations;
    using System.Linq;

    internal sealed class Configuration : DbMigrationsConfiguration<AtTheMovies.Models.MovieDb>
    {
        public Configuration()
        {
            AutomaticMigrationsEnabled = true;
        }

        protected override void Seed(AtTheMovies.Models.MovieDb context)
        {
            context.Movies.AddOrUpdate(m => m.Title,
                    new Movie { Title = "Star Wars", ReleaseYear = 1977, Runtime = 121 },
                    new Movie { Title = "E.T.", ReleaseYear = 1981, Runtime = 130 },
                    new Movie { Title = "Toy Story", ReleaseYear = 1994, Runtime = 90 }
                );
        }
    }
}

5.在程序包控制器控制台，输入update-database,此时再localdb下面会自动生成数据库