Hi Otis!
I have three entities in my system. Actually, I have many entities, but I only want to speak about three of them right now!
They are Client, Credit, and Debit. For legal reasons I have to have physical separation of credits and debits into separate tables.
Anyway, I need to have the ability to figure the Client Account Balance for any given point in time, like so:
Client myClient = new ClientEntity(1);
DateTime monthEnd = new DateTime(9,30,2003); // Sep 30 2003
decimal balance = myClient.GetAccountBalance(monthEnd);
So balance should be equal to all of the credits with a transaction date of 9/30/2003 or earlier, less all debits with a transaction date of 9/30/2003 or earlier.
I think I need to use a TypedList for this. Am I right? I am going to get into the coding right now, but wanted to dash off a question so we could capture your best thinking in permanent form in this forum!
--Bruce