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