public ParametrizedSql Build()
{
var sql = new StringBuilder();
sql.AppendFormat(Skip, $"@{SkipQueryParam}");
_parameters.Add(SkipQueryParam, _request.Skip);
sql.AppendFormat(Take, $"@{TakeQueryParam}");
_parameters.Add(TakeQueryParam, _request.Take);
return(ParametrizedSql.Create(sql.ToString(), _parameters));
}
public ParametrizedSql Build()
{
var sql = new StringBuilder();
if (_request.Filter == null || !_request.Filter.HasFilters() || !AtLeastOneFilterIsValid(_request.Filter))
{
return(ParametrizedSql.CreateEmpty());
}
sql.Append(" WHERE");
sql.Append("(");
sql.Append(AddFilter(_request.Filter));
sql.Append(")");
return(ParametrizedSql.Create(sql.ToString(), _parameters));
}