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); } }