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));
}
public bool TableExists(string table)
{
string sql = Dialect.GetTableExistsSql(table);
return(Convert.ToInt32(Database.QueryScalar(sql)) > 0);
}
