how to use Linq NHibernate Query Subitems?Ask Questions

 Posted on 07/31/2018

I need to get some informations, but I am new in NHibernate

I have classes like:

Person
   Id
   IdAddress
   Address

Address
   Id
   CityId
   City
   IdNeighborhood
   Neighborhood

and classes

City
Neighborhood

I need all address with a neighboorhood id, This code is where I search the information, but here only get the city:

using(var session = openSession()){
   var q = session.Query<Person>(a => Id == IdSearch)
           .Fetch(a => a.Address)
           .ThenFetch(a => a.City)
           .ToList();
   session.Clear();
}

How could I also get neighboorhood information?

 

 

Share On: facebook gplus twitter
profile
Asked by hardik chaudhary on 07/31/2018 Score: 553 points
Add Comment:

Comments

1 Answers

1 Corrected Answers
Aproved Answers
0
Profile
Answered by ketan Linbachiya on 8/2/2018 8:52:21 AM Score: 269 points

I find the answer, In the query, need to be in this way:

using(var session = openSession()){
    var q = session.Query<Person>(a => Id == IdSearch)
       .Fetch(a => a.Address)
       .ThenFetch(a => a.City)
       .Fetch(a => a.Address)//search address again to have access to neighboorhoor
       .ThenFetch(a => a.Neighborhood)
       .ToList();
    session.Clear();
}

Comments

Add Comment:

Post Your Answers

Existing Members

Sign in to your account
Email Address
Password
New Member?
Sign up and complete profile
Full Name
Email Address
I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the StoodQ newsletters
Guideline to answer a question:

Useful tips to submit your answer
Please read below guidelines before you submit your answer for question.

  • Read and understand question for which you are submitting your answer.
  • Try to avoid grammatical and spell mistake while answering.
  • Do not post any irrelevant information in your answer.
  • Explain your answer with example or any reference link to help who posted question.
  • If you find irrelevant question, please report it to support. Click here to contact support.
  • You agree to the privacy policy and terms of use to submit any contents.

Note: StoodQ is online developers community which helps developer for their difficulty, lets help them with your value contribution.