public void deleteData() { ////Here TestEntities is the class which is given from "Save entity connection setting in web.config" //Datacontext2 context = new Datacontext2(); //var query = (from data in context.AddToursTables // where data.Id == 1 // orderby data.AddTour // select data).First(); //context.Attach(query); ////DeleteObject is used to the delete the entity onject. //context.DeleteObject(); //context.SaveChanges(); Datacontext2 db = new Datacontext2(); // Arrange the context //AddToursTable dept = db.AddToursTables.Single(p => p.Id == 1); // Find the item to remove var dept = (from data in db.AddToursTables where data.Id == 3 orderby data.AddTour select data).FirstOrDefault(); db.AddToursTables.Remove(dept); // Remove from the context db.SaveChanges(); // Delete from the database }
public bool AddCustomer(AdminTable entity) { if (entity != null) { //dbcontext.AdminTables.Add(entity); dbcontext.SaveChanges(); return(true); } else { return(false); } }
public bool AddCustomer(custregTable entity) { if (entity != null) { dbcontext2.custregTables.Add(entity); dbcontext2.SaveChanges(); return(true); } else { return(false); } }
//addtours public bool AddTour(AddToursTable entity) { if (entity != null) { dbcontext3.AddToursTables.Add(entity); dbcontext3.SaveChanges(); return(true); } else { return(false); } }