public int GetRowCount(string table, params WhereClause[] whereClauses) { var sql = new SelectQueryBuilder(); sql.SelectColumn("*"); sql.SelectFromTable(table); whereClauses.ForEach(w => sql.AddWhere(w)); DataTable executeDataTable = SimpleDataAccess.ExecuteDataTable(cmd => { cmd.CommandType = CommandType.Text; cmd.CommandText = sql.BuildQuery(); }, Connection); return(executeDataTable.Rows.Count); }