脚本宝典收集整理的这篇文章主要介绍了【sqlite】3.ADO.NET实体数据模型增删改查,脚本宝典觉得挺不错的,现在分享给大家,也给大家做个参考。
mainEntITies2 dbcontext = new mainEntities2(); PRivate void BTnAdd_Click(object sender, RoutedEventargs e) { Students stu = new Students(); stu.StudentName_ = "李四"; stu.StudentSex_ = "男"; stu.StudentAge_ = 19; stu.StudentProvince_ = "上海"; stu.StudentPhone_ = "17468523001"; dbcontext.Entry<Students>(stu).state = System.Data.Entity.EntityState.Added; int i = dbcontext.SaveChanges(); string str = i == 1 ? "添加成功" : "添加失败"; MessageBox.Show(str); } private void btnDel_Click(object sender, RoutedEventArgs e) { Students stu = new Students(); stu.StudentNO_ = 1; dbcontext.Entry<Students>(stu).State = System.Data.Entity.EntityState.Deleted; int i = dbcontext.SaveChanges(); string str = i == 1 ? "删除成功" : "删除失败"; MessageBox.Show(str); } private void btnUpdate_Click(object sender, RoutedEventArgs e) { @H_572_126@//修改整个 //Students stu = new Students(); //stu.StudentNO_ = 2; //stu.StudentName_ = "李四"; //stu.StudentSex_ = "男"; //stu.StudentAge_ = 19; //stu.StudentProvince_ = "上海"; //stu.StudentPhone_ = "17468523001"; //dbcontext.Entry<Students>(stu).State = System.Data.Entity.EntityState.Added; //int i = dbcontext.SaveChanges(); //string str = i == 1 ? "修改成功" : "修改失败"; //MessageBox.Show(str); //修改某个属性 Students stu = new Students(); stu.StudentNO_ = 2; stu.StudentName_ = "王霸26"; dbcontext.Students.Attach(stu);//必须使用attach //dbcontext.Entry<Students>(stu).ProPErty<string>(s => s.StudentName_).IsModified = true; dbcontext.Entry<Students>(stu).Property("StudentName_").IsModified = true; int i = dbcontext.SaveChanges(); string str = i == 1 ? "修改成功" : "修改失败"; MessageBox.Show(str); } private void btnSelect_Click(object sender, RoutedEventArgs e) { //便利所有 foreach (VAR item in dbcontext.Students) { Console.WriteLine($"学号:{item.StudentNO_} 姓名:{item.StudentName_}"); } //查询整个表女生的信息 var temp = From s in dbcontext.Students where s.StudentSex_ == "女" select s; foreach (var item in temp) { Console.WriteLine($"学号:{item.StudentNO_} 姓名:{item.StudentName_} 性别:{item.StudentSex_}"); } }
以上是脚本宝典为你收集整理的【sqlite】3.ADO.NET实体数据模型增删改查全部内容,希望文章能够帮你解决【sqlite】3.ADO.NET实体数据模型增删改查所遇到的问题。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。