private static void ExportGirlsFromMSSqlToMySql(GenericRepository<Girl> sqlGirlsRepo, GenericRepository<Girl> mySqlGirlsRepo) { var girlsFromMSsql = sqlGirlsRepo.GetAll().ToList(); foreach (var girlFromMSsql in girlsFromMSsql.ToList()) { var girl = new Girl() { FirstName = girlFromMSsql.FirstName, LastName = girlFromMSsql.LastName, Age = girlFromMSsql.Age, BreastSizeId = girlFromMSsql.BreastSizeId, HairColorId = girlFromMSsql.HairColorId, CityId = girlFromMSsql.CityId, PricePerHour = girlFromMSsql.PricePerHour, Features = girlFromMSsql.Features, CountyId = girlFromMSsql.CountyId, // City = girlFromMSsql.City, // Country = girlFromMSsql.Country }; mySqlGirlsRepo.Add(girl); mySqlGirlsRepo.SaveChanges(); } }
private static IEnumerable GetGirls(object[,] array) { var girlsArray = new List<Girl>(); for (var row = 2; row <= array.GetLength(0); row++) { var girl = new Girl { FirstName = array[row, 1].ToString(), LastName = array[row, 2].ToString(), Age = Convert.ToInt32(array[row, 3]), BreastSizeId = GetBreastSizeType(array[row, 4].ToString()), HairColorId = GetHairColorType(array[row, 5].ToString()), CityId = 1, CountyId = 1, PricePerHour = Convert.ToInt32(array[row, 8]) }; girlsArray.Add(girl); } return girlsArray; }