No applicable aggregate method 'OrderByDescending' exists'

dynamically create lambdas expressions + linq + OrderByDescending

I'm not sure where exactly did you need dynamic lambda expressions. Anyways, the best way to generate lambda expressions dynamically is by using expression trees. Here are two good tutorials on the subject:...http://marlongrech.wordpress.com/2008/01/08/working-with-expression-trees-part-1/...http://www.davidhayden.com/blog/dave/archive/2006/12/18/E...

Dynamic LINQ: Use .NET Contains method to generate a dynamic search method

I have a class Item like...public class Item { public int Id {get;set;} public string Name {get;set;} public string PartialDescription {get;set;} public string FullDescription {get;set;} public doulbe Price {get;set;} } ...I would like to have a dynamic custom query method SearchOverAnyFields() that can accept any number of Item obj...

Aggregate function Count() using dynamic linq query

I am trying to use ...Aggregate function...Count()... on some column using dynamic linq query but I am not able to achieve, what I am exactly looking is...Select Count(Id),Id from Table1 Group By Id Having Count(Id) > 1 ...I want to convert the same query to dynamic linq query, any suggestions on how to achieve this?

Dynamic LINQ aggregates on IQueryable as a single query

You don't need anonymous type. You just need a type with the 3 properties ...Sum..., ...Count... and ...Average.... ...Sum... and ...Average... type aren't known at design time. So, use ...Object... type for these 2 properties. ...Count... is always an ...int.......public class Aggregation { public Aggregation(object sum, object average, int co...

No applicable method 'Parse' exists in type 'DateTime'

I get the exception "No applicable method 'Parse' exists in type 'DateTime'" when I run the following code:...var truncatedData = new object(); string TableName = "Products"; string ColumnName = cboAdvSearchCol1.Text.ToString(); var rawData = twr.GetType().GetProperty(TableName).GetValue(twr, null); string query = ColumnName + ">= DateTime.Parse("...

Dynamic LINQ - Groupby with ExpandoObject Results in Error: No Applicable Indexer

Is it possible to perform a GroupBy using Dynamic LINQ with an ExpandoObject?...Consider the example below; ideally I'd like a grouped list of ExpandoObjects....Thank you for your time....var listOfExpandoObjects = new List<ExpandoObject>(); var expandoObject = new ExpandoObject(); ((IDictionary<string, object>)expandoObject).Add("DynamicProperty",...

Passing an aggregate select expression to Dynamic Linq's GroupBy

I have simplified the following example from my code and hoping there's no obvious compilation errors because of it. Lets say I have the following entities (not what i actually have, please assume I have no EF or schema issues, this is just for example):...public class Company { public string GroupProperty {get;set;} public virtual ICollection<...

C#, dynamic linq error No applicable method 'Contains' exists in type 'String'

I have a list of objects like this (I am using .NET 3.5)...public class MyObjects { public object Name { get; set; } public bool Case { get; set; } } List<MyObjects> test = new List<MyObjects> { new MyObjects { Name = "one" }, new MyObjects { Name = "two" }, new MyObjects { Name = "three" }, new MyObjects { Name = "four" ...

No method 'SelectToken' exists on type 'System.Linq.Enumerable'

I would like to run a ...Json Object... through ...DynamicExpression... but i am getting the error ..."No method 'SelectToken' exists on type 'System.Linq.Enumerable'."...the below rule i am trying to execute through DynamicExpression. ...Rule: ...JObject.SelectToken(\"$.Dosage\").ToString()==\"25\"...my Json Object:...{ "Dosage": 25, "Drug": "...

How to Conditionally the column in LINQ OrderByDescending for OrderBy in C#?

You can use the library ...System.Linq.Dynamic.Core... which supports dynamic querying, selecting and ordering....Example code:...var q = new List<Person> { new Person{Name = "C", Age = 30 }, new Person{Name = "A", Age = 7 }, new Person{Name = "B", Age = 5 } }.AsQueryable(); var x1 = q.OrderBy("Name asc"); var a1 = q.OrderBy("Age desc...