public void OneToMany()
{
var sw = new Stopwatch();
sw.Start();
using (var context = new TestContext2("Server=.;Initial Catalog=TestDb;Integrated security=True;"))
{
Console.WriteLine("Init: " + sw.Elapsed);
sw.Restart();
var country = context.Countries.First(c => c.Name == "Hungary");
Console.WriteLine("Select: " + sw.Elapsed);
}
}
public void SelectByJoinedTableValue()
{
var sw = new Stopwatch();
sw.Start();
using (var context = new TestContext2("Server=.;Initial Catalog=TestDb;Integrated security=True;"))
{
Console.WriteLine("Init: " + sw.Elapsed);
sw.Restart();
var stored = context.Address.Where(a => a.CurrentCity.Country.Name == "Hungary" || a.Hometown.Country.Name == "Hungary").Select(a => a.Street).First();
Console.WriteLine("Select: " + sw.Elapsed);
}
}
public void ForeignKeysWriteAndReadBack()
{
var sw = new Stopwatch();
sw.Start();
using (var context = new TestContext2("Server=.;Initial Catalog=TestDb;Integrated security=True;"))
{
Console.WriteLine("Init: " + sw.Elapsed);
sw.Restart();
var hungary = new Country { Name = "Hungary" };
var address = new Address
{
Street = "Futo utca",
CurrentCity = new City { Name = "Budapest", Country = hungary },
Hometown = new City { Name = "Mosonmagyarovar", Country = hungary }
};
context.Address.Add(address);
context.SaveChanges();
Console.WriteLine("Insert: " + sw.Elapsed);
sw.Restart();
var stored = context.Address.First(a => a.Street == "Futo utca");
Console.WriteLine("Select: " + sw.Elapsed);
Assert.AreNotEqual(stored.Id, 0);
Assert.AreEqual(address.Street, stored.Street);
Assert.AreNotEqual(stored.CurrentCity.Id, 0);
Assert.AreEqual(address.CurrentCity.Name, stored.CurrentCity.Name);
Assert.AreNotEqual(stored.Hometown.Id, 0);
Assert.AreEqual(address.Hometown.Name, stored.Hometown.Name);
}
}
