public void Update(it_log obj) { using (ittransactionlogEntities db = new ittransactionlogEntities()) { db.it_log.Attach(obj); db.Entry(obj).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } }
public it_log Insert(it_log obj) { using (ittransactionlogEntities db = new ittransactionlogEntities()) { db.it_log.Add(obj); db.SaveChanges(); return(obj); } }
public void Delete(int id) { using (ittransactionlogEntities db = new ittransactionlogEntities()) { //using (dbemployeeEntities db = new dbemployeeEntities()) //{ // db.Database.ExecuteSqlCommand("UPDATE employee_info SET lastname = 'SQLTEST' WHERE empID = 19"); //} var delete = (from l in db.it_log where l.it_log_id.Equals(id) select l).FirstOrDefault(); db.it_log.Attach(delete); db.it_log.Remove(delete); db.SaveChanges(); } }