public void Import(IEnumerable <RecipeMetadata> data)
{
using (var transaction = session.BeginTransaction())
{
var d = data.ToArray();
foreach (var row in d)
{
var dbRow = new Models.RecipeMetadata
{
RecipeMetadataId = row.RecipeMetadataId,
Recipe = Models.Recipes.FromId(row.RecipeId),
PhotoRes = row.PhotoRes,
Commonality = row.Commonality,
UsdaMatch = row.UsdaMatch,
MealBreakfast = row.MealBreakfast,
MealLunch = row.MealLunch,
MealDinner = row.MealDinner,
MealDessert = row.MealDessert,
DietNomeat = row.DietNomeat,
DietGlutenFree = row.DietGlutenFree,
DietNoRedMeat = row.DietNoRedMeat,
DietNoAnimals = row.DietNoAnimals,
DietNoPork = row.DietNoPork,
NutritionTotalfat = row.NutritionTotalfat,
NutritionTotalSodium = row.NutritionTotalSodium,
NutritionLowSodium = row.NutritionLowSodium,
NutritionLowSugar = row.NutritionLowSugar,
NutritionLowCalorie = row.NutritionLowCalorie,
NutritionTotalSugar = row.NutritionTotalSugar,
NutritionTotalCalories = row.NutritionTotalCalories,
NutritionLowFat = row.NutritionLowFat,
NutritionLowCarb = row.NutritionLowCarb,
NutritionTotalCarbs = row.NutritionTotalCarbs,
SkillQuick = row.SkillQuick,
SkillEasy = row.SkillEasy,
SkillCommon = row.SkillCommon,
TasteMildToSpicy = row.TasteMildToSpicy,
TasteSavoryToSweet = row.TasteSavoryToSweet
};
session.Save(dbRow, row.RecipeMetadataId);
}
Log.DebugFormat("Created {0} row(s) in RecipeMetadata", d.Count());
transaction.Commit();
session.Flush();
}
}
public void Import(IEnumerable<RecipeMetadata> data)
{
using (var transaction = this.session.BeginTransaction())
{
var recipeMetadataArray = data.ToArray();
foreach (var recipeMetadata in recipeMetadataArray)
{
var databaseRecipeMetadata = new Models.RecipeMetadata
{
RecipeMetadataId =
recipeMetadata.RecipeMetadataId,
Recipe =
Models.Recipes.FromId(
recipeMetadata.RecipeId),
PhotoRes = recipeMetadata.PhotoRes,
Commonality = recipeMetadata.Commonality,
UsdaMatch = recipeMetadata.UsdaMatch,
MealBreakfast = recipeMetadata.MealBreakfast,
MealLunch = recipeMetadata.MealLunch,
MealDinner = recipeMetadata.MealDinner,
MealDessert = recipeMetadata.MealDessert,
DietNomeat = recipeMetadata.DietNomeat,
DietGlutenFree = recipeMetadata.DietGlutenFree,
DietNoRedMeat = recipeMetadata.DietNoRedMeat,
DietNoAnimals = recipeMetadata.DietNoAnimals,
DietNoPork = recipeMetadata.DietNoPork,
NutritionTotalfat =
recipeMetadata.NutritionTotalfat,
NutritionTotalSodium =
recipeMetadata.NutritionTotalSodium,
NutritionLowSodium =
recipeMetadata.NutritionLowSodium,
NutritionLowSugar =
recipeMetadata.NutritionLowSugar,
NutritionLowCalorie =
recipeMetadata.NutritionLowCalorie,
NutritionTotalSugar =
recipeMetadata.NutritionTotalSugar,
NutritionTotalCalories =
recipeMetadata.NutritionTotalCalories,
NutritionLowFat =
recipeMetadata.NutritionLowFat,
NutritionLowCarb =
recipeMetadata.NutritionLowCarb,
NutritionTotalCarbs =
recipeMetadata.NutritionTotalCarbs,
SkillQuick = recipeMetadata.SkillQuick,
SkillEasy = recipeMetadata.SkillEasy,
SkillCommon = recipeMetadata.SkillCommon,
TasteMildToSpicy =
recipeMetadata.TasteMildToSpicy,
TasteSavoryToSweet =
recipeMetadata.TasteSavoryToSweet
};
this.session.Save(databaseRecipeMetadata, recipeMetadata.RecipeMetadataId);
}
this.Log.DebugFormat("Created {0} row(s) in RecipeMetadata", recipeMetadataArray.Count());
transaction.Commit();
this.session.Flush();
}
}
