.net mvc5(二)

来源：互联网发布：海康网络摄像机激活编辑：程序博客网时间：2024/05/17 21:28

上次创建了基本的框架，现在开始进行Model层的编写

一、新建User类

using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.ComponentModel;using System.ComponentModel.DataAnnotations;namespace MyDiary.Models{        public class User    {        [DisplayName("Id")]        public int Id { get; set; }        [DisplayName("UserName"),Required]        public string UserName { get; set; }        [DisplayName("PassWord"),Required,DataType(DataType.Password)]        public string PassWord { get; set; }        [DisplayName("Diaries")]        public virtual List<Diary> Diaries { get; set; }    }}

(1)public int Id { get; set; }

(2)属性的展现 [DisplayName("Id")]

(3)对属性的验证是否为空,关键字Required

[DisplayName("UserName"),Required]

(3)属性是密码类型的 DataType(DataType.Password)

(4)一个用户可以拥有多个日记，所以用一个List来标识该属性

public virtual List<Diary> Diaries { get; set; }

二、同样新建Diary类

using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.ComponentModel;using System.ComponentModel.DataAnnotations;namespace MyDiary.Models{    public class Diary    {        [DisplayName("Id")]        public int Id { get; set; }        [DisplayName("Title"), Required]        public string Title { get; set; }        [DisplayName("Content"), Required]        public string Content { get; set; }        [DisplayName("PubDate"), DataType(DataType.Date)]        public DateTime? PubDate { get; set; }        [DisplayName("UserId")]        public int UserId { get; set; }        [DisplayName("User")]        public virtual User User { get; set; }    }}

（1）一篇日记属于某一个用户的,关联用户Id

public int UserId { get; set; }

三、新建DiaryDB类来关联数据库的增,删,改,查

using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Data.Entity;namespace MyDiary.Models{    public class DiaryDB:DbContext    {        public DbSet<Diary> Diaries { get; set; }        public DbSet<User> Users { get; set; }    }}

(1)DbContext主要是与数据库进行会话

(2)DbSet:提供对数据实体的操作，如增、改、查，继承了DBQuery的一些功能

四、创建数据库，新建

using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Data.Entity;namespace MyDiary.Models{    public class SampleData:DropCreateDatabaseAlways<DiaryDB>    {        protected override void Seed(DiaryDB context)        {            context.Users.Add(new User {             UserName ="lili",            PassWord = "lili",            Diaries = new List<Diary>            {                new Diary{Title="Title01", Content="Conten1",PubDate=System.DateTime.Now },                new Diary{Title="Title02", Content="Conten2",PubDate=System.DateTime.Now },                new Diary{Title="Title03", Content="Conten3",PubDate=System.DateTime.Now }            }            });            context.Users.Add(new User            {                UserName = "Kevin",                PassWord = "Kevin",                Diaries = new List<Diary>            {                new Diary{Title="Title04", Content="Conten4",PubDate=System.DateTime.Now },                new Diary{Title="Title05", Content="Conten5",PubDate=System.DateTime.Now },                new Diary{Title="Title06", Content="Conten6",PubDate=System.DateTime.Now }            }            });            base.Seed(context);        }    }}

（1）DropCreateDatabaseAlways：每次都删除数据库以及创建数据库

(2) Seed方法里面加入表User和Diary的测试数据

五、数据库字符串链接，修改web.config文件

字符串链接的

  <connectionStrings>    <add name="MyDiary.Models.DiaryDB" providerName="System.Data.Sqlclient" connectionString="Data Source=.;Initial Catalog=DiaryDB;User ID=sa;Password=123456" />  </connectionStrings>

六、修改Global文件，开始启动的时候就初始化数据库

 protected void Application_Start()        {            AreaRegistration.RegisterAllAreas();            WebApiConfig.Register(GlobalConfiguration.Configuration);            FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);            RouteConfig.RegisterRoutes(RouteTable.Routes);            Database.SetInitializer(new SampleData());        }

总上所述，就完成了Model层的数据库的创建以及相关的链接了

0 0