Entity FrameWork DBFirst模式(2)之数据的更新操作(2)

删除记录:

/// <summary>
        /// 删除产品
        /// </summary>
        public static void DeleteProduct()
        {
            using (CRMDBEntities cRMDBEntities = new CRMDBEntities())

            {
                //1.查询到被删除的对象
                Product product = cRMDBEntities.Product.Single<Product>(p => p.ProductNo == 1011);
                cRMDBEntities.Product.Remove(product);
                bool flag = cRMDBEntities.SaveChanges() > 0 ? true : false;//提交到数据库中(持久化操作)
                if (flag)
                {
                    Console.WriteLine("产品已被成功删除!");
                }
                else
                {
                    Console.WriteLine("产品删除失败!");
                }
            }
        }

数据的更新操作:

更新单条记录：

 /// <summary>
        /// 产品的数据更新
        /// </summary>
        public static void UpdateProduct()
        {
            using (CRMDBEntities cRMDBEntities = new CRMDBEntities())
            {
                //查询到需要修改的对象
                Product product = cRMDBEntities.Product.FirstOrDefault<Product>(p => p.ProductName == "摩天沙发");
                //修改数据
                product.Price = 2388;
                product.Description = "低价出售好商品,机不可失!";
                bool flag = cRMDBEntities.SaveChanges() > 0 ? true : false;//持久化操作
                if (flag)
                {
                    Console.WriteLine("产品数据已修改!");
                }
                else
                {
                    Console.WriteLine("数据修改失败!");
                }
            }
        }

批量更新记录:

/// <summary>
        /// 批量更新数据
        /// </summary>
        public static void UpdateManyProducts()
        {
            using (CRMDBEntities cRMDBEntities = new CRMDBEntities())
            {
                //查询到需要修改的对象集合
                List<Product> productList = cRMDBEntities.Product.Where(p => p.TypeId == 5).ToList<Product>();
                productList.ForEach(p => p.Price = p.Price - 100);//每个产品降价100元
                bool flag = cRMDBEntities.SaveChanges() > 0 ? true : false;//持久化操作
                if (flag)
                {
                    Console.WriteLine("数据已批量修改成功!");
                }
                else
                {
                    Console.WriteLine("数据批量修改失败!");
                }
            }
        }