The ProvinceSQLManager class is a strongly typed manager class specifically for use with the Province table and Province Data Object.

using LJCNetCommon;

// Retrieve a Data Object.
internal Province RetrieveProvince(string connectionString, string providerName)
{
  Province retValue;

  var manager = new ProvinceSQLManager(null, null, connectionString
    , providerName);

  // Identify the records to be selected.
  var keyColumns = manager.GetIDKey(1);
  retValue = manager.Retrieve(keyColumns);
  return retValue;
}