笔试考试系统 ____项目架构搭建及生产华北南京配置

时间：2020-08-03 10:27:54 阅读：89 评论：0 收藏：0 [点我收藏+]

1.今日完成任务:

(1)..项目架构搭建 asp.net MVC +Entity Framwork(Code First)

(2).生产环境搭建 IIS+Sql Server2017

2.核心源码

(1).项目架构

技术分享图片

Utility:通用类（通用方法、通用字段）

Model:实体类

DAL:数据访问层

BLL:业务逻辑层

UI:视图层

(2).Entity Framwork(Code First)

 1 public class ExamSysDBContext : DbContext
 2     {
 3 
 4         public ExamSysDBContext():base("DBContext")
 5         {
 6             this.Database.CommandTimeout = 600000; //时间单位是毫秒
 7             ////初始化自动迁移
 8             Database.SetInitializer(new MigrateDatabaseToLatestVersion<ExamSysDBContext, Configuration>());
 9             
10         }
11         //默认生成的表名为类型的复数形式，想自定义规则时需要重写数据上下文类的OnModelCreating方法
12         protected override void OnModelCreating(DbModelBuilder modelBuilder)
13         {
14             //base.OnModelCreating(modelBuilder);
15             modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();
16         }    
17         #region  实体类
18         public DbSet<Exam_Answer> Exam_Answer { get; set; }
19         public DbSet<Exam_Library> Exam_Library { get; set; }
20         public DbSet<Exam_Paper> Exam_Paper { get; set; }
21         public DbSet<Exam_PaperRule> Exam_PaperRule { get; set; }
22         public DbSet<Exam_Question> Exam_Question { get; set; }
23         public DbSet<Exam_QuestionOptions> Exam_QuestionOptions { get; set; }
24         public DbSet<Exam_RuleDetail> Exam_RuleDetail { get; set; }
25         public DbSet<Exam_User> Exam_User { get; set; }
26         #endregion      
27 
28     }
29 
30     public class Configuration : DbMigrationsConfiguration<ExamSysDBContext>
31     {
32         public Configuration()
33         {
34             
35             //开启自动迁移
36             AutomaticMigrationsEnabled = true;
37             //迁移的时候是否允许数据丢失
38             AutomaticMigrationDataLossAllowed = true;
39         }
40     }