Smit Patel

~Same issue exist for Any. (kind for All also)~ Any ends up working because the stale projection isn't getting expanded where above error occurs. None of this works if it...

Under the hood, EF6 expanded into following only ```C# var searchTerms = query.Replace(" ", "").Split(" "); var searchResult = await context.Items .Where(x => EF.Functions.Like(x.Title, $"%{searchTerms[0]}%") || EF.Functions.Like(x.Title, $"%{searchTerms[1]}%")) .ToListAsync(); ```...

> EFC 2.2 Did client evaluation. You can opt-in client evaluation yourself if that is what you want.

@xperiandri - It does evaluation on client to produce correct results.

This may not work. Need to use CompileAsyncSingletonQuery. Need a different API design for CompileQuery.

new Exception ``` System.InvalidOperationException : Processing of the LINQ expression 'FirstOrDefaultAsync( source: Select( source: OrderBy( source: Where( source: DbSet, predicate: (c) => c.CustomerID == (Unhandled parameter: __customerID)), keySelector: (c) =>...

Dependent on #14551

Workaround. & pass cancellationToken when invoking the query. ``` private static readonly Func PreCompiledQuery = EF.CompileAsyncQuery((MyDbContextcontext, Query request, CancellationToken cancellationToken) => context .MyEntities .Where(m => m.One == request.One && m.Two...

@prashantaggarwal1990 - Your query is not using EF.CompileQuery. Please stop spamming unrelated issues.

@divega - This issue suggest that for OrdinalIgnoreCase we could apply Lower on both sides, but that would mean index cannot be used (as pointed out by @akamud ), but...