Class ExpressionToSqlCompiler
Compiles C# Expression to SQL WHERE condition for PVT.
Supports:
Arithmetic: +, -, *, /, %
Comparisons: >, <, >=, <=, ==, !=
Logic: &&, ||, !
Math functions: Abs, Round, Floor, Ceiling
Strings: Contains, StartsWith, EndsWith
IMPORTANT: DateTime → DateTimeOffset UTC via DateTimeConverter!
public class ExpressionToSqlCompilerInheritance
Methods
Compile<TProps>(Expression<Func<TProps, bool>>)
Compiles Expression to SQL condition with parameters
public (string SqlCondition, List<object> Parameters) Compile<TProps>(Expression<Func<TProps, bool>> expression)ExtractFieldNames<TProps>(Expression<Func<TProps, bool>>)
Extracts field names used in Expression
public HashSet<string> ExtractFieldNames<TProps>(Expression<Func<TProps, bool>> expression)