Example #1
0
 public static void updateproductrecord(int productid)
 {
     using (var context = new AdventureWorksEntities())
     {
         var product = context.Products.Find(productid);
         product.Name = "Steve Bruce Buffer fasa";
         context.SaveChanges();
     }
 }
Example #2
0
 public static void removeproductrecord(int productid)
 {
     using (var context = new AdventureWorksEntities())
     {
         var product = context.Products.Find(productid);
         context.Products.Remove(product);
         context.SaveChanges();
     }
 }
Example #3
0
        public static void insertproductrecord()
        {
            using (var context = new AdventureWorksEntities())
            {
                var product = new Product()
                {
                    ProductID              = context.Products.AsEnumerable <Product>().Last().ProductID + 1,
                    Name                   = "New Product 16",
                    ProductNumber          = "156",
                    Color                  = "Red",
                    StandardCost           = new decimal(1000.97),
                    ListPrice              = new decimal(2000),
                    Size                   = "Large",
                    ThumbNailPhoto         = new byte[100],
                    ThumbnailPhotoFileName = "FileName",
                    ProductCategory        = context.ProductCategories.First <ProductCategory>(),
                    ProductModel           = context.ProductModels.First()
                };

                context.Products.Add(product);
                context.SaveChanges();
                context.Database.Log = x => System.Diagnostics.Debug.WriteLine(x);
            }
        }