Fluent nhibernate problem, query

Question

I'd really appreciate some help with a problem I have.

Class L holds a collection of R and R holds a collection of Q. Each instance of R can be exists in multiple instances of L and each instance of Q can exist in several instances of R.

Everything is working fine except I have a function I can not figure out how to write.

I've a function that receives an instance/ object of R and Q. So with R and Q I'd like to query over L and find out where R is used. I would also like to find out if and where Q is used.

Thanks for information and help!

Firo · Accepted Answer · 2011-10-21 08:54:29Z

1

Revised: fixed misstyping

R myR = ...;
Q myQ = ...;

var LsWithMyRandFlagIfQisUSed = session.QueryOver<L>()
    .JoinQueryOver(l => l.Rs)
    .Where(r => r.Id == myR.Id)
    .List<L>()
    .Select(l => new
    {
        L = l,
        QisUsed = l.Rs.Any(r => r.Qs.Contains(myQ)),
    });

Edit: added linq syntax havent testet

R myR = ...;
Q myQ = ...;

var LsWithMyRandFlagIfQisUSed =
    from l in session.Query<L>()
    where l.Rs.Contains(myR)
    select new 
    {
        L = l,
        QisUsed = l.Rs.Any(r => r.Qs.Contains(myQ)),
    });

edited Oct 21, 2011 at 8:54

answered Aug 29, 2011 at 7:43

Firo

30.8k4 gold badges57 silver badges97 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Johan Over a year ago

It seams I forgot to answer here. Thanks for the attempt but I could not get that to work properly.

Firo Over a year ago

whats the problem? Maybe i can fix it

Firo Over a year ago

ah i see, i tried it with an example and rewrote it for your Names and had mistake

Johan Over a year ago

Ah thanks, gonna try it out. I'm new to queryover and have not yet had the time to fully understand it's syntax and perks with the stressed time schedule I've been under. I find it somewhat tricky.. to bad they just could not override linq / lambda..

Firo Over a year ago

they have also. just using NHibernate.Linq and you can use from l in Session.Query<L>() where ...

Collectives™ on Stack Overflow

Fluent nhibernate problem, query

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related