Example #1
0
        static void Main(string[] args)
        {
            //Create a method that places a new order in the Northwind database.
            //    The order should contain several order items.
            //        Use transaction to ensure the data consistency.

            Product p1 = new Product();
            p1.ProductName = "Tesla";
            p1.UnitPrice = 20.20M;
            DAO.db.Products.AddObject(p1);

            Product p2 = new Product();
            p2.ProductName = "Kashon";
            p2.UnitPrice = 14.20M;
            DAO.db.Products.AddObject(p2);

            List<Product> products = new List<Product>();
            products.Add(p1);
            products.Add(p2);

            Order order = new Order();
            order.ShipCountry = "Bulgaria";
            order.CustomerID = "ALFKI";

            DAO.db.Orders.AddObject(order);

            DAO.db.SaveChanges();

            DAO.AddOrderDetails(products, order);
        }
 /// <summary>
 /// Deprecated Method for adding a new object to the Products EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.
 /// </summary>
 public void AddToProducts(Product product)
 {
     base.AddObject("Products", product);
 }
 /// <summary>
 /// Create a new Product object.
 /// </summary>
 /// <param name="productID">Initial value of the ProductID property.</param>
 /// <param name="productName">Initial value of the ProductName property.</param>
 /// <param name="discontinued">Initial value of the Discontinued property.</param>
 public static Product CreateProduct(global::System.Int32 productID, global::System.String productName, global::System.Boolean discontinued)
 {
     Product product = new Product();
     product.ProductID = productID;
     product.ProductName = productName;
     product.Discontinued = discontinued;
     return product;
 }