When creating a Custom Fill Method does the Data Retrieval order have to match the Business Object Definition order or will the BO auto map the fields to the properties based on the column names?

Thanks for your help.

Richard

OK, you can remove the @reseller field from the update command.  The business object will only attempt to update fields that are part of the mapped table (those contained in the AllFieldsList).  Since your business object was mapped to Customers, it does not think that @reseller should be supplied because it doesn't think it's part of the updating table.  So, whatever the structure of the data table inside the business object, it's only going to update the fields that are part of the mapped table on SQL Server.