public List<dbCountry> getActiveCountries()
{
var parameters = new[] { new OleDbParameter(dbCountry._ACTIVE_FLAG, TRUE) };
List<dbCountry> list =
CreateList<dbCountry>(
BuildSqlSelect(dbCountry._TABLE_NAME, new String[] { ALL }, new String[] { dbCountry._ACTIVE_FLAG }),
parameters);
foreach (dbCountry country in list)
{
country.States = getCountryStates(country.countryCode);
}
return list;
}