EntityFramework Core – Composite key filtering
In EF Core, you can easily filter to a list of known values using LINQ: int[] ids = { 1, 3, 7 }; myContext.Posts.Where(s => ids.Contains(s.Id)); But what if the list of values includes composite keys, like Type and Name? var filterBy = new[] { (PostTypes.Blog, "First"), (PostTypes.KnowledgeBase, "Last") }; myContext.Posts.Where(s => filterBy.Contains((s.Type, s.Name))); // But how? There’s no direct Contains() support for tuples or composite keys in EF Core. A Stack Overflow post outlines several options. Here, I’ll focus on Option 6 — building an expression tree to generate a SQL query like: ...