Lets say i have :
Dim myMatch = From combo In (From _set In DataSpreadsResults Select _set)
Where combo.Value > 0
now If I read myMatch lets say it returns results like:
4, 500 (like a dimensional array)
my question is....
lets say I have another dimensional array that as the same indexes (1 and 4) but different values in it
how can I write another LINQ so in the where clause I could do something like :
Dim mySum = From combo In (From _set In DataSpreads Select _set)
Where combo.Index "INSIDE" (myMatch.Indexes)
do you understand what I mean ?
i kind of SQL Where IN ( 1,2,3,4)
in addition to all that.. I need the Sum of the results... I dont think I can do select combo.sum()