Concurrency for inherited types

Posts   
 
    
wojt
User
Posts: 20
Joined: 27-Oct-2005
# Posted on: 21-Nov-2005 21:59:37   

Hi,

I am using a SQL Server timestamp field to perform part of the concurrency checks, and have a question about the best way to implement this for inherited entities.

Should both the super type and sub type have a timestamp column, and should I be checking both of them? Assume the super type entity is abstract (i.e. I only ever use the subtypes).

If I should be checking both of them, I suppose they will have to be named differently, since they will exist in both supertype and subtype?

Regards, Wojt.

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 22-Nov-2005 06:47:52   

in MHO it would be enough to maintain it in the super type only.