Dynamic LINQ - Knowledge Base (KB)

Dynamic Linq Query not working with DateTime field

I am using Dynamic linq to provide my MVC app with data and I have trouble with DateTime fields....The objects I'm parsing through has a System.Datetime field and I want to check if the dates correspond....So I try to build the string like this (I'm parsi...

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...

Entity Framework IQueryable - specific date

I am trying to filter rows of data on a specific date:...The current code takes a dictionary of , and applies the filter to queryable like so:...queryable = pageSettings.FiltersDictionary.Aggregate(queryable, (current, keyValuePair) => current.Where(keyV...

How to filter by a part of the date dynamically

If I want to build a specific rule in dynamic query where part of the condition states that...the same month of the year...I have the following datasource :...List<Excuse> li = new List<Excuse>(); li.Add(new Excuse { EmpNum = 3333, ExcuseDate = DateTime.T...

How to set DateTime equals method with Dynamic Linq in C#?

I need to filter data with Dynamic LINQ by DateTime field....I'm try doing this like:...public class MyClass { private DateTime datetime_field; //... //some other fields //... } public void MyMethod(string where_clause) { List<MyClass...