EntityFramework增加和详情

1.先用Entity和数据库建立好关系

--切记外键一定要先在物理数据库中建立

.

2.物理数据库和上图Modle是一个映射的关系

3.先建立一个新增页面，然后利用上面建立的关系进行编写新增代码新增

  protected void Page_Load(object sender, EventArgs e)
        {
            //查询类型表
            var result = (from a in db.Catelog select a).ToList();
            if (!IsPostBack)
            {
                //数据和下拉框进行绑定
                this.DropDownList1.DataSource = result;
                this.DropDownList1.DataTextField = "Name";
                this.DropDownList1.DataValueField = "Id";
                this.DropDownList1.DataBind();
                
                this.DropDownList1.Items.Insert(0, new ListItem("全部", "0"));
            }
        }
        //新增
        protected void Button2_Click(object sender, EventArgs e)
        {
            //给控件赋类型
            string title = this.TextBox1.Text;
            string author = this.TextBox2.Text;
            string context = this.TextBox3.Text;
            int type = int.Parse(this.DropDownList1.SelectedValue);
            DateTime time = DateTime.Now;
            //给文本框赋初始值
            if (type == 0)
            {
                Response.Write($"<script>alert('请选择类型')</script>");
            }
            else
            {
                //给他赋值
                Article a = new Article();
                a.Title = title;
                a.PushTime = time;
                a.Content = context;
                a.Catelogid = type;
                a.Author = author;
                db.Article.Add(a);
                db.SaveChanges();
                //重定向
                Response.Redirect("WebForm1.aspx");
            }
        }

4.再建立一个详情页面

详情

protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                int id = int.Parse(Request["id"].ToString());
                var result = db.Article.FirstOrDefault(P => P.id == id);

                this.Label1.Text = result.Title;
                this.Label2.Text = result.Content;
            }
        }