Advertisement
Guest User

Untitled

a guest
Oct 23rd, 2014
124
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.99 KB | None | 0 0
  1.     UnionSubQuery usq = queryBuilder1.ActiveSubQuery.ActiveUnionSubquery;
  2.  
  3.     // get WHERE conditions from the usq.QueryColumnList
  4.     using (SQLExpressionItem whereCondition =
  5.         usq.QueryColumnList.GetConditionTree(new[] {ConditionType.Where}))
  6.     {
  7.         // append WHERE links (if any)
  8.         usq.FromClause.AddWhereJoinConditions(whereCondition);
  9.  
  10.         // format using custom formatter
  11.         using (SQLBuilder sqlBuilder = new SQLBuilderPiped(null))
  12.         {
  13.             // customize sqlBuilder
  14.             sqlBuilder.ParenthesizeANDGroups = true;
  15.             sqlBuilder.MainQueryFormat.WhereFormat.NewLineAfter = SQLBuilderConditionFormatNL.TopmostLogical;
  16.  
  17.             // build condition using sqlBuilder format settings
  18.             sqlBuilder.BeginBuild();
  19.             try
  20.             {
  21.                 whereCondition.BuildSQLCosmetic(sqlBuilder, sqlBuilder.MainQueryFormat, sqlBuilder.MainQueryFormat.WhereFormat, 0, false);
  22.             }
  23.             finally
  24.             {
  25.                 sqlBuilder.EndBuild();
  26.             }
  27.  
  28.             // get result
  29.             string whereString = sqlBuilder.Result;
  30.             MessageBox.Show(whereString);
  31.         }
  32.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement