/// <summary> /// 查询实例 /// </summary> /// <returns></returns> public void select() { using (var entity = new ccf02Entities()) { //DataTable dataTable = entity.person_test; DbSet dt = entity.person_test; } }
/// <summary> /// 添加实例 /// </summary> /// <param name="student"></param> public void Insert(person_test p)//可以添加一个entity 参数 { using (var entity = new ccf02Entities()) { entity.person_test.Add(p); entity.SaveChanges(); } }
/// <summary> /// 修改实例 /// </summary> /// <param name="model"></param> public void Edit(person_test model) { using (var entity = new ccf02Entities()) { entity.Entry(model).State = EntityState.Modified; entity.SaveChanges(); } }
/// <summary> /// 删除某一条数据 /// </summary> /// <param name="id"></param> public void Deleted(int id) //添加两个参数entity & table { using (var entity = new ccf02Entities()) { person_test p = new person_test() { idperson_test = id }; var model = entity.person_test.FirstOrDefault(w => w.idperson_test == id); entity.person_test.Remove(model); entity.SaveChanges(); } }
private void button1_Click(object sender, EventArgs e) { using (var db = new ccf02Entities()) { //刷新 dgv1 this.dataGridView1.Invalidate(); //var info = db.UserInfo.Where(c => c.Age > 10).OrderBy(c => c.Age); //var res = db.person_test.Where(a => a.age == 12).OrderBy(a => a.name); var res = db.person_test; foreach (var info in res) { //db.Entry(info).Collection() ; //richTextBox1.AppendText(info.name.ToString()+"\r\n"); } // Will hit the database var blog = db.person_test.Find(3); // Will return the same instance without hitting the database //db.person_test.Add(new person_test { idperson_test=8,age = 31, name = "generate", sex = "m" }); //db.person_test.Add(new person_test { idperson_test=9,age = 31, name = "generate", sex = "m" }); // Will find the new blog even though it does not exist in the database //delp.name = "ff"; //delp.idperson_test = 0; //db.person_test.Attach(delp); //db.Entry(delp).State = System.Data.Entity.EntityState.Modified; //MessageBox.Show(db.Entry(delp).State.ToString()); //db.Entry(delp).State = System.Data.Entity.EntityState.Deleted; //var newBlog = db.person_test.Remove(delp); db.SaveChanges(); // Will find a User which has a string primary key //var user = db.person_test.Find("neo"); //var s = db.person_test.Find(0); //this.dataGridView1.Refresh(); this.person_testTableAdapter.Fill(this.ccf02DataSet.person_test); } BindingandDisplay(); }