예제 #1
0
 protected override void Dispose(bool disposing)
 {
     if (disposing)
     {
         db.Dispose();
     }
     base.Dispose(disposing);
 }
예제 #2
0
 protected virtual void Dispose(bool disposing)
 {
     if (this._disposed)
     {
         if (disposing)
         {
             Context.Dispose();
         }
     }
     this._disposed = true;
 }
예제 #3
0
        public static void AddOrders(Order[] orders)
        {
            NORTHWNDEntities db      = new NORTHWNDEntities();
            bool             success = false;

            using (TransactionScope dbscope = new TransactionScope())
            {
                //try
                //{
                foreach (var order in orders)
                {
                    Order_Detail orderDetails = new Order_Detail()
                    {
                        Quantity = 1
                    };
                    orderDetails.Order   = order;
                    orderDetails.Product = db.Products.FirstOrDefault(p => p.ProductID == 1);

                    db.Orders.Add(order);
                    db.Order_Details.Add(orderDetails);
                }

                db.SaveChanges();

                dbscope.Complete();
                success = true;
                //}
                //catch (Exception ex)
                //{
                //    Console.WriteLine("An error occured. "
                //        + "The operation cannot be retried."
                //        + ex.Message);
                //}
            }

            db.Dispose();
        }
예제 #4
0
 protected override void Dispose(bool disposing)
 {
     _db.Dispose();
 }