private static void ExportCustomerFromMSSqlToMySQL()
{
var mssqlClients = new GenericRepository<Customer>(new GirlsAgencyContext());
var girlsMySql = new GenericRepository<Girl>(new GirlAgencyMySql.Data.MySql());
var mysqlClients = new GenericRepository<Customer>(new GirlAgencyMySql.Data.MySql());
foreach (var mssqlCustomer in mssqlClients.GetAll().ToList())
{
var customer = new Customer()
{
CityId = mssqlCustomer.CityId,
CountryId = mssqlCustomer.CountryId,
FirstName = mssqlCustomer.FirstName,
LastName = mssqlCustomer.LastName,
Girls = GetGirls(mssqlCustomer, girlsMySql)
};
mysqlClients.Add(customer);
}
mysqlClients.SaveChanges();
}
private static ICollection<Girl> GetGirls(Customer mssqlCustomer, GenericRepository<Girl> girlsMySql)
{
var girls = new List<Girl>();
foreach (var girl in mssqlCustomer.Girls)
{
var girlInDb = girlsMySql
.GetAll()
.Where(n => n.FirstName == girl.FirstName && n.LastName == girl.LastName)
.FirstOrDefault();
girls.Add(girlInDb);
}
return girls;
}
private static IEnumerable GetCustomer(object[,] array)
{
var customerArray = new List<Customer>();
for (var row = 2; row <= array.GetLength(0); row++)
{
var girl = new Customer
{
FirstName = array[row, 1].ToString(),
LastName = array[row, 2].ToString(),
CityId = Convert.ToInt32(array[row, 3]),
CountryId = Convert.ToInt32(array[row, 4])
};
customerArray.Add(girl);
}
return customerArray;
}