public void Can_Save_and_Load_Self_References()
{
var customer = new SelfCustomer
{
Name = "Customer 1",
PrimaryAddress = new SelfCustomerAddress
{
AddressLine1 = "1 Humpty Street",
City = "Humpty Doo",
State = "Northern Territory",
Country = "Australia"
},
};
db.Save(new SelfCustomer {
Name = "Dummy Incrementer"
});
db.Save(customer);
Assert.That(customer.Id, Is.GreaterThan(0));
Assert.That(customer.SelfCustomerAddressId, Is.Null);
db.SaveReferences(customer, customer.PrimaryAddress);
Assert.That(customer.SelfCustomerAddressId, Is.EqualTo(customer.PrimaryAddress.Id));
var dbCustomer = db.LoadSingleById <SelfCustomer>(customer.Id);
Assert.That(dbCustomer.PrimaryAddress, Is.Not.Null);
customer = new SelfCustomer
{
Name = "Customer 2",
PrimaryAddress = new SelfCustomerAddress
{
AddressLine1 = "2 Humpty Street",
City = "Humpty Doo",
State = "Northern Territory",
Country = "Australia"
},
};
db.Save(customer, references: true);
Assert.That(customer.SelfCustomerAddressId, Is.EqualTo(customer.PrimaryAddress.Id));
dbCustomer = db.LoadSingleById <SelfCustomer>(customer.Id);
Assert.That(dbCustomer.PrimaryAddress, Is.Not.Null);
}
public void Can_save_and_load_self_references_with_null_references()
{
var customer = new SelfCustomer
{
Name = "Customer 1",
PrimaryAddress = null,
};
db.Save(customer, references: true);
Assert.That(customer.Id, Is.GreaterThan(0));
var dbCustomer = db.LoadSingleById <SelfCustomer>(customer.Id);
Assert.That(dbCustomer.Name, Is.EqualTo("Customer 1"));
var dbCustomers = db.LoadSelect <SelfCustomer>(q => q.Id == customer.Id);
Assert.That(dbCustomers.Count, Is.EqualTo(1));
Assert.That(dbCustomers[0].Name, Is.EqualTo("Customer 1"));
}
public void Can_Save_and_Load_Self_References()
{
var customer = new SelfCustomer
{
Name = "Customer 1",
PrimaryAddress = new SelfCustomerAddress
{
AddressLine1 = "1 Humpty Street",
City = "Humpty Doo",
State = "Northern Territory",
Country = "Australia"
},
};
db.Save(new SelfCustomer { Name = "Dummy Incrementer" });
db.Save(customer);
Assert.That(customer.Id, Is.GreaterThan(0));
Assert.That(customer.SelfCustomerAddressId, Is.Null);
db.SaveReferences(customer, customer.PrimaryAddress);
Assert.That(customer.SelfCustomerAddressId, Is.EqualTo(customer.PrimaryAddress.Id));
var dbCustomer = db.LoadSingleById<SelfCustomer>(customer.Id);
Assert.That(dbCustomer.PrimaryAddress, Is.Not.Null);
customer = new SelfCustomer
{
Name = "Customer 2",
PrimaryAddress = new SelfCustomerAddress
{
AddressLine1 = "2 Humpty Street",
City = "Humpty Doo",
State = "Northern Territory",
Country = "Australia"
},
};
db.Save(customer, references: true);
Assert.That(customer.SelfCustomerAddressId, Is.EqualTo(customer.PrimaryAddress.Id));
dbCustomer = db.LoadSingleById<SelfCustomer>(customer.Id);
Assert.That(dbCustomer.PrimaryAddress, Is.Not.Null);
}
public void Can_save_and_load_self_references_with_null_references()
{
var customer = new SelfCustomer
{
Name = "Customer 1",
PrimaryAddress = null,
};
db.Save(customer, references: true);
Assert.That(customer.Id, Is.GreaterThan(0));
var dbCustomer = db.LoadSingleById<SelfCustomer>(customer.Id);
Assert.That(dbCustomer.Name, Is.EqualTo("Customer 1"));
var dbCustomers = db.LoadSelect<SelfCustomer>(q => q.Id == customer.Id);
Assert.That(dbCustomers.Count, Is.EqualTo(1));
Assert.That(dbCustomers[0].Name, Is.EqualTo("Customer 1"));
}