Bug: IMartenQueryable doesn't work well with Projection. about marten HOT 4 CLOSED

@kacey90 Hey, you've really got to provide more detail about this for us to have any possible chance of addressing your issue. I can't even see what your queries were. And can you please paste in code and/or exception messages instead of screen shots next time? That would be much more helpful.

from marten.

@jeremydmiller Forgive me.

var results = await _querySession
    .Query<MemberKycVerificationStep>()
    .Where(x => x.MemberId == request.UserId)
    .Select(x => new MemberKycVerificationStepDto
    {
        KycVerificationStepId = x.KycVerificationStepId,
        Name = x.KycVerificationStep.Name,
        DateUpdated = x.DateUpdated,
        Status = x.Status,
        MemberId = x.MemberId
    })
    .ToPagedListAsync(request.PageIndex, request.PageSize, cancellationToken);
return await Result<IPagedList<MemberKycVerificationStepDto>>.SuccessAsync(results);

The above snippet returns Name of MemberKycVerificationStepDto as null as shown in the first screenshot.

    .Query<MemberKycVerificationStep>()
    .Where(x => x.MemberId == request.UserId)
    .AsEnumerable()
    .Select(x => new MemberKycVerificationStepDto
    {
        KycVerificationStepId = x.KycVerificationStepId,
        Name = x.KycVerificationStep.Name,
        DateUpdated = x.DateUpdated,
        Status = x.Status,
        MemberId = x.MemberId
    })
    .ToList();

This on the other hand, works for my requirement where the Name parameter of MemberKycVerificationStepDto gets the expected value as displayed in second screenshot.
I hope it's clear enough.

from marten.

@kacey90 I'm sorry, I really just don't have enough bandwidth to parse out exactly what it is you're trying to say isn't working. Can you do this through a failing test maybe?

At a guess, I'm not sure if Name = x.KycVerificationStep.Name, would work as a deeply nested member. I think so, but not sure. Might need a real reproduction to help with this. As a workaround, you can always call ToList() before Select() so that it's done in memory.

from marten.

And sorry, but trying to repro this, I get a "works on my box"

from marten.