Linq for dates that is dynamic

asp.net dynamic-linq linq

Question

I want to build dynamic Linq. Following is my code which works fine for one date. But user can select many dates from calendar. And I need to make Linq for all those selected dates.

saleDate = calendarSales.SelectedDate;
List<SaleDetails> saleDetials = new List<SaleDetails>();
saleDetials = GetSaleDetails();
saleDetials.Where(sale => (Convert.ToDateTime(sale.DATE_TIME).Day == saleDate.Day &&
                           Convert.ToDateTime(sale.DATE_TIME).Month == saleDate.Month && 
                           Convert.ToDateTime(sale.DATE_TIME).Year == saleDate.Year)
                  ).ToList();

How to update this query?

1
0
9/28/2011 9:25:02 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

You have to build the predicate for your where clause dynamically.

Take a look at the predicatebuilder.

EDIT

Of cause PredicateBuilder supports AND and OR operators.

When using OR you have to start with the initial value of False:

// building the predicate
var pred = PredicateBuilder.False<SaleDetails>();
foreach (var date in MyDateList) 
{
    pred = pred.Or(sale => sale.DATE_TIME.Date == saleDate.Date);
}

// finally get the data and filter it by our dynamic predicate
List<SaleDetails> saleDetails = GetSaleDetails().Where(pred).ToList();
2
9/28/2011 10:35:43 AM

Related Questions

Using the System.Linq.Dynamic namespace, how to perform the following in Dynamic Linq

I just want to know how to do the following in Dynamic Linq using System.Linq.Dynamic namespace...var query2 = db.Customers.Select( cust => new Customer { FirstName = cust.FirstName, LastName = cust.LastName Tags="sampleTag,Tag" ...
dynamic-linq linq
asked by emem

Does dynamic GroupBy in dynamic LINQ work with dynamic Where?

I use this ...dynamic LINQ library... together with Linq-to-Entities.... I build query and after that iterate it with ...foreach(object e in query){}...query=db.Table1.Where("it.FieldA>10").Select("it.FieldB");... works....query=db.Table1.Where(e=>e.FieldA>10).GroupBy("it.FieldB", "it").Select("key")... works.... But ...query=db.Table1.Where("it.Fi...
.net dynamic dynamic-linq linq linq-to-entities
asked by alpav

LINQ-to-SQL dynamic table name LINQ-to-SQL

I want to construct my query dynamically based on the contents user has selected, and I want to do this in LINQ-t0-SQL. I have seen ...this..., but I don't want to use SQL statements with datacontext....On Googling a bit I have a feeling that this can be done using dynamic LINQ. Would someone provide an example of similar scenario with dynamic LINQ...
dynamic-linq linq-to-sql
asked by Muhammad Adeel Zahid

Multiple table dynamic, Entity Data Model, Dynamic Linq Strongly typed return types, when clause

When writing a method for an oData service I have the below linq, for which I need to have a dynamic "where" clause to filter the results (the "new"s in the joins are for composite PKs in the Entity Data Model):...var query = from pl in CurrentDataSource.ProductListing join pla in CurrentDataSource.ProductListingAttribute ...
anonymous-types c# dynamic-linq linq-to-entities
asked by rposbo

How can I utilize System.Linq.Dynamic for the LIKE operation?

Can any body tell me how can I use a LIKE operator using ...System.Linq.Dynamic...?...I need to add more than one ...LIKE... expression in my dynamic ...where query.../* var query = db.Customers. Where("CityName Like @0 or CityName Like @1", "London", "USA") */ var query = db.Customers. Where("CityName Like @0 or CityName Like @1%", "London", "USA"...
asp.net c# dynamic-linq linq
asked by Kiarash

OrderBy inside a GroupBy using dynamic LINQ?

I had the following query using normal linq and it was working great (using anonymous type),... var result = from s in Items group s by s.StartTime into groupedItems select new {groupedItems.Key, Items= groupedItems.OrderBy(x => x.Name) }; ...But using Dynamic Linq I cannot get it to order by within the groupby.... r...
dynamic-linq linq linq-to-objects
asked by Martin

Perform a query on an object having members of type "dynamic" using Dynamic Linq.

I am trying to use a dynamic linq query to retrieve an IEnumerable<T> from an object collection (Linq to Object), each of the objects in the collection have an internal collection with another set of objects where the data is stored, these values are accessed through an indexer from the outer collection...The dynamic linq query returns the filtered...
c# dynamic-linq expression-trees lambda
asked by Darsegura

Dynamic LINQ Compare Dates in Entity Framework

I am using the dynamic linq library with entity framework and want to compare dates. I have succesfully extended the library based on the following SO article ...here... However what I can not seem to do is to get the library to compare just the date portion of the DateTime property of my entity object as I would do with a normal linq expression. ....
.net dynamic-linq entity-framework linq linq-to-entities
asked by Cragly

How can I access the result of dynamic linq with dynamic key/value pairs of IEnumerable?

I have a Dynamic Linq query, through which am trying to access grouped data, grouped on two columns, and 1 columns on which aggregation function is used.... var gFieldList = new List<string>() { "Supplier", "Country" }; var sFieldList = new List<string>() { "Sales"}; var gField = string.Join(", ", gFieldList.Select(x => "it[\"" + x + "\"]...
c# dynamic-linq linq
asked by Varun Chaturvedi

System.Linq.Dynamic.Core vs System.Linq.Dynamic

What is the difference between System.Linq.Dynamic.Core and System.Linq.Dynamic? I am currently using System.Linq.Dynamic and it does not contain support for ...Select... and ...SelectMany... (among other extension methods). Does System.Linq.Dynamic.Core support these methods?
dynamic-linq
asked by jjf1978

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