C# (CSharp) SqlPredicate.IsDistinct Examples

Example #1

 protected override void BuildIsDistinctPredicate(SqlPredicate.IsDistinct expr)
 {
     StringBuilder.Append("IIF(");
     BuildExpression(Precedence.Comparison, expr.Expr1);
     StringBuilder.Append(" = ");
     BuildExpression(Precedence.Comparison, expr.Expr2);
     StringBuilder.Append(" OR ");
     BuildExpression(Precedence.Comparison, expr.Expr1);
     StringBuilder.Append(" IS NULL AND ");
     BuildExpression(Precedence.Comparison, expr.Expr2);
     StringBuilder
     .Append(" IS NULL, 0, 1) = ")
     .Append(expr.IsNot ? '0' : '1');
 }

Example #2

 protected override void BuildIsDistinctPredicate(SqlPredicate.IsDistinct expr) => BuildIsDistinctPredicateFallback(expr);