internal EntityEntry DeleteEntity() { Console.WriteLine("*** Delete Entity *** "); var person = _context.Person.Find(1); //This isnt in memory => retrieved from database _context.Entry(person).State = EntityState.Deleted; //This must be in memory => retrieved from database _context.Person.Remove(person); _context.SaveChanges(); return(_context.ChangeTracker.Entries().First()); }
public bool UpdateProductQuantity(ProductInventoryUpdateModel updateModel) { var data = _db.Product.Find(updateModel.ProductId); data.Quantity = updateModel.Quantity; _db.SaveChanges(); return(true); }
public void AddAnItem() { ShouldExecuteInATransaction(AddNewPerson); void AddNewPerson() { var person = new Person { AdditionalContactInfo = "Home", FirstName = "Barney", LastName = "Rubble", Title = "Neighbor" }; _context.Person.Add(person); _context.SaveChanges(); } }
private void PrepareData() { if (!_awDbContext.Product.Any()) { var catgories = new List <ProductCategory> { new ProductCategory { ProductCategoryId = 1, Name = "MyCat1" }, new ProductCategory { ProductCategoryId = 2, Name = "MyCat2" } }; var subCategores = new List <ProductSubcategory> { new ProductSubcategory { ProductSubcategoryId = 1, ProductCategoryId = 1, Name = "MuSubCat1" }, new ProductSubcategory { ProductSubcategoryId = 2, ProductCategoryId = 2, Name = "MuSubCat2" } }; var products = new List <Product> { new Product { ProductId = 1, Name = "Product1", Quantity = 10, ProductSubcategoryId = 1 }, new Product { ProductId = 2, Name = "Product2", Quantity = 20, ProductSubcategoryId = 2 } }; _awDbContext.ProductCategory.AddRange(catgories); _awDbContext.ProductSubcategory.AddRange(subCategores); _awDbContext.Product.AddRange(products); _awDbContext.SaveChanges(); } }
public void AddAnItem() { //helper method ShouldExecuteInATransaction(AddNewPerson); //local function void AddNewPerson() { //INSERT INTO PERSON and just these fields right here //Also executes in server side things "row verison" var person = new Person { AdditionalContactInfo = "Home", FirstName = "Fname", LastName = "Lname", Title = "Neighbor" }; _context.Person.Add(person); _context.SaveChanges(); } }