public static void Main() { Database.SetInitializer(new MigrateDatabaseToLatestVersion <ErisSystemContext, Data.Migrations.EfConfiguration>()); Importer.ImportCountries(); var db = new ErisSystemContext(); var date = new DateTime(1991, 01, 01); var country = db.Countries.Find(3); var hitman = new User(); hitman.AboutMe = "Thug life"; hitman.UserName = "******"; hitman.PasswordHash = "ASFADSFDEFE@#@$@$@ASDFAS"; hitman.DateOfBirth = date; hitman.CountriesOfOperation.Add(country); db.Users.AddOrUpdate(hitman); db.SaveChanges(); var repositoryTest = new EfGenericRepository <User>(db); var hitmen = repositoryTest.All(); foreach (var x in hitmen) { Console.WriteLine(x.UserName); Console.WriteLine(x.Gender); Console.WriteLine(x.AboutMe); Console.WriteLine(x.DateOfBirth); } }
public static void Main() { Database.SetInitializer(new MigrateDatabaseToLatestVersion<ErisSystemContext, Data.Migrations.EfConfiguration>()); Importer.ImportCountries(); var db = new ErisSystemContext(); var date = new DateTime(1991, 01, 01); var country = db.Countries.Find(3); var hitman = new User(); hitman.AboutMe = "Thug life"; hitman.UserName = "******"; hitman.PasswordHash = "ASFADSFDEFE@#@$@$@ASDFAS"; hitman.DateOfBirth = date; hitman.CountriesOfOperation.Add(country); db.Users.AddOrUpdate(hitman); db.SaveChanges(); var repositoryTest = new EfGenericRepository<User>(db); var hitmen = repositoryTest.All(); foreach (var x in hitmen) { Console.WriteLine(x.UserName); Console.WriteLine(x.Gender); Console.WriteLine(x.AboutMe); Console.WriteLine(x.DateOfBirth); } }
public static void ImportCountries() { var countries = GetCountries(PathToTxtFile); var db = new ErisSystemContext(); foreach (var country in countries) { var currentCountry = new Country(); currentCountry.Name = country; db.Countries.Add(currentCountry); } db.SaveChanges(); db.Dispose(); }