[Solved] What does LINQ query .Where() do?
“Find the items from the model’s property “MenuItems” that has a category name equal to category.name” It is like a filter on the list MenuItems 5 solved What does LINQ query .Where() do?
entity-framework-core
[Solved] EF SQL query Performance on comma-separated string Ids
If you store Ids as comma separated string – you always have TABLE/INDEX scan. If your table is small it can be enough. With SecondaryTable table which stores Ids associated with main table there a lot of other plans: You can leave as is and trust or not DB Engine optimiser query = query.Where(x => … Read more