本文整理汇总了C#中SelectQuery.Validate方法的典型用法代码示例。如果您正苦于以下问题：C# SelectQuery.Validate方法的具体用法？C# SelectQuery.Validate怎么用？C# SelectQuery.Validate使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类SelectQuery的用法示例。
在下文中一共展示了SelectQuery.Validate方法的3个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: RenderSelect
private string RenderSelect(SelectQuery query, bool forRowCount, int offset, int limitRows)
{
query.Validate();
StringBuilder selectBuilder = new StringBuilder();
//Start the select statement
Select(selectBuilder, query.Distinct);
//Render select columns
if (forRowCount)
{
SelectColumn(selectBuilder, new SelectColumn("*", null, "cnt", SqlAggregationFunction.Count));
}
else
{
SelectColumns(selectBuilder, query.Columns);
}
FromClause(selectBuilder, query.FromClause, query.TableSpace);
Where(selectBuilder, query.WherePhrase);
WhereClause(selectBuilder, query.WherePhrase);
OrderBy(selectBuilder, query.OrderByTerms);
OrderByTerms(selectBuilder, query.OrderByTerms);
if (limitRows > -1)
{
selectBuilder.AppendFormat(" limit {0}, {1}", offset, limitRows);
}
return selectBuilder.ToString();
}示例2: RenderSelect
private string RenderSelect(SelectQuery query, bool renderOrderBy)
{
query.Validate();
StringBuilder selectBuilder = new StringBuilder();
//Start the select statement
Select(selectBuilder, query.Distinct);
//Render Top clause
if (query.Top > -1)
{
selectBuilder.AppendFormat("top {0} ", query.Top);
}
//Render select columns
SelectColumns(selectBuilder, query.Columns);
FromClause(selectBuilder, query.FromClause, query.TableSpace);
Where(selectBuilder, query.WherePhrase);
WhereClause(selectBuilder, query.WherePhrase);
if (renderOrderBy)
{
OrderBy(selectBuilder, query.OrderByTerms);
OrderByTerms(selectBuilder, query.OrderByTerms);
}
return selectBuilder.ToString();
}示例3: RenderSelect
private string RenderSelect(SelectQuery query, int limitRows)
{
query.Validate();
StringBuilder selectBuilder = new StringBuilder();
//Start the select statement
Select(selectBuilder, query.Distinct);
//Render select columns
SelectColumns(selectBuilder, query.Columns);
FromClause(selectBuilder, query.FromClause, query.TableSpace);
WhereClause fullWhereClause = new WhereClause(WhereClauseRelationship.And);
fullWhereClause.SubClauses.Add(query.WherePhrase);
if (limitRows > -1)
{
fullWhereClause.Terms.Add(WhereTerm.CreateCompare(SqlExpression.PseudoField("rownum"), SqlExpression.Number(limitRows), CompareOperator.LessOrEqual));
}
Where(selectBuilder, fullWhereClause);
WhereClause(selectBuilder, fullWhereClause);
OrderBy(selectBuilder, query.OrderByTerms);
OrderByTerms(selectBuilder, query.OrderByTerms);
return selectBuilder.ToString();
}