Entity Framework DBFirst尝试

    class Program
    {
        static void Main(string[] args)
        {
            using (var db = new NorthwindEntitiess())
            {
                IQueryable<Product> List = from Products in db.Products
                                           where Products.ProductID > 11 && Products.ProductID < 23
                                           select Products;
                foreach (Product p in List)
                {
                    Console.WriteLine("Product Name:{0}",p.ProductName);
                    if (p.ProductName.ToUpper() == ("KonBu").ToUpper())
                    {
                        p.QuantityPerUnit = "aehyok";
                    }
                }

                var Single = from Products in db.Products
                             where Products.ProductName.ToUpper() == ("KonBU").ToUpper()
                             select Products;
                foreach (Product pp in Single)
                {
                    Console.WriteLine("Single is Product Name:{0}", pp.QuantityPerUnit);
                }
                //上面虽然可以查出来QuantityPerUnit，但是实际省并未保存到数据库，具体保存方法在此不再详细描述
            }
            Console.ReadLine();
        }
    }