private static void ExportToMysql()
{
var mysql = new GirlAgencyMySql.Data.MySql();
//mysql.Database.ExecuteSqlCommand("TURNCATE TABLE['Girls']");
var sqlGirlsRepo = new GenericRepository <Girl>(new GirlsAgencyContext());
var sqlCountriesRepo = new GenericRepository <Country>(new GirlsAgencyContext());
var sqlCitiesRepo = new GenericRepository <City>(new GirlsAgencyContext());
var sqlClientsRepo = new GenericRepository <Customer>(new GirlsAgencyContext());
var sqlOrdersRepo = new GenericRepository <Order>(new GirlsAgencyContext());
var mySqlGirlsRepo = new GenericRepository <Girl>(new GirlAgencyMySql.Data.MySql());
var mySqlCountriesRepo = new GenericRepository <Country>(new GirlAgencyMySql.Data.MySql());
var mySqlCitiesRepo = new GenericRepository <City>(new GirlAgencyMySql.Data.MySql());
var mySqlClientsRepo = new GenericRepository <Customer>(new GirlAgencyMySql.Data.MySql());
var mysSqlOrdersRepo = new GenericRepository <Order>(new GirlAgencyMySql.Data.MySql());
//sqlCountriesRepo.GetAll().
// ToList().ForEach(
// (n => mySqlCountriesRepo.Add(n)));
//sqlCitiesRepo.GetAll().ForEachAsync(n => mySqlCitiesRepo.Add(n));
//sqlGirlsRepo.GetAll().ForEachAsync(n => mySqlGirlsRepo.Add(n));
//sqlClientsRepo.GetAll().ForEachAsync(n => mySqlClientsRepo.Add(n));
//sqlOrdersRepo.GetAll().ForEachAsync(n => mysSqlOrdersRepo.Add(n));
// mySqlCitiesRepo.GetAll().ForEachAsync(n=> Console.WriteLine(n.Name));
ExportCountriesFromMSSqlToMySql(sqlCountriesRepo, mySqlCountriesRepo);
ExportGirlsFromMSSqlToMySql();
ExportCitiesFromMSSqlToMySQL(sqlCitiesRepo, mySqlCitiesRepo);
ExportCustomerFromMSSqlToMySQL();
ExportOrdersFromMSSqlToMySql(sqlOrdersRepo, mysSqlOrdersRepo);
//ExportGirlsFromMSSqlToMySql(sqlGirlsRepo, mySqlGirlsRepo);
}
private static void ExportToMysql()
{
var mysql = new GirlAgencyMySql.Data.MySql();
//mysql.Database.ExecuteSqlCommand("TURNCATE TABLE['Girls']");
var sqlGirlsRepo = new GenericRepository<Girl>(new GirlsAgencyContext());
var sqlCountriesRepo = new GenericRepository<Country>(new GirlsAgencyContext());
var sqlCitiesRepo = new GenericRepository<City>(new GirlsAgencyContext());
var sqlClientsRepo = new GenericRepository<Customer>(new GirlsAgencyContext());
var sqlOrdersRepo = new GenericRepository<Order>(new GirlsAgencyContext());
var mySqlGirlsRepo = new GenericRepository<Girl>(new GirlAgencyMySql.Data.MySql());
var mySqlCountriesRepo = new GenericRepository<Country>(new GirlAgencyMySql.Data.MySql());
var mySqlCitiesRepo = new GenericRepository<City>(new GirlAgencyMySql.Data.MySql());
var mySqlClientsRepo = new GenericRepository<Customer>(new GirlAgencyMySql.Data.MySql());
var mysSqlOrdersRepo = new GenericRepository<Order>(new GirlAgencyMySql.Data.MySql());
//sqlCountriesRepo.GetAll().
// ToList().ForEach(
// (n => mySqlCountriesRepo.Add(n)));
//sqlCitiesRepo.GetAll().ForEachAsync(n => mySqlCitiesRepo.Add(n));
//sqlGirlsRepo.GetAll().ForEachAsync(n => mySqlGirlsRepo.Add(n));
//sqlClientsRepo.GetAll().ForEachAsync(n => mySqlClientsRepo.Add(n));
//sqlOrdersRepo.GetAll().ForEachAsync(n => mysSqlOrdersRepo.Add(n));
// mySqlCitiesRepo.GetAll().ForEachAsync(n=> Console.WriteLine(n.Name));
ExportCountriesFromMSSqlToMySql(sqlCountriesRepo, mySqlCountriesRepo);
ExportGirlsFromMSSqlToMySql();
ExportCitiesFromMSSqlToMySQL(sqlCitiesRepo, mySqlCitiesRepo);
ExportCustomerFromMSSqlToMySQL();
ExportOrdersFromMSSqlToMySql(sqlOrdersRepo, mysSqlOrdersRepo);
//ExportGirlsFromMSSqlToMySql(sqlGirlsRepo, mySqlGirlsRepo);
}