关于[Avoiding SQL Server plan cache pollution with EF Core 3 and Enumerable.Contains()]的摘要:
One of the many advantages of using a tool like Entity Framework Core is, that you are sure that the framework will generate properly parameterized SQL for you. This helps avoid SQL injection issues and avoids plan cache pollution. Unfortunately, EF Core currently falls short on that promise, when translating queries, where you supply a list of values to be matched against a column - Enumerable.Contains method - this is translated to a SQL Server IN operator
原文地址: https://erikej.github.io/efcore/sqlserver/2020/03/30/ef-core-cache-pollution.html