linq syntax: What is the type that this returns? How can I now go ahead and use firstRow.ingredientName etc?

by

First, I think your code will not compile, you’re missing two parentheses:

return (from c in db.RecipeIngredients
   join d in db.Ingredients on c.IngredientID equals d.IngredientsID
   where c.RecipeID.Equals(recipeID)
   select (d.IngredientsID,c.Unit,c.IngredientID,c.Amount)).ToList();

Ok, next, (d.IngredientsID,c.Unit,c.IngredientID,c.Amount) if you’re on C# 7.0 that’s a declarative tuple with all the variables, so you need to return that types between parentheses, like here (I will assume the types of your vars, correct it as needed):

public List<(int, UnitNames, int, double)> GetRecipe(int recipeId)
{
    return (from c in db.RecipeIngredients
       join d in db.Ingredients on c.IngredientID equals d.IngredientsID
       where c.RecipeID.Equals(recipeID)
       select (d.IngredientsID,c.Unit,c.IngredientID,c.Amount)).ToList();

}

To access the variables you acces like this:

var recipe = GetRecipe(recipeId);

foreach(var ingredient in recipe)
{
    var ingredientsId = ingredient.Item1;
    var unit = ingredient.Item2;
    var ingredientId = ingredient.Item3;
    var amount = ingredient.Item4;
}

In any case, I would recommend to create a class to pass the data, it will result in a much clear code:

public class Ingredient
{
    public int IngredientsId { get; set; }
    public UnitNames Unit { get; set; }
    public int IngredientId { get; set; }
    public double Amount { get; set; }
}

public List<Ingredient> GetRecipe(int recipeId)
{
    return (from c in db.RecipeIngredients
       join d in db.Ingredients on c.IngredientID equals d.IngredientsID
       where c.RecipeID.Equals(recipeID)
       select new Ingredient { 
                                 IngredientsId = d.IngredientsID, 
                                 Unit = c.Unit,
                                 IngredientId = c.IngredientID, 
                                 Amount = c.Amount 
                             }).ToList();

}

More Related Contents:

  1. linq query as datagrid source
  2. LINQ to read XML
  3. Flatten List in LINQ
  4. Linq-to-Entities Join vs GroupJoin
  5. LINQ with groupby and count
  6. Quickest way to compare two generic lists for differences
  7. Convert string[] to int[] in one line of code using LINQ
  8. LINQ – Left Join, Group By, and Count
  9. When should I dispose of a data context
  10. How do I use LINQ Contains(string[]) instead of Contains(string)
  11. Func with out parameter
  12. LINQ Ring: Any() vs Contains() for Huge Collections
  13. Writing Recursive CTE using Entity Framework Fluent syntax or Inline syntax
  14. Linq to EntityFramework DateTime
  15. LINQ to SQL multiple tables left outer join
  16. how to check if object already exists in a list
  17. How to “zip” or “rotate” a variable number of lists?
  18. LINQ Inner-Join vs Left-Join
  19. Cast LINQ result to ObservableCollection
  20. Get table-data from table-name in LINQ DataContext
  21. Is it Linq or Lambda?
  22. Can I LINQ a JSON?
  23. Local variable and expression trees
  24. List complex sorting
  25. Good way to get the key of the highest value of a Dictionary in C#
  26. How to sort a dictionary by key
  27. LINQ performance Count vs Where and Count
  28. Linq access property by variable
  29. LINQ Query to Convert string to datetime
  30. Convert DataTable to Generic List in C#

Leave a Comment