Using Linq.Dynamic where method with a dynamic list gives error

Question

I am reading some JSON and converting it to a dynamic list. Below is My Code:

dynamic data = JObject.Parse(response);
var result = data.result;
var result = ((IEnumerable)arr).Cast<dynamic>().ToList();

var id = result[0].id;
var filtereddata = result.Where("id==1");

The line

var filtereddata = result.Where("id==1");

Gives error No property or field 'id' exists in type 'Object while var id = result[0].id; seems to be working.

The JSON I am parsing is :

{
"count": 1,
"result": [
{
  "id": 11,
  "name": "Locations",

}]
}

Please let me know if more information is needed. Thanks for your valuable time.

Edit: Even tried var filtereddata = result.Where(c=>c.id==1).Select("id"); using lambda expression but still the same issue.

I cannot use poco and exacts fields can vary. So have to use dynamic. If there is any solution other then Dynamic Linq I can check that as well — Anshuman Jasrotia
– Anshuman Jasrotia, Commented Oct 5, 2016 at 9:53
Actually I have the where condition as a string "id==1". So that is why I was using the Dynamic Linq — Anshuman Jasrotia
– Anshuman Jasrotia, Commented Oct 5, 2016 at 10:51

Ivan Stoev · Accepted Answer · 2016-10-05 12:06:08Z

3

Dynamic LINQ does not work with dynamic type. LINQ to Objects would work, but since you are receiving the filter as string, it's not applicable.

The workaround is to use temporary anonymous projection before applying the dynamic Where and then selecting back the original object:

var filtereddata = result
    .Select(x => new { item = x, id = (int)x.id, name = (string)x.name })
    .Where("id==1")
    .Select(x => x.item);

answered Oct 5, 2016 at 12:06

Ivan Stoev

208k17 gold badges356 silver badges376 bronze badges

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

2 Comments

Mrinal Kamboj Over a year ago

If anonymous projection to a well defined is feasible, then why create IEnumerable<dynamic> in first place, can directly create a schema post Json read

Ivan Stoev Over a year ago

@MrinalKamboj I have no idea why OP has chosen to parse into JObject which internally creates dynamic JArray / JObject / JProperty. The answer is just covering the concrete use case.

Collectives™ on Stack Overflow

Using Linq.Dynamic where method with a dynamic list gives error

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related