C# (CSharp) IExprSubQuery Examples

Example #1

File: PgSqlBuilder.cs Project: tralivali1234/SqExpress

 protected override bool ForceParenthesesForQueryExpressionPart(IExprSubQuery subQuery)
 {
     return(subQuery switch
     {
         ExprQuerySpecification specification => !ReferenceEquals(specification.Top, null),
         _ => true
     });

Example #2

 public static ExprExists WithSubQuery(this ExprExists original, IExprSubQuery newSubQuery)
 => new ExprExists(subQuery: newSubQuery);

Example #3

 public static ExprDerivedTableQuery WithQuery(this ExprDerivedTableQuery original, IExprSubQuery newQuery)
 => new ExprDerivedTableQuery(query: newQuery, alias: original.Alias, columns: original.Columns);

Example #4

 public ExprQueryExpression(IExprSubQuery left, IExprSubQuery right, ExprQueryExpressionType queryExpressionType)
 {
     this.Left  = left;
     this.Right = right;
     this.QueryExpressionType = queryExpressionType;
 }

Example #5

 public static ExprSelect AddOrderBy(this IExprSubQuery original, ExprOrderByItem orderBy, params ExprOrderByItem[] rest)
 => new ExprSelect(original, new ExprOrderBy(Helpers.Combine(orderBy, rest)));

Example #6

File: ExprIn.cs Project: tralivali1234/SqExpress

 public ExprInSubQuery(ExprValue testExpression, IExprSubQuery subQuery) : base(testExpression)
 {
     this.SubQuery = subQuery;
 }

Example #7

File: SqlBuilderBase.cs Project: 0x1000000/SqExpress

 protected abstract bool ForceParenthesesForQueryExpressionPart(IExprSubQuery subQuery);

Example #8

 public static ExprSelect WithSelectQuery(this ExprSelect original, IExprSubQuery newSelectQuery)
 => new ExprSelect(selectQuery: newSelectQuery, orderBy: original.OrderBy);

Example #9

File: ExprExists.cs Project: tralivali1234/SqExpress

 public ExprExists(IExprSubQuery subQuery)
 {
     this.SubQuery = subQuery;
 }

Example #10

 public ExprDerivedTableQuery(IExprSubQuery query, ExprTableAlias alias, IReadOnlyList <ExprColumnName>?columns) : base(alias)
 {
     this.Query   = query;
     this.Columns = columns;
 }

Example #11

File: ExprSelectOffsetFetch.cs Project: tralivali1234/SqExpress

 public ExprSelectOffsetFetch(IExprSubQuery selectQuery, ExprOrderByOffsetFetch orderBy)
 {
     this.SelectQuery = selectQuery;
     this.OrderBy     = orderBy;
 }

Example #12

File: ExprSelect.cs Project: tralivali1234/SqExpress

 public ExprSelect(IExprSubQuery selectQuery, ExprOrderBy orderBy)
 {
     this.SelectQuery = selectQuery;
     this.OrderBy     = orderBy;
 }

Example #13

 public static ExprSelect AddOrderBy(this IExprSubQuery original, ExprOrderBy orderBy)
 {
     orderBy.OrderList.AssertNotEmpty("Order item list cannot be empty");
     return(new ExprSelect(original, orderBy));
 }

Example #14

 public static ExprInSubQuery WithSubQuery(this ExprInSubQuery original, IExprSubQuery newSubQuery)
 => new ExprInSubQuery(testExpression: original.TestExpression, subQuery: newSubQuery);

Example #15

File: SqQueryBuilderExtensions.cs Project: tralivali1234/SqExpress

 public static ExprDerivedTableQuery As(this IExprSubQuery expressionBuilder, ExprTableAlias tableAlias)
 => new ExprDerivedTableQuery(expressionBuilder, tableAlias, null);

Example #16

 public static ExprQueryExpression WithRight(this ExprQueryExpression original, IExprSubQuery newRight)
 => new ExprQueryExpression(left: original.Left, right: newRight, queryExpressionType: original.QueryExpressionType);

Example #17

File: TSqlBuilder.cs Project: tralivali1234/SqExpress

 protected override bool ForceParenthesesForQueryExpressionPart(IExprSubQuery subQuery)
 {
     return(false);
 }

Example #18

 public static ExprSelectOffsetFetch WithSelectQuery(this ExprSelectOffsetFetch original, IExprSubQuery newSelectQuery)
 => new ExprSelectOffsetFetch(selectQuery: newSelectQuery, orderBy: original.OrderBy);

Example #19

 public static ExprSelect AddOrderBy(this IExprSubQuery original, IReadOnlyList <ExprOrderByItem> orderItems)
 => new ExprSelect(original, new ExprOrderBy(orderItems.AssertNotEmpty("Order item list cannot be empty")));