public void Should_Not_Save_All_Changes_To_The_Database_When_Commiting_A_Transactio_Scope()
{
var customer = new Customer { name = "Tester" };
var entities = new Entities();
entities.AddToCustomerSet(customer);
entities.SaveChanges();
using (var transactionScope = new TransactionScope())
{
customer.name = "Updated tester";
transactionScope.Complete();
}
entities.Refresh(RefreshMode.StoreWins, customer);
Assert.That(customer.name, Is.EqualTo("Tester"));
entities.DeleteObject(customer);
}
public void addPymentMethodWithEntityFramework()
{
var customer = new Customer { name = "Sciemniacz" };
var creditCardPaymentMethod = new CreditCardPaymentMethod() { cardHolderName = "Roman", cardNumber = "123123", cardType = "visa", registrationDate = DateTime.Now, status = 1, AssignedTo = customer};
var directDebitPaymentMethod = new DirectDebitPaymentMethod()
{bankAccountNumber = "12345", holderName = "Roman", registrationDate = DateTime.Now, status = 2, AssignedTo = customer};
customer.UsedPaymentMethod = creditCardPaymentMethod;
var entities = new Entities();
entities.AddToPaymentMethodSet(creditCardPaymentMethod);
entities.AddToPaymentMethodSet(directDebitPaymentMethod);
entities.SaveChanges();
var entities1 = new Entities();
List<PaymentMethod> paymentMethods = entities1.PaymentMethodSet
.Where(x => x.registrationDate < DateTime.Now)
.ToList();
foreach (var paymentMethod in paymentMethods)
{
Console.WriteLine(paymentMethod.GetType());
}
}
public void ShouldRetrieveAllCustomerRelatioinshipsWithAPerformantQuery_EF()
{
using (new TransactionScope())
{
var customer = new Customer { name = "Test Customer" };
var paymentMethod = new DirectDebitPaymentMethod
{
AssignedTo = customer,
bankAccountNumber= "1234",
holderName = "Test Customer",
registrationDate= DateTime.Today,
status = 1
};
customer.Services.Add(new Service { BoughtBy = customer, MonthlyFee = 20, Name = "Voip" });
var entities = new Entities();
entities.AddToCustomerSet(customer);
entities.AddToPaymentMethodSet(paymentMethod);
entities.SaveChanges();
customer.UsedPaymentMethod = paymentMethod;
entities.SaveChanges();
entities = new Entities();
List<Customer> customers = entities.CustomerSet.Include("UsedPaymentMethod").Include("Services").Where(
x => x.name == "Test Customer").ToList();
Assert.That(customers, Has.Count.EqualTo(1));
Assert.That(customer.Services, Has.Count.EqualTo(1));
Assert.That(customer.UsedPaymentMethod, Is.Not.Null);
}
}
public void WhenRemovingCustomerShouldRemoveAlsoServices_withEF()
{
using (new TransactionScope())
{
var entities = new Entities();
var customer = new Customer {name = "RJ"};
customer.Services.Add(new Service{Name = "VOIP", MonthlyFee = 20});
entities.AddToCustomerSet(customer);
entities.SaveChanges();
entities = new Entities();
Customer retrievedCustomer = entities.CustomerSet.Include("Services").Where(c => c.id == customer.id).First();
entities.DeleteObject(retrievedCustomer);
entities.SaveChanges();
}
}
/// <summary>
/// Create a new Customer object.
/// </summary>
/// <param name="id">Initial value of the id property.</param>
/// <param name="name">Initial value of the name property.</param>
public static Customer CreateCustomer(global::System.Int32 id, global::System.String name)
{
Customer customer = new Customer();
customer.id = id;
customer.name = name;
return customer;
}
/// <summary>
/// Deprecated Method for adding a new object to the CustomerSet EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToCustomerSet(Customer customer)
{
base.AddObject("CustomerSet", customer);
}