Entity Framework Core - Knowledge Base (KB)

LinqKit and async in Entity Framework

I am getting the following error when using the predicate builder with Entity Framework Core....The source IQueryable doesn't implement IAsyncEnumerable. Only sources that implement IAsyncEnumerable can be used for Entity Framework asynchronous operat...

Generic Query With PredicateBuilder in Linqkit

I've been using ...LinqKit... to create generic queries for quite some time....One thing that has always bothered me is the fact that you always have to test whether the value sent in the filter is valid....For example: Suppose I have a string filter. Con...

Use LinqKit PredicateBuilder for related model (EF Core)

I want to use LinqKit's PredicateBuilder and pass the predicate into ....Any... method for related model....So I want to build a predicate:...var castCondition = PredicateBuilder.New<CastInfo>(true); if (movies != null && movies.Length > 0) { castCon...

Load related data with EF Core 3.1

I'm not sure if I'm doing something wrong or if this is a bug in EF Core 3.1 but the following works with EF 6.x and is part of a Generic Repository which I'm converting to EF Core 3.1:... IQueryable<TEntity> query = this.Context.Set<TEntity>(); if (f...

Conditionally ignore fields with LINQ select

I've been unable to find any examples where you can conditionally exclude fields based off a variable within a select projection in LINQ, see also ...LINQ: Select an object and change some properties without creating a new object.......Let me give some ba...