I'm trying to evaluate OpenAccess at the moment, although I can't seem
to get the reverse mapping to work correctly. (And the error message is
not very helpful)
The error is "Object reference not set to an instance of an object." and it shows up when I try to generate the reverse mapping, or when i just preview it in the advance view.
It appears on all the tables EXCEPT staff and tennant
Here is a link to a diagram of the database:
Can anyone help me out?
I've redone MANY of my primary keys
Re did all the... relations and everything
Now it is able to show previews of all tables, except CashSale and Banking, thou I still have no idea why this would change...
Bah... The reverse mapping wasn't picking up the foreign keys correctly.. (Don't know why?)
As I have multiple primary keys (multi-tenant data + child tables) and multiple foreign keys, OA wasn't picking up all the require columns (and had left some blank in the wizard).
*end final edit*
The only things of interest that I can think of is
-Some of the relations cascade, and there are triggers in place on the Staff_Tenant delete/update to allow for cascade deleteing. (I had to use triggers specifically to prevent a circular cascade error). The only other relation not cascading is staff-cashsale and staffsite-tenant (although when tenant is deleted, it should delete staff and site, thus deleteing staffsite, similarly with update)
-The trigger in tenant allows for multi row delete, but only single row update other wise I can't identify the individual rows being updated)
-tenantid is auto incremented (nothing else is auto incremented)
VS 2010 Pro
Telerik OpenAccess Q1 2010