Dynamic LINQ - Knowledge Base (KB)

Interval grouping using dynamic linq (DateTime, Numeric)

I search everywhere and didn`t find anwser for this question. I want to group by intervals (DateTime, Numeric) in Dynamic linq (the data will be crated dynamically so i must use dynamic linq)...Lets assume that we have such data:...ID|Date|Price 1|2010-1...

Accessing columns using Dynamic Linq

I have been trying to create a dynamic query that will check the contents of a datatable. The thing is I the number columns to be selected and also there names are given at runtime. The where clause thus needs to be constructed dynamically. Is there any w...

Dynamic LINQ Cast issue

When I try to execute this ESQL (Cast int to string) with dynamic linq (from this ...link...)...queryable.Where("CAST(PositionID AS Edm.String).Contains(@0)", paramsObj); //PositionID is Int32 ...it throw exception...')' or ',' expected ...My Entity Frame...

Dynamic LINQ: Comparing Nested Data With Parent Property

I've a class with following structure:... public class BestWayContext { public Preference Preference { get; set; } public DateTime DueDate { get; set; } public List<ServiceRate> ServiceRate { get; set; } } public class ServiceRate { publi...

Dynamic Linq and use of Between

I am having a Dynamic Linq where It should perform comparison between two integers. I tried so many but none of them worked for me....Code...db.Bibs.Where(" Id >= 1 && Id<1000 ") db.Bibs.Where(" Id between 1 && 1000 ") ...How to form this string to make...