2021-05-26

EntityFramework增删改

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

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

.

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

3.利用上层关系实行增加

   //新增
        protected void Button1_Click(object sender, EventArgs e)
        {
            //给Catelog所要新增表重新实例化
            Catelog c = new Catelog();
            //创建你所要新增的内容
            c.Name = "二狗子";
            c.Comment = "二蛋";
            //数据中修改保存对应的行数
            int count = en.SaveChanges();
            if (count > 0)
            {
                Console.Write("添加成功");
            }
        }

4修改

     //修改
        protected void Button2_Click(object sender, EventArgs e)
        {
            Article art = en.Article.Where(p => p.id == 1).FirstOrDefault();
            //创建你所要改的类和数据
            art.Title = "SS";
            //让他保存上面的操作
            en.SaveChanges();
            //给他重新绑定，让后查询全表，利用Button进行修改
            this.Repeater1.DataSource = (from a in en.Article
                                         join c in en.Catelog on a.Catelogid equals c.id
                                         select new { Title = a.Title, Content = a.Content, Author = a.Author, CatelogName = c.Name }).ToList(); ;
            this.Repeater1.DataBind();
        }

5.删除

  //删除
        protected void Button3_Click(object sender, EventArgs e)
        {
            
            using (DB190Entities en = new DB190Entities())
            {
                //创建是要删除的对象
                Article art = new Article { id = 1 };
                //附加刀EF中
                en.Article.Attach(art);
                //标记删除
                en.Article.Remove(art);
                //让他保存上面的操作
                en.SaveChanges();
                //给他重新绑定，让后查询全表，利用Button进行修改
                this.Repeater1.DataSource = (from a in en.Article
                                             join c in en.Catelog on a.Catelogid equals c.id
                                             select new { Title = a.Title, Content = a.Content, Author = a.Author, CatelogName = c.Name }).ToList(); ;
                this.Repeater1.DataBind();
            }
        }