Did you try the QueryOver WhereRestrictionOn() method? It's not LINQ, but it's very very similar and has all kinds of functionality it has has and some more also.
try something like: var query = session.QueryOver<ThirdParty>().WhereRestrictionOn(t => t.Assignment).In(....) *Mohamed Meligy *Readify | Senior Developer M:+61 451 835006 | W: www.readify.net [image: Description: Description: Description: Description: rss_16] [image: Description: Description: Description: Description: cid:[email protected]] <http://www.linkedin.com/in/meligy> [image: Description: Description: Description: Description: cid:[email protected]] <http://twitter.com/meligy> <http://www.greatplacetowork.com.au/best/best-companies-australia.php><http://www.readify.net/AboutUs/NewsItem.aspx?id=10> On Wed, Dec 8, 2010 at 8:56 PM, Kakone <[email protected]> wrote: > I tried this : > > from tp in Session.Query<ThirdParty>() > select new ThirdParty > { > FirstName = tp.FirstName, > LastName = tp.LastName, > Assignments = (from tpa in Session.Query<ThirdPartyAssignment>() > where (tpa.ThirdParty == tp.ThirdParty && tpa.EndDate == null) > select tpa) > } > > but it doesn't work... > > In fact, I think it would be nice if we could do this (but it doesn't > work either) : > (from tp in Session.Query<ThirdParty>()).FetchMany(tp => > tp.Assignments).Where(tpa => tpa.EndDate == null) > > On 8 déc, 09:51, Kakone <[email protected]> wrote: > > Thanks for this answer but it's not what I wanted to obtain. > > > > If I do this : > > > > var query = from thirdParty in Session.Query<ThirdParty>() where > > Assignments.Any(assignment => assignment .EndDate == null ) > > select thirdParty; > > > > The Assignments collection will be filled entirely. In some cases, I > > would like that the Assignments collection contain only the assignment > > where EndDate == null. It's not necessary to get all the records of > > the child collection because I want only the last assignment. I don't > > know how I can do this in LINQ. > > > > On 8 déc, 00:52, Mohamed Meligy <[email protected]> wrote: > > > > > > > > > > > > > > > > > Did you try: > > > > > var query = from thirdParty in Session.Query<ThirdParty>() where > > > Assignments.Any(assignment => assignment .EndDate == null ) > > > select thirdParty; > > > > > Depends on whether NHibernate LINQ provider supports Any() like this. > Not > > > sure about it. > > > > > Check also the QueryOver API. Feels a lot like LINQ (when called using > > > methods not LINQ syntax). They have WhereRestrictionOn() method, you > may use > > > it to add IN restriction on the Assignments (passing it different > > > QueryOver<Assignment>() query, again, not sure if that will work also). > > > > > One other way is to do JOIN and only select ThirdParty, then put the > query > > > in brackets and add DISTINCT like (from ... select ...).Distinct() > > > > > *Mohamed Meligy > > > *Readify | Senior Developer > > > > > M:+61 451 835006 | W:www.readify.net > > > [image: Description: Description: Description: Description: rss_16] > [image: > > > Description: Description: Description: Description: > > > cid:[email protected]] > > > <http://www.linkedin.com/in/meligy> [image: > > > Description: Description: Description: Description: > > > cid:[email protected]] <http://twitter.com/meligy> > > > <http://www.greatplacetowork.com.au/best/best-companies-australia.php > ><http://www.readify.net/AboutUs/NewsItem.aspx?id=10> > > > > > On Wed, Dec 8, 2010 at 3:11 AM, Kakone <[email protected]> wrote: > > > > Hello, > > > > > > I try to find a way to filter children collection in LINQ. I know I > > > > can enable a filter on the session, but the filter string is native > > > > SQL, I don't want to use this. > > > > With Criteria, I think I can use a result transformer > > > > (Transformers.AliasToEntityMap) to achieve this, but is there a way > to > > > > do this with the new LINQ provider ? > > > > > > For example, I've got two classes : > > > > > > public class ThirdParty : Entity > > > > { > > > > public virtual string FirstName { get; set; } > > > > public virtual string LastName { get; set; } > > > > > > public virtual ThirdParty CurrentParent > > > > { > > > > get > > > > { > > > > var thirdPartyAssignment = > > > > Assignments.FirstOrDefault(tpa => tpa.EndDate == null); > > > > return thirdPartyAssignment == null ? null : > > > > thirdPartyAssignment.ThirdParty; > > > > } > > > > } > > > > > > public virtual IEnumerable<ThirdPartyAssignment> Assignments > > > > { get; set; } > > > > } > > > > > > public class ThirdPartyAssignment : Entity > > > > { > > > > public virtual ThirdParty ThirdParty { get; set; } > > > > public virtual ThirdParty Parent { get; set; } > > > > public virtual DateTime? EndDate { get; set; } > > > > } > > > > > > Sometimes, I want all the ThirdParties with all the Assignments (in > > > > this case, session.Query<ThirdParty>() works well). Other times, I > > > > want the ThirdParties with only the Assignments where EndDate is > null. > > > > I didn't succeed to do this with the LINQ provider. > > > > > > Cordially, > > > > Kakone. > > > > > > -- > > > > 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]<nhusers%[email protected]> > <nhusers%[email protected]<nhusers%[email protected]>> > > > > . > > > > For more options, visit this group at > > > >http://groups.google.com/group/nhusers?hl=en.-Masquer le texte des > messages précédents - > > > > > - Afficher le texte des messages précédents - > > -- > 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]<nhusers%[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.
