private void ImportCountriesWithAliases() { using (var trans = new TransactionScope()) { using (var tom = Engine.ServiceProvider.CreateEntityRepository()) { foreach (var record in CountryAliasRecords) { var lcid = record.Item1; var alias = record.Item2; var country = tom.Countries.FirstOrDefault(c => c.LCID == lcid); if (country == null) { country = new Country(lcid); tom.Countries.AddObject(country); } if (!tom.CountryAliases.Any(a => a.Name == alias)) { var countryAlias = new CountryAlias(country, alias); tom.CountryAliases.AddObject(countryAlias); } } tom.SaveChanges(); } trans.Complete(); } }
public static string UsingPredefinedClasses() { var p = new PeopleAlias("p"); var c = new CityAlias("c"); var o = new CountryAlias("o"); return(new SqlQuery() .Select(p.Firstname) .Select(p.Surname) .Select(c.CityName) .Select(o.CountryName) .From(p) .From(c) .From(o) .OrderBy(p.Age) .ToString()); }