Entity Framework Core – Contains Check Via Temp Tables

Motivation One of the main queries in my projects is to select multiple database records having a collection of some kind of identifiers. Most of the time it works very well using the method Contains(). List ids = …; var customers = dbContext.Customers.Where(c => ids.Contains(c.Id)); The query above is translated by the Entity Framework Core (EF …

Entity Framework Core – Contains Check Via Temp Tables Weiterlesen »