A column that should not be persisted

Hi

We have been looking at the 'Source Access Type' (pg 74) property.  We have a 'Tag' field in many tables which we use to track selected records.  I understand the SourceAccessType property will stop modified fields from being written back to the database.  This is exactly what we need.

However, the documentation does not state that changing this property leaves dirty state of the record unchanged.  We dont want to write back records to the DB that have simply had their Tag property changed.  I would guess that it would not since we are not writing the property back.  But I just wanted to confirm that.

Thanks
Andrew

A  SourceAccessType of ReadOnly will stop DevForce from writing that property to the database on an insert or update.  The record is still considered modified though, so when PM.SaveChanges() is called the entity will be part of the save list.  If that’s not wanted then these entities can be stripped out of the list passed to SaveChanges, or they can be removed from the list via the PM.Saving event.

Originally posted by davidklitzke A  SourceAccessType of ReadOnly will stop DevForce from writing that property to the database on an insert or update.  The record is still considered modified though, ...

Thanks for clarifying this David.  I am not sure that the extra work to exclude those records that are not dirty is worth our while at present.  Will need to investigate it further. 

Our scenario means that the Tag property of 1000s of records could be touched (and touched often) with none of those records every actually being modified.  With SourceAccessType of the Tag column set to readonly we would be writing back to the DB 1000s of identical records ... not really what we want to do.

Is there a reason that a change to a column that is never persisted stills triggers a persist to the DB?  That doesnt seem right to me.

Thanks
Andrew