MVC DbContext

指定数据连接，指定表名，移除表名复数化（表名后面不加s），设置字段约束，主外键关系。

using MvcApplication1.Models;
using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Data.Entity.ModelConfiguration.Conventions;
using System.Linq;
using System.Web;
using System.ComponentModel.DataAnnotations;

namespace MvcApplication1.Repositories
{
    public class EFContext : DbContext
    {
　　　　 //指定数据库连接字符串 name是 DefaultConnection
        public EFContext() : base("DefaultConnection") { }

        public DbSet<AdminInfo> AdminInfos { get; set; }
        public DbSet<ArticlesInfo> ArticlesInfos { get; set; }
        public DbSet<BannerInfo> BannerInfos { get; set; }
        public DbSet<CandidatesInfo> CandidatesInfos { get; set; }
        public DbSet<FriendLinksInfo> FriendLinksInfos { get; set; }
        public DbSet<PartnersInfo> PartnersInfos { get; set; }
        public DbSet<RecruitmentInfo> RecruitmentInfos { get; set; }
        public DbSet<SingleArticle> SingleArticles { get; set; }

        /// <summary>
        /// 构造表
        /// </summary>
        /// <param name="modelBuilder"></param>
        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();//移除表名复数的契约

            #region 管理员信息
            modelBuilder.Entity<AdminInfo>().HasKey(k => k.ID); //设置主键
            modelBuilder.Entity<AdminInfo>().Property(q => q.UserName).IsRequired().HasMaxLength(50);//设置不能为空
            modelBuilder.Entity<AdminInfo>().Property(q => q.UserPwd).IsRequired().HasMaxLength(50);//设置不能为空
            #endregion

            #region 招聘信息
            modelBuilder.Entity<RecruitmentInfo>().HasKey(k => k.ID);
            modelBuilder.Entity<RecruitmentInfo>().Property(q => q.TypeID).IsRequired();
            modelBuilder.Entity<RecruitmentInfo>().Property(q => q.Title).IsRequired().HasMaxLength(500);
            modelBuilder.Entity<RecruitmentInfo>().Property(q => q.RequireNum).IsRequired().HasMaxLength(50);
            modelBuilder.Entity<RecruitmentInfo>().Property(q => q.PostCharacter).IsRequired().HasMaxLength(500);
            modelBuilder.Entity<RecruitmentInfo>().Property(q => q.Responsibilities).IsRequired().HasMaxLength(500);
            modelBuilder.Entity<RecruitmentInfo>().Property(q => q.Qualification).IsRequired().HasMaxLength(500);
            modelBuilder.Entity<RecruitmentInfo>().Property(q => q.CreateDate).IsRequired();

            //主表包含多个：CandidatesInfoList；子表含有一个：RecruitmentInfoModel；子表中对应主表的外键：RecruitmentID。
            modelBuilder.Entity<RecruitmentInfo>().HasMany(s => s.CandidatesInfoList).WithRequired(c => c.RecruitmentInfoModel).HasForeignKey(f => f.RecruitmentID);
            #endregion

            #region 应聘者信息
            modelBuilder.Entity<CandidatesInfo>().HasKey(k => k.ID);
            modelBuilder.Entity<CandidatesInfo>().Property(q => q.RecruitmentID).IsRequired();
            modelBuilder.Entity<CandidatesInfo>().Property(q => q.Name).IsRequired().HasMaxLength(500);
            modelBuilder.Entity<CandidatesInfo>().Property(q => q.MaritalStatus).IsRequired().HasMaxLength(500);
            modelBuilder.Entity<CandidatesInfo>().Property(q => q.NativePlace).IsRequired().HasMaxLength(500);
            modelBuilder.Entity<CandidatesInfo>().Property(q => q.DomicileLocation).IsRequired().HasMaxLength(500);
            modelBuilder.Entity<CandidatesInfo>().Property(q => q.BirthDay).IsRequired().HasMaxLength(500);
            modelBuilder.Entity<CandidatesInfo>().Property(q => q.Age).IsRequired().HasMaxLength(500);
            modelBuilder.Entity<CandidatesInfo>().Property(q => q.IDCard).IsRequired().HasMaxLength(500);
            modelBuilder.Entity<CandidatesInfo>().Property(q => q.Education).IsRequired().HasMaxLength(500);
            modelBuilder.Entity<CandidatesInfo>().Property(q => q.Hobby).IsRequired().HasMaxLength(500);
            modelBuilder.Entity<CandidatesInfo>().Property(q => q.Address).IsRequired().HasMaxLength(500);
            modelBuilder.Entity<CandidatesInfo>().Property(q => q.Areas).IsRequired().HasMaxLength(500);
            modelBuilder.Entity<CandidatesInfo>().Property(q => q.Email).IsRequired().HasMaxLength(500);
            modelBuilder.Entity<CandidatesInfo>().Property(q => q.Mobile).IsRequired().HasMaxLength(500);
            #endregion

            #region 文章信息
            modelBuilder.Entity<ArticlesInfo>().HasKey(k => k.ID);//编号
            modelBuilder.Entity<ArticlesInfo>().Property(q => q.TypeID).IsRequired();//类型 1：集团新闻  2:行业动态
            modelBuilder.Entity<ArticlesInfo>().Property(q => q.Title).IsRequired();//标题
            modelBuilder.Entity<ArticlesInfo>().Property(q => q.IsRecommend).IsRequired();//推荐 0：不推荐 1：推荐
            modelBuilder.Entity<ArticlesInfo>().Property(q => q.Img).IsRequired();//配图
            modelBuilder.Entity<ArticlesInfo>().Property(q => q.Contents).IsRequired();//内容
            modelBuilder.Entity<ArticlesInfo>().Property(q => q.CreateDate).IsRequired();//创建日期
            #endregion

            #region Banner
            modelBuilder.Entity<BannerInfo>().HasKey(k => k.ID);//编号
            modelBuilder.Entity<BannerInfo>().Property(q => q.Name).IsRequired();//名称
            modelBuilder.Entity<BannerInfo>().Property(q => q.Img).IsRequired();//图片
            modelBuilder.Entity<BannerInfo>().Property(q => q.LinkUrl).IsRequired();//链接
            #endregion

            #region 友情链接表
            modelBuilder.Entity<FriendLinksInfo>().HasKey(q => q.ID);//编号
            modelBuilder.Entity<FriendLinksInfo>().Property(q => q.Name).IsRequired();//名称
            modelBuilder.Entity<FriendLinksInfo>().Property(q => q.LinkUrl).IsRequired();//链接
            #endregion

            #region 合作伙伴表
            modelBuilder.Entity<PartnersInfo>().HasKey(q => q.ID);//编号
            modelBuilder.Entity<PartnersInfo>().Property(q => q.Name).IsRequired();//名称
            modelBuilder.Entity<PartnersInfo>().Property(q => q.Img).IsRequired();//图标
            modelBuilder.Entity<PartnersInfo>().Property(q => q.LinkUrl).IsRequired();//链接
            #endregion

            #region 单篇图文信息
            modelBuilder.Entity<SingleArticle>().HasKey(q => q.ID);//编号
            modelBuilder.Entity<SingleArticle>().Property(q => q.Title).IsRequired();//标题
            modelBuilder.Entity<SingleArticle>().Property(q => q.Contents).IsRequired();//内容
            modelBuilder.Entity<SingleArticle>().Property(q => q.CreateDate).IsRequired();//创建日期
            #endregion


            #region 添加默认数据

            #endregion
        }
    }
}