Is AsExpandable still necessary on EF Core?

[brunosantosrhsenso]

When trying to convert a Core 2.2 web app (EF 2.2) to Core 3 (EF 3.0), AsExpandable was throwing an exception "Could not load file System.Interactive.Async". I then removed AsExpandable and the query (using predicatebuilder) seemed to work just fine. I did the same with the Core 2.2 version, and it also seemed to have worked properly. So now I'm wondering if I'm missing some feature by removing AsExpandable or if it's just not necessary anymore.

[StefH]

Can you maybe create a example project to demonstrate this?

[joshmouch]

I get this, too when I reference LinqKit.Microsoft.EntityFrameworkCore. I tried switching to LinqKit.Core, for for the hell of it, and then I started getting this error, instead:

The provider for the source IQueryable doesn't implement IAsyncQueryProvider. Only providers that implement IAsyncQueryProvider can be used for Entity Framework asynchronous operations.

[206mph]

I am running into the same problem with AsExpandable after converting to Net Core 3. As brunosantosrhsenso mentioned, removing AsExpandable works but want to make sure that's correct.

[StefH]

If you want to use async. Then you need the LinqKit version which references EF or EFCore.

See the table on main page from this project.

Using Expandable on net core 3 : I have to check...

[joshmouch]

@StefH
You still do need to use it in at least one case that I've found. So I had to use LinqKit.Core and then not use Async at all as a work-around.

[StefH]

@joshmouch and @206mph and @brunosantosrhsenso
New preview is uploaded on MyGet https://www.myget.org/F/linqkit/api/v3/index.json

--> LinqKit 1.1.17-preview-02 which works with EFCore 3.

Please test.

[mariusAF]

Preview works - Thanks @StefH

[StefH]

LinqKit 1.1.17-preview-04 is also uploaded to NuGet;
Please test.

[Armarr]

Can confirm that preview 04 also works

[StefH]

#103

[Pao-lino]

@StefH
Excuse me, I'm on EF Core 5 and installed the LinqKit.Microsoft.EntityFrameworkCore package.
I'm using PredicateBuilder without AsExpandable and it's working.
It's not clear to me if AsExpandable is necessary or not.

[CesarD]

@StefH Excuse me, I'm on EF Core 5 and installed the LinqKit.Microsoft.EntityFrameworkCore package. I'm using PredicateBuilder without AsExpandable and it's working. It's not clear to me if AsExpandable is necessary or not.

Same for me. Doesn't seem to be needed anymore... Is it?

[ElectroBuddha]

I can also confirm that PredicateBuilder is working without .AsExpandable() in EntityFramework Core 7.

[n0099]

I can also confirm that PredicateBuilder is working without .AsExpandable() in EntityFramework Core 8.