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