By David on
Wednesday, August 31, 2011
I recently tried to implement a form that dynamically re-loaded data based on a parent item. When I re-queried the collection, I realised that the EntitySpaces collection was accumulating my WHERE statements (ie. Load records where Category=1, Category=2, etc.). There seemed to be no way to clear the WHERE part of the query.
Enter the ‘Query’ object! The function now works beautifully.
Old Syntax coll.Query.Where(coll.Query.EntityConnectionID.Equal(_entityConnectionID))...