public static void Initialize(SentryDbContext c) { c.Database.EnsureCreated(); if (c.CountryCurrencies.Any()) { return; } var regions = SystemRegionInfo.GetRegionsList(); foreach (var r in regions) { if (!SystemRegionInfo.IsCountry(r)) { continue; } var x = new CountryCurrencyDbRecord(); x.CountryID = r.ThreeLetterISORegionName; x.CurrencyID = r.ISOCurrencySymbol; c.CountryCurrencies.Add(x); } c.SaveChanges(); }
public static CountryCurrencyObject Create(CountryObject country, CurrencyObject currency, DateTime?validFrom = null, DateTime?validTo = null) { var o = new CountryCurrencyDbRecord { Country = country?.DbRecord ?? new CountryDbRecord(), Currency = currency?.DbRecord ?? new CurrencyDbRecord(), ValidFrom = validFrom ?? DateTime.MinValue, ValidTo = validTo ?? DateTime.MaxValue }; o.CountryID = o.Country.ID; o.CurrencyID = o.Currency.ID; return(new CountryCurrencyObject(o)); }