error including related entity #3825

fguo created 6 years ago

I am running a similar service as PhoneBook example:

    public ListResultDto&lt;PersonListDto&gt; GetPeople(GetPeopleInput input)
    {
        var people = _personRepository
            .GetAll().Include(p => p.Phones)

//.Include(p => p.Phones.Where(x=>x.Number=="1112242")) .WhereIf( !input.Filter.IsNullOrEmpty(), p => p.Name.Contains(input.Filter) || p.Surname.Contains(input.Filter) || p.EmailAddress.Contains(input.Filter) ) .OrderBy(p => p.Name) .ThenBy(p => p.Surname) .ToList();

        return new ListResultDto&lt;PersonListDto&gt;(ObjectMapper.Map&lt;List&lt;PersonListDto&gt;>(people));
    }

It works fine. Now, I need a condition in the "include" method, so I replaced the above ".Include(p => p.Phones)" with ".Include(p => p.Phones.Where(x=>x.Number=="1112242"))". I got a run-time error:

The property expression 'p => {from Phones x in [p].Phones where ([x].Number=="112242") select [x]}' is not valid. The expression should represent a property access: 't => t.MyProperty'. For more information on including related data, see <a class="postlink" href="http://go.microsoft.com/fwlink/?LinkID=746393">http://go.microsoft.com/fwlink/?LinkID=746393</a>.

I visited Microsoft link as mentioned in the message, but still no clue.

Can you advise me how to add a condition (or other such as .Distinct(), .First()...) in the .Include method?

Thanks,

error including related entity #3825

2 Answer(s)