All --
Please help.
Is it possible to filter a TypedView in-memory?
I want to do something like this pseudo-code...
myPredExpression = 'build PredicateExpression
myFilterBucket = 'build RelationPredicateBucket with myPredExpression
Dim myITypedView As ORMSupportClasses.ITypedView2 = EntityAdapter.HelperFactory.GetTypedView(GetType(BusinessObjects.TypedViewClasses.SomeTypedView), myFilterBucket, allowDuplicates:=False)
'...blah, blah, blah...
myTypedView1 = DirectCast(myITypedView, BusinessObjects.TypedViewClasses.SomeTypedView)
'now I have ALL my data, hitting the database only 1x...
myTypedView2 = some portion of myTypedView1 fitered (where SomeKey=2)
myTypedView3 = some portion of myTypedView1 fitered (where SomeKey=3)
'...blah, blah, blah...
...and so on.
Bascially, I want to get all of my data from the database in one read and then filter out subsets of that data based on some key.
Is this possible?
If yes, then can you give a brief description of how to do it?
Please advise.
Thank you.
-- Mark Kamoski