Dynamic Linq in Entity Framework Core

Question

I need to create a Linq query having Where and Select both dynamic.I am searching something like below code which will work in .net core.

var result = myQuery
.Where("Field1=\"SomeValue\" && Field2=\"SomeValue\"")
.Select("new (Field1, Field2, Field3)");

I tried above one by adding System.Linq.Dynamic for .net core but both Where and Select is not supporting dynamic string values.Is there any way to achieve this ?

Dynamic LINQ is definitely the right solution. Please add more details on what is not working. — NetMage
– NetMage, Commented May 4, 2022 at 19:12

marc_s · Accepted Answer · 2022-08-19 20:22:42Z

2

Make sure to use NuGet : System.Linq.Dynamic.Core.
And make sure you include the correct namespace:
```
using System.Linq.Dynamic.Core;
```
And make sure your myQuery is an IQueryable<T>

With this it should be able to use your code like:

edited Aug 19, 2022 at 20:22

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered May 5, 2022 at 17:01

Stef Heyenrath

9,97014 gold badges73 silver badges132 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user3501613 Over a year ago

I was using System.Linq.Dynamic instead of System.Linq.Dynamic.Core that was the issue, thanks for the help

Collectives™ on Stack Overflow

Dynamic Linq in Entity Framework Core

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related