I don't know which is the exact logic but at least you can do something like
from User u where u.Name in (:nameList) and u.Age in (:ageList)

--
Fabio Maulo


El 22/03/2011, a las 12:34, kor <[email protected]> escribió:

> hi all, i have this entity/table
>
> User
> {
>    long Id,
>    string Name,
>    int Age
> }
>
>
> i have a list of couple name-age to search for but i don't know how to
> do it.
>
> this is the bad way to get the result that i want
>
> //note names.length == ages.length
> public IList<User> GetAllByNameAndAge(string[] names, int[] ages)
> {
>      IList<User> allUsers = NhSession.CreateQuery("from
> User").List<User>();
>      IList<User> filteredUser = new List<User>();
>      foreach(User u in allUsers)
>      {
>          for (int i = 0; i < names.length; i++)
>          {
>              if (names[i] == u.Name && ages[i] == u.Age)
>              {
>                  filteredUsers.Add(user);
>              }
>          }
>      }
>      return filteredUsers;
> }
>
> i need to do a hql query (or criteria or sql, no linq becouse it's a
> 2.0 project) that will do it on the db side.
> sorry if it's a stupid question but i'm not good with sql/hql query
> and i haven't idea of how to do it.
>
> thanks
>
>
>
> --
> 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.
>

-- 
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