Ejemplo n.º 1
0
        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
        }