Write where condition inside Include in linq query

Question

The below query is returning error:

The property expression is not valid. The expression should represent a property access: 't => t.MyProperty'.

var list = this.DataContext
    .GetDbSet<Table1>()
    .Include(t => t.Table2.Where(i=>i.Active == true))
    .Include("Table2.Table3")
    .ToListAsync();

How can achieve the above query?

Does this answer your question? [Linq Query with a Where clause in an Include statement](https://stackoverflow.com/questions/33528223/linq-query-with-a-where-clause-in-an-include-statement) — Raymond Reddington, Jan 23 '20 at 07:14
@ZavenZareyan I have tried using "any" but it returns all the data — difi brasad, Jan 23 '20 at 07:25

Asherguru · Accepted Answer · 2020-01-23T07:28:48.577

4

Filter cannot work in include. You need to download Z.EntityFramework.Plus.EFCore from nuget. And use code below

var list = this.DataContext
.GetDbSet<Table1>()
.IncludeFilter(t => t.Table2.Where(i=>i.Active == true))
.ThenInclude(x => x.Table3)
.ToListAsync();

Alternative one

var list = this.DataContext
.GetDbSet<Table1>()
.Include(t => t.Table2)
.ThenInclude(x => x.Table3)
.ToListAsync();
list.Table2 = list.Table2.Where(x => x.Active == true);

edited Jan 23 '20 at 07:28

answered Jan 23 '20 at 07:14

Asherguru

1,687
1
5
10

Is there any alternative to achieve the above – difi brasad Jan 23 '20 at 07:25
@chinni I added alternative one without adding Z.EntityFramework.Plus.EFCore. Edited post – Asherguru Jan 23 '20 at 07:27
need with in that query itself. – difi brasad Jan 24 '20 at 01:42
Impossible. Filter cannot work in include linq. Only way is to use Z.EntityFramework.Plus.EFCore. That's all. – Asherguru Jan 24 '20 at 02:02
My pleasure. @Chinni – Asherguru Jan 24 '20 at 03:32

Write where condition inside Include in linq query

1 Answers1