it doesn't works, i need to works "on the same index"

i mean that with this 2 array

ages = [1 ,3, 5]
names = ["name0", "name1", "name2"]

i need to get a query that works as

from User u
where (u.Name = "name0" and u.Age = 1)
or (u.Name = "name1" and u.Age = 3)
or ...

at the moment i'm building this query at runtime with criteria but
maybe there's a more efficient way to do that, for example if i can
use a unique query i can
recycle the execution plane, reduce the query size (i must do this
check 2 times on 2 different table with an array size of about 500
items).
if it's not possible i will continue to use criteria

-- 
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en.

Reply via email to