private void BtAddGender_Click(object sender, RoutedEventArgs e)
{
ApDBContext sqlContext = new MSSQLDBContext();
ApDBContext pgContext = new PostGreSQLDBContext();
if (sqlContext.Genders.Count() == 0 && pgContext.Genders.Count() == 0)
{
List <Gender> genders = new List <Gender>()
{
new Gender {
Name = "Мужской"
}, new Gender {
Name = "Женский"
}
};
sqlContext.Genders.AddRange(genders);
sqlContext.SaveChanges();
pgContext.Genders.AddRange(genders);
pgContext.SaveChanges();
}
else
{
MessageBox.Show("Уже добавлены в бд");
}
}
private void BtPg_Click(object sender, RoutedEventArgs e)
{
ApDBContext pgContext = new PostGreSQLDBContext();
pgContext.Users.Add(NewUserGenerator());
pgContext.SaveChanges();
dgPostgreSql.ItemsSource = pgContext.Users.ToList();
}
private void BtPgSqlClear_Click(object sender, RoutedEventArgs e)
{
ApDBContext pgContext = new PostGreSQLDBContext();
pgContext.Users.RemoveRange(pgContext.Users);
pgContext.SaveChanges();
dgPostgreSql.ItemsSource = pgContext.Users.ToList();
}
private void MainWindow_Loaded(object sender, RoutedEventArgs e)
{
ApDBContext sqlContext = new MSSQLDBContext();
ApDBContext pgContext = new PostGreSQLDBContext();
dgSql.ItemsSource = sqlContext.Users.ToList();
dgPostgreSql.ItemsSource = pgContext.Users.ToList();
}
private void Btcompare_Click(object sender, RoutedEventArgs e)
{
ApDBContext sqlContext = new MSSQLDBContext();
ApDBContext pgContext = new PostGreSQLDBContext();
}