C# (CSharp) YesSql.Core.Sql SqlBuilder.GetSelectorの例

GetSelector() public method

public GetSelector ( ) : string
return	string

コード例 #1

ファイル: ISqlDialect.cs プロジェクト: ikvm/yessql

 public override void Page(SqlBuilder sqlBuilder, int offset, int limit)
 {
     if (offset == 0 && limit != 0)
     {
         // Insert LIMIT clause after the select
         var selector = sqlBuilder.GetSelector();
         selector = " TOP " + limit + " " + selector;
         sqlBuilder.Selector(selector);
     }
     else if (offset != 0 || limit != 0)
     {
         sqlBuilder.Trail = "OFFSET " + offset + " ROWS FETCH FIRST " + limit + " ROWS ONLY";
     }
 }

コード例 #2

ファイル: ISqlDialect.cs プロジェクト: sebastienros/yessql

 public override void Page(SqlBuilder sqlBuilder, int offset, int limit)
 {
     if (offset == 0 && limit != 0)
     {
         // Insert LIMIT clause after the select
         var selector = sqlBuilder.GetSelector();
         selector = " TOP " + limit + " " + selector;
         sqlBuilder.Selector(selector);
     }
     else if (offset != 0 || limit != 0)
     {
         sqlBuilder.Trail = "OFFSET " + offset + " ROWS FETCH FIRST " + limit + " ROWS ONLY";
     }
 }