.Net 2.0
SQL Server 2005
LLBLGenPro 2.5 Final (November 5th 2007)
SelfServicing
Windows Forms Project
I have an entity collection which is generated on a form load. Every few seconds I need to check that no changes have occured on the database which would effect this collection.
Is there a quick way of comparing a collection back to the database, essentially an 'IsDirty' but from the database side rather than the collection itself.
My current thinking is that I just recreate another instance of the same collection and compare the two for changes, but I am hoping there is a quicker/more efficient way of achieving this.
The code I use to generate the collection is simply:
Dim triggers As New KeyDatesCollection
Dim triggersFilter As New PredicateExpression(KeyDatesFields.OurRef = strOurRef)
triggersFilter.AddWithAnd(New FieldLikePredicate(KeyDatesFields.Event, "Portal Trigger:%"))
triggers.GetMulti(triggersFilter)
If I do have to compare 2 collections is there a 'best practice' way of achieving this?
Thanks
Charlie