This isn't a problem specific to DevForce, but I'm hoping DevForce provides a better answer than EF.
I have a database where we are doing "soft deletes". So instead of a row being deleted, and IsDeleted flag is set to true. That way foreign key lookups still work, reporting on historical data still works, etc.
The problem comes when I try to look up related data, especially binding.
For example, let's say I have a book table and an author table. If hava reference to an author, I can bind to BookList.Count and see how many books are out there. Butr if one of the entries was a mistake, and has been marked as IsDeleted, how do I get the count straight? I know I can do another linq query, but can anyone figure out a better way? Would it be better to add properties on each partial class (ie UndeletedBooks on Author? Is there something EnttyListManager could add?
I know how to btrute force this, I'm jsut hoping there's a more elegant solution.