在EF中做数据索引

最新推荐文章于 2021-02-06 20:27:07 发布

weixin_30305735

最新推荐文章于 2021-02-06 20:27:07 发布

阅读量299

点赞数

文章标签：数据库 c#

原文链接：http://www.cnblogs.com/jiangcm/p/7351274.html

版权

namespace MigrationsCodeDemo.Migrations
{
    using System.Data.Entity.Migrations;

    public partial class AddPostClass : DbMigration
    {
        public override void Up()
        {
            CreateTable(
                "Posts",
                c => new
                    {
                        PostId = c.Int(nullable: false, identity: true),
                        Title = c.String(maxLength: 200),
                        Content = c.String(),
                        BlogId = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.PostId)
                .ForeignKey("Blogs", t => t.BlogId, cascadeDelete: true)
                .Index(t => t.BlogId)
                .Index(p => p.Title, unique: true);

            AddColumn("Blogs", "Rating", c => c.Int(nullable: false, defaultValue: 3));
        }

    }
}