I often have requirements where NULL values need to be saved to the database if the data legitimately...

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))...

 



...

 

EntitySpaces generates a number of .NET classes that are used to interact with your database. ...

EntitySpaces is a popular ORM tool used to generate ‘plumbing’ classes against a number of database servers. ...