DevForce Community Forum : A column that should not be persisted http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : A column that should not be persisted Wed, 10 Jun 2026 06:07:45 -700 Wed, 28 Jul 2010 17:51:20 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2019 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ A column that should not be persisted : Originally posted by davidklitzkeA... http://www.ideablade.com/forum/forum_posts.asp?TID=2019&PID=7898#7898 Author: agrogers
Subject: 2019
Posted: 28-Jul-2010 at 5:51pm

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
]]> Wed, 28 Jul 2010 17:51:20 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2019&PID=7898#7898 A column that should not be persisted : Originally posted by smi-markWhy... http://www.ideablade.com/forum/forum_posts.asp?TID=2019&PID=7891#7891 Author: agrogers
Subject: 2019
Posted: 28-Jul-2010 at 5:09pm

Originally posted by smi-mark

Why does it have to be a database column? Simply add a property to your object.

public string Tag
{
    get;
    set;
}

I think this is the best way for us to move forward on this one.   Will see how it goes.  Thanks.
]]> Wed, 28 Jul 2010 17:09:55 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2019&PID=7891#7891 A column that should not be persisted : A SourceAccessType of ReadOnly... http://www.ideablade.com/forum/forum_posts.asp?TID=2019&PID=7882#7882 Author: davidklitzke
Subject: 2019
Posted: 28-Jul-2010 at 4:05pm

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.

]]> Wed, 28 Jul 2010 16:05:18 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2019&PID=7882#7882 A column that should not be persisted : Why does it have to be a database... http://www.ideablade.com/forum/forum_posts.asp?TID=2019&PID=7870#7870 Author: smi-mark
Subject: 2019
Posted: 28-Jul-2010 at 2:13pm

Why does it have to be a database column? Simply add a property to your object.

public string Tag
{
    get;
    set;
}
]]> Wed, 28 Jul 2010 14:13:19 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2019&PID=7870#7870 A column that should not be persisted : HiWe have been looking at the... http://www.ideablade.com/forum/forum_posts.asp?TID=2019&PID=7844#7844 Author: agrogers
Subject: 2019
Posted: 27-Jul-2010 at 10:56pm

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
]]> Tue, 27 Jul 2010 22:56:10 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2019&PID=7844#7844