Erik Ejlskov Jensen ErikEJ
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <runtime> | |
| <gcServer enabled="true" /> | |
| <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1"> | |
| <dependentAssembly> | |
| <assemblyIdentity name="System.Data.SqlServerCe" publicKeyToken="89845dcd8080cc91" culture="neutral" /> | |
| <bindingRedirect oldVersion="4.0.0.0-4.0.0.1" newVersion="4.0.0.1" /> | |
| </dependentAssembly> | |
| </assemblyBinding> | |
| </runtime> |
ErikEJ
/ IQueryableExtensions.cs
Last active
June 14, 2024 19:25
Replacement for EF Core .Contains, that avoids SQL Server plan cache pollution
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| using System.Linq.Expressions; | |
| namespace Microsoft.EntityFrameworkCore | |
| { | |
| public static class IQueryableExtensions | |
| { | |
| public static IQueryable<TQuery> In<TKey, TQuery>( | |
| this IQueryable<TQuery> queryable, | |
| IEnumerable<TKey> values, | |
| Expression<Func<TQuery, TKey>> keySelector) |