public virtual string GetBaseSelectCommandText(TableFilter filter, bool excludeWhere)
{
var select = new StringBuilder();
select.Append("SELECT ");
if (filter != null || filter.IsColumnFiltered)
{
filter.WriteColumnsProjection(select);
}
else
{
select.Append('*');
}
select.Append(" FROM ");
select.Append(QuotedName);
if (filter != null && filter.IsRowFiltered && !excludeWhere)
{
select.Append(" WHERE ");
filter.WriteWhereStatement(select);
}
return(select.ToString());
}
public virtual int GetRowCount(TableFilter filter)
{
var count = -1;
using (var command = Database.CreateCommand()) {
var sql = new StringBuilder();
sql.Append("SELECT COUNT(*) FROM ");
sql.Append(QuotedName);
if (filter != null && filter.IsRowFiltered)
{
sql.Append(" WHERE ");
filter.WriteWhereStatement(sql);
}
command.CommandText = sql.ToString();
using (Database.CreateConnectionScope()) {
count = Convert.ToInt32(command.ExecuteScalar());
}
}
return(count);
}