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 }