**
  
I am a newbie on the nhibernate linq. In my code I am creating a session 
object to query an nhiberate class. I need to join this class with another 
table and need to apply the where and select columns parmeters. Here is 
what I am doing:

 IQueryable<MOVIES_DB> query =
                session.QueryOver<MOVIE_DB>()
                .OrderBy(mov => mov.name).Asc
                .Inner.JoinQueryOver<actors>

I am not sure how to complete it. I need do the following

   - join the movies and actors tables, which have the key relationship, 
   actor_id 
   - from the join tables, need to select columns, mov.id, mov.name, 
   actors.name, actors.birthdate 
   - need to apply the where , which gives me back all the records where 
   mov.id == "999"

any help is appreciated. 

-- 
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To view this discussion on the web visit 
https://groups.google.com/d/msg/nhusers/-/UPA2HdLdYdcJ.
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