private static List <Supplier> LoadSupplierListFromDataReader(OleDbDataReader reader) { var suppliers = new List <Supplier>(); while (reader.Read()) { var supplier = new Supplier(); supplier.Id = reader.GetInt32(reader.GetOrdinal("VerdelerID")); supplier.Name = reader.GetStringSafe(reader.GetOrdinal("Naam")); supplier.MinimumDeliveryDays = reader.GetNullableInt16(reader.GetOrdinal("WS_min_delivery_days")); supplier.MaximumDeliveryDays = reader.GetNullableInt16(reader.GetOrdinal("WS_max_delivery_days")); supplier.CreatedDttm = reader.GetNullableDateTime(reader.GetOrdinal("CreateDttm")); supplier.UpdatedDttm = reader.GetNullableDateTime(reader.GetOrdinal("UpdateDttm")); supplier.DeletedDttm = reader.GetNullableDateTime(reader.GetOrdinal("DeleteDttm")); suppliers.Add(supplier); } return(suppliers); }