![]() Var employeeSubordinatesReportCte = employeeSubordinatesReport Any IQueryable can be converted to CTE with the extension method AsCte("optional_name"). Reusing the same SQL part in complex queryĬTE in LINQ To DB also implements IQueryable.See documentation for Transact SQL: WITH common_table_expression When CTEs are useful Common Table Expression (CTE) support introduced for supporting advanced SQL techniques in LINQ To DB.
0 Comments
Leave a Reply. |