I've been using the NorthWinds db to get acquainted with the AtomsFramework. I can read and insert new objects(records) fine, but am having trouble updating objects. So far I'm just using the Customers table.
I've modified it to include an oid, changed the pk from customerID to OID, and put a unique constraint on CustomerID...
If it would help to troubleshoot I will provide the mapping and modified table schema...
Thanks,
Rich C.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
A copy of the XML mappings and the table schema you are using would be great.
Do you get a particular error message appearing? In debug you should also be able to see the SQL that is generated for the update. You can always have a look at that and see if there is an obvious problem.
Given that the inserts work it may be an issue with the checking of the created/modified dates (part of the optimistic locking).
I'll wait for your reply.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I've been using the NorthWinds db to get acquainted with the AtomsFramework. I can read and insert new objects(records) fine, but am having trouble updating objects. So far I'm just using the Customers table.
I've modified it to include an oid, changed the pk from customerID to OID, and put a unique constraint on CustomerID...
If it would help to troubleshoot I will provide the mapping and modified table schema...
Thanks,
Rich C.
A copy of the XML mappings and the table schema you are using would be great.
Do you get a particular error message appearing? In debug you should also be able to see the SQL that is generated for the update. You can always have a look at that and see if there is an obvious problem.
Given that the inserts work it may be an issue with the checking of the created/modified dates (part of the optimistic locking).
I'll wait for your reply.