public void Does_fallback_to_reference_convention_when_alias_is_used() { using (var db = OpenDbConnection()) { db.DropTable <AliasedCustomer>(); db.DropTable <AliasedCustomerAddress>(); db.CreateTable <AliasedCustomerAddress>(); db.CreateTable <AliasedCustomer>(); var customer1 = new AliasedCustomer { Name = "Name 1", WorkAddress = new AliasedCustomerAddress { AddressLine1 = "1 Work Road", Country = "UK", }, HomeAddress = new AliasedCustomerAddress { AddressLine1 = "2 Home Street", Country = "US", } }; var customer2 = new AliasedCustomer { Name = "Name 2", WorkAddress = new AliasedCustomerAddress { AddressLine1 = "3 Work Road", Country = "AU", }, HomeAddress = new AliasedCustomerAddress { AddressLine1 = "4 Home Street", Country = "NZ", } }; db.Save(customer1, references: true); db.Save(customer2, references: true); db.Select <AliasedCustomer>().PrintDump(); db.Select <AliasedCustomerAddress>().PrintDump(); var dbCustomers = db.LoadSelect <AliasedCustomer>(); dbCustomers.PrintDump(); var dbCustomer1 = dbCustomers.First(x => x.Name == "Name 1"); Assert.That(dbCustomer1.Name, Is.EqualTo("Name 1")); Assert.That(dbCustomer1.WorkAddress, Is.Not.Null); Assert.That(dbCustomer1.WorkAddress.Country, Is.EqualTo("UK")); Assert.That(dbCustomer1.HomeAddress, Is.Not.Null); Assert.That(dbCustomer1.HomeAddress.Country, Is.EqualTo("US")); var dbCustomer2 = db.LoadSingleById <AliasedCustomer>(customer2.Id); Assert.That(dbCustomer2.Name, Is.EqualTo("Name 2")); Assert.That(dbCustomer2.WorkAddress, Is.Not.Null); Assert.That(dbCustomer2.WorkAddress.Country, Is.EqualTo("AU")); Assert.That(dbCustomer2.HomeAddress, Is.Not.Null); Assert.That(dbCustomer2.HomeAddress.Country, Is.EqualTo("NZ")); } }
public void Does_fallback_to_reference_convention_when_alias_is_used() { using (var db = OpenDbConnection()) { db.DropTable<AliasedCustomer>(); db.DropTable<AliasedCustomerAddress>(); db.CreateTable<AliasedCustomerAddress>(); db.CreateTable<AliasedCustomer>(); var customer1 = new AliasedCustomer { Name = "Name 1", WorkAddress = new AliasedCustomerAddress { AddressLine1 = "1 Work Road", Country = "UK", }, HomeAddress = new AliasedCustomerAddress { AddressLine1 = "2 Home Street", Country = "US", } }; var customer2 = new AliasedCustomer { Name = "Name 2", WorkAddress = new AliasedCustomerAddress { AddressLine1 = "3 Work Road", Country = "AU", }, HomeAddress = new AliasedCustomerAddress { AddressLine1 = "4 Home Street", Country = "NZ", } }; db.Save(customer1, references: true); db.Save(customer2, references: true); db.Select<AliasedCustomer>().PrintDump(); db.Select<AliasedCustomerAddress>().PrintDump(); var dbCustomers = db.LoadSelect<AliasedCustomer>(); dbCustomers.PrintDump(); var dbCustomer1 = dbCustomers.First(x => x.Name == "Name 1"); Assert.That(dbCustomer1.Name, Is.EqualTo("Name 1")); Assert.That(dbCustomer1.WorkAddress, Is.Not.Null); Assert.That(dbCustomer1.WorkAddress.Country, Is.EqualTo("UK")); Assert.That(dbCustomer1.HomeAddress, Is.Not.Null); Assert.That(dbCustomer1.HomeAddress.Country, Is.EqualTo("US")); var dbCustomer2 = db.LoadSingleById<AliasedCustomer>(customer2.Id); Assert.That(dbCustomer2.Name, Is.EqualTo("Name 2")); Assert.That(dbCustomer2.WorkAddress, Is.Not.Null); Assert.That(dbCustomer2.WorkAddress.Country, Is.EqualTo("AU")); Assert.That(dbCustomer2.HomeAddress, Is.Not.Null); Assert.That(dbCustomer2.HomeAddress.Country, Is.EqualTo("NZ")); } }