public virtual int CountSql(string table, Filter filter) { string sql = Dialect.GetCountSql(table); object obj; if (filter != null) { string whereSql = Dialect.GetWhereSql(filter, 0); object[] pars = filter.GetAllValueParameters(); In[] parameters = Dialect.ConvertToNamedParameters(0, pars); obj = Database.QueryScalar(sql + " " + whereSql, parameters); return(Convert.ToInt32(obj)); } obj = Database.QueryScalar(sql); return(Convert.ToInt32(obj)); }