public bool TransactionHistoryDelete(TransactionHistory transactionhistory)
        {
            return Execute<bool>(dal =>
            {
                TransactionHistory transactionhistoryDelete = dal.TransactionHistory.Where(x => x.TransactionID == transactionhistory.TransactionID).FirstOrDefault();
                if (transactionhistoryDelete != null)
                {
                    dal.TransactionHistory.DeleteOnSubmit(transactionhistoryDelete);
                    dal.SubmitChanges();
                    return true;
                }
                return false;

            });
        }
        public bool TransactionHistoryUpdate(TransactionHistory transactionhistory)
        {
            return Execute<bool>(dal =>
            {
                TransactionHistory transactionhistoryUpdate = dal.TransactionHistory.Where(x => x.TransactionID == transactionhistory.TransactionID).FirstOrDefault();
                if (transactionhistoryUpdate != null)
                {
                    transactionhistoryUpdate.TransactionID = transactionhistory.TransactionID;
                    transactionhistoryUpdate.ProductID = transactionhistory.ProductID;
                    transactionhistoryUpdate.ReferenceOrderID = transactionhistory.ReferenceOrderID;
                    transactionhistoryUpdate.ReferenceOrderLineID = transactionhistory.ReferenceOrderLineID;
                    transactionhistoryUpdate.TransactionDate = transactionhistory.TransactionDate;
                    transactionhistoryUpdate.TransactionType = transactionhistory.TransactionType;
                    transactionhistoryUpdate.Quantity = transactionhistory.Quantity;
                    transactionhistoryUpdate.ActualCost = transactionhistory.ActualCost;
                    transactionhistoryUpdate.ModifiedDate = transactionhistory.ModifiedDate;

                    dal.SubmitChanges();
                    return true;
                }
                return false;

            });
        }
		private void detach_TransactionHistories(TransactionHistory entity)
		{
			this.SendPropertyChanging();
			entity.Product = null;
		}
 partial void DeleteTransactionHistory(TransactionHistory instance);
 partial void UpdateTransactionHistory(TransactionHistory instance);
 partial void InsertTransactionHistory(TransactionHistory instance);
 public void TransactionHistoryUpdate(TransactionHistory transactionhistory)
 {
     adventureWorks_BC.TransactionHistoryUpdate(transactionhistory);
 }
 public void TransactionHistoryAdd(TransactionHistory transactionhistory)
 {
     adventureWorks_BC.TransactionHistoryAdd(transactionhistory);
 }