Smit Patel

@ralmsdeveloper - Yes, there can be methods like `WithNoLock` & `WithLock` but it would be in SqlServer provider. Same way Postgre can add more. Unless we identify hints which are...

If we are thinking to add into EF.Functions then we should wait for customer feedback. Those would be currently supported by UDFs already.

As exception message indicates that query contains result of type `IQueryable` which is not allowed in final result. The first 2 scenario you mentioned, first one does convert it to...

By default EF Core will try to translate every query it can. So there is no documentation for everything which is translated. The only error is when materializing IQueryable as...

LINQ is an infinite problem space. Unlimited numbers of queries can be written by combing various different LINQ operators hence it makes impossible for us to define exactly what is...

@Dreamescaper - That is not invocation in pure expression tree terms since there is not Invoke method. EF Core has allowed client eval in top level projection since very first...

Th history of `Compile().Invoke()` structure. When you put Compile...Invoke inside a lambda expression in an expression tree world, it is never compiled, rather the Compile method call is introduced in...

Looking at code for Invocation simplification, we don't do anything for Compile in our code base, it may be still client evaluated as @roji pointed out and I would be...

@syndicatedshannon - What specific value Compile/Invoke provide rather than using it in lambda directly as I posted in my comment above? You are still passing the lambda from your business...

Also consider #27480