public int GetRoleMemberCount(int roleId) { // TODO: implement actual select count from db // this is works but is not ideal int count = 0; using (DbDataReader reader = dbRoles.GetRoleMembers(roleId)) { while (reader.Read()) { count += 1; } } return(count); }