public void SaveFoodTable()
{
log.InfoFormat("[SaveFoodTable].");
try
{
using (Restaurants restaurantsDb = new Restaurants())
{
MongoEntityRepositoryBase<Ingredient> basicData =
new MongoEntityRepositoryBase<Ingredient>(restaurantsDb.DB);
using (usda_nutritionEntities context = new usda_nutritionEntities())
{
var food_groups = context.FD_GROUP.ToList();
var weigts = context.WEIGHT.ToList();
var foods = context.FOOD_DES.ToList();
foreach (var item in foods)
{
Spontaneous.DataModel.Ingredient ingredient = FoodDesToIngredient(item, food_groups);
if(ingredient != null) basicData.Add(ingredient);
}
Console.Write("After Food copy loop.\n");
}
}
}
catch (Exception e)
{
log.ErrorFormat("[SaveFoodTable] Exception={0}.", e);
}
}