Filter anonymous object list by executing string clause in where condition

c# dynamic-linq linq

Question

DOTNETFIDDLE

I have create a anonymous object list like 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)
    });
}

Now I need to create string query. My string query is given below..

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

In the last step I am going to filter my list with the above string...

var returnList= _dynamicObjectList.GetFilteredData(searchStr );

The method which executes Dynamic object is given below...

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();
    }

}

During execution system provide an error

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 because you're passing in a List<Object>, and an Object doesn't have the properties on it you're looking for.

If your _dynamicObjectList is declared as a list of those anonymous types then the query can be executed fine, 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();

More info: A generic list of anonymous class

I think your best bet, if possible, would be to avoid using an anonymous type and just create a class to hold your data.

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

Related Questions

LINQ to Objects has a dynamic where clause.

Maybe not directly answering your question, but DynamicQuery is unnecessary here. You can write this query 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 (!string.IsNullOrEmpty(nam...
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

I need to filter the ObservableCollection using LINQ Where clause in my Silverlight application....The object type is dynamically created using method provided in following url. ...http://mironabramson.com/blog/post/2008/06/Create-you-own-new-Type-and-use-it-on-run-time-(C).aspx...Is filtering my collection using Where clause for specific property ...
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 question is continuation of ...Getting Count() property in Dynamic Lambda Expression...I had asked if we can put Count() Method in dynamic lambda expression. I could do it using ...Dynamic Expression API.... Answer provided by - xmojmr...But recently I had to implement a Dynamic Lambda Expression to get result with its child entity with filter...
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 objects in a hierarchical structure. I want to build complex LINQ queries against that object list based on "conditions" a client company sets and are stored in the database. So I need to build these at run time, but because they will be run repeatedly whenever the client's users update or refresh their data I would like to store t...
c# dynamic-linq linq linq-to-objects
asked by Jeff

using dynamic linq to filter a list of objects

I think this is what you are looking for:...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))); ...To avoid the null checking of the error list, I suggest you initialize the list in an empty constructor:...public Row(...
c# dynamic-linq linq
asked by octavioccl

How to use dynamic Linq with List<dynamic> object

I have a List of dynamic objects that I am trying to use dynamic Linq on. I am using dynamic objects because I do not know the properties that will be coming into the object. Linq works on my dynamic object, but, to avoid giant hard coding if statements, I would like to use dynamic Linq to search my list. The top half of the code snippet works but ...
.net c# dynamic-linq linq
asked by Brian S

how to filter with array/list via dynamic linq

Not quite sure if I understand your question right. But do you mean something like this? This is solved with a Lambda-Expression....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 something like that;...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 have the following 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 ReorderPo...
c# dynamic-linq entity-framework-core list
asked by jpico

Entity Framework Dynamic Where Clause from List<object>

After scourging the internet I have not been able to find a solution that i can get to work. I am attempting to use dynamic linq to enable the user to build a custom query from a windows form. To hold each where clause I have built an object called WhereClause:...public class WhereClause { public int id { get; set; } public string ColumnNam...
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