How does LINQ translate to SQL? What limitations are there?

• EF Core translates LINQ queries into SQL using expression trees.
• Only supported LINQ operators and expressions can be translated.
• Limitations:
• Certain C# methods or complex expressions cannot be translated and

cause runtime exceptions.

• Client-side evaluation may occur, which can hurt performance.
• Use .AsEnumerable() to switch to client-side processing intentionally.