Filter anonymous object list by executing string clause in where condition

c# dynamic-linq linq

Question

DOTNETFIDDLE

I've created a list of anonymous objects like the one below.

List < Object > _dynamicObjectList = new List < Object > ();
for (int i = 0; i < 5; i++) {
    _dynamicObjectList.Add(new {
        ID = i, Name = "stu" + i, Address = "address234324" + i, DateField = DateTime.Now.AddDays(i)
    });
}

I must now build a string query. The string query I used is below.

string searchStr ="it.ID= 1 || it.ID= 2 || it.Name= "stu1" || it.Name= "stu2"";

I'm going to use the aforementioned string to filter my list in the last step.

var returnList= _dynamicObjectList.GetFilteredData(searchStr );

The following technique is used to run a dynamic object.

public static IQueryable GetFilteredData < T > (this IEnumerable < T > source, string searchCriteria) {

    if (!string.IsNullOrEmpty(searchCriteria)) {
        IList < T > returnList = new List < T > ();
        returnList = source.AsQueryable().Where(searchCriteria).ToList();
        return returnList.AsQueryable();
    } else {
        return source.AsQueryable();
    }

}

The system provides an error during execution.

No property or field 'ID' exists in type 'Object'

1
2
6/25/2015 5:33:40 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

<T> is Object when you're traveling in aList<Object> , and an Object lacks the attributes you're seeking for.

When your_dynamicObjectList the query may be successfully run if it is expressed as a list of those anonymous types, for example if you declare_dynamicObjectList as:

var _dynamicObjectList = new[] {
            new {ID = 0, Name = "stu" + 0, Address = "address234324" + 0, DateField = DateTime.Now.AddDays(0)},
            new {ID = 1, Name = "stu" + 1, Address = "address234324" + 1, DateField = DateTime.Now.AddDays(1)},
            new {ID = 2, Name = "stu" + 2, Address = "address234324" + 2, DateField = DateTime.Now.AddDays(2)},
            new {ID = 3, Name = "stu" + 3, Address = "address234324" + 3, DateField = DateTime.Now.AddDays(3)},
            new {ID = 4, Name = "stu" + 4, Address = "address234324" + 4, DateField = DateTime.Now.AddDays(4)},
        }.ToList();

Information: a list of anonymous classes in general

Your best option, in my opinion, would be to just construct a class to house your data instead of utilizing an anonymous type.

2
5/23/2017 10:26:43 AM

Related Questions

LINQ to Objects has a dynamic where clause.

Possibly not exactly addressing your issue, however DynamicQuery is not required in this situation. This question may be written as:...public IEnumerable<MyObject> GetMyObjects(int? maxCost, string name) { var query = context.MyObjects; if (maxCost != null) { query = query.Where(mo => mo.Cost <= (int)maxCost); } if (!str...
c# dynamic-linq linq linq-to-objects
asked by Aaronaught

How to filter a collection with a dynamically formed type using the LINQ where clause

In my Silverlight application, I must use a LINQ Where clause to filter the ObservableCollection....The procedure described in the following url is used to dynamically build the object type. ...http://mironabramson.com/blog/post/2008/06/Create-you-own-new-Type-and-use-it-on-run-time-(C).aspx...Is it feasible to use the Where clause to filter my col...
dynamic-linq linq linq-to-objects observablecollection silverlight-4.0
asked by HBA

Get an Entity Object with its child Entity with a condition (using Dynamic Linq)

This query is an extension of ...In a dynamic lambda expression, getting the Count() attribute.......I had inquired as to whether the Count() Method could be used in a dynamic lambda expression. Zzz-12-Zzz would work for me. Response given by xmojmr...But in order to retrieve results with its child object and filtered data, I recently had to use a ...
asp.net-mvc-4 c# dynamic-linq entity-framework-5 lambda
asked by dPatel1582

How to dynamically build and store complex linq queries against a list of hierarchical objects?

I have a list of items organized hierarchically. Based on "conditions" that a client firm specifies and is saved in the database, I want to create intricate LINQ searches on that object list. Because I will be running these periodically anytime the client's users update or refresh their data, I need to generate them at runtime, but I would want to ...
c# dynamic-linq linq linq-to-objects
asked by Jeff

using dynamic linq to filter a list of objects

I believe you are searching for what follows:...var codes=new List<string>{"Code1","Code2"}; // given a list of codes you want those rows that contains all codes var result= rows.Where(r=> codes.All(c=>r.Errors.Any(e=>e.Code==c))); ...I advise you to start the list in an empty constructor to prevent the error list from being checked for null value...
c# dynamic-linq linq
asked by octavioccl

How to use dynamic Linq with List<dynamic> object

I'm attempting to utilize dynamic Linq on a List of dynamic objects. Because I am unsure of the attributes that will be added to the object, I utilize dynamic objects. Linq works on my dynamic object, however I'd want to utilize dynamic Linq to search my list instead of using enormous hard-coded if statements. The first part of the piece of code ru...
.net c# dynamic-linq linq
asked by Brian S

how to filter with array/list via dynamic linq

I'm not sure if I fully understand what you're asking. Do you however mean anything similar? A lambda-expression may be used to resolve this....var listA = new[] {1, 2, 3, 5, 8}; var listB = new[] {1, 3, 5, 7, 11}; var res = listA.Where(itemA => listB.Contains(itemA)); // res = {1,3,5}
.net dynamic-linq
asked by CanereCurrere

String based Dynamic Linq - Nested Where clause

Do you want anything similar?...rolesCollection = rolesCollection.Where(x => assignedUsers.Any(t => t.TypId == x.TypId)).ToList();
c# dynamic-linq
asked by lucky

Create object containing a list using Dynamic Linq Core with Entity Framework 2.0

I'm enrolled in the next two classes:...public Part { public string PartNumber {get; set;} public string Description {get; set;} public List<Warehouse> Warehouses {get; set;} } public Warehouse { public string PartNumber {get; set;} public string WarehouseName {get; set;} public int Quantity {get; set;} public int Reord...
c# dynamic-linq entity-framework-core list
asked by jpico

Entity Framework Dynamic Where Clause from List<object>

Despite searching the internet extensively, I was unable to discover a working solution. By using dynamic linq, I want to let users create their own queries via windows forms. I created an object named WhereClause to contain each where clause....public class WhereClause { public int id { get; set; } public string ColumnName { get; set; } ...
c# dynamic-linq linq-to-sql
asked by LCaraway

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow