Linq Order By Contains List

Question

I have a List of ints that model.SelectedIngredients and in this example the list contains the values [15128, 4593,15046,]. I use this list then as a filter in my Linq query as follows:

List<INGREDIENT> selectedIngredients = db.INGREDIENT.Where(i => model.SelectedIngredients.Contains(i.IngredientId)).ToList();

However, this sorts the results by IngredientId ascending as default[4593,15046,15128].

What I would like is to get the selectedIngredients back in the same order as they are in model.SelectedIngredients.

I know I could do it in a for loop but I just wondered if there was a way I could do it within the Linq query?

Thanks

Answer 1

You can acomplish this quite easy by using the index of your list with ids.

List<INGREDIENT> selectedIngredients = db.INGREDIENT
                         .Where(i => model.SelectedIngredients.Contains(i.IngredientId))
                         .AsEnumerable()
                         .OrderBy(i => model.SelectedIngredients.IndexOf(i.IngredientId))
                         .ToList();