Linq for dates that is dynamic

asp.net dynamic-linq linq

Question

I want to create a dynamic Linq. Here is my code, which is good for a single date. However, the user has a wide range of calendar options. And I must create Linq for each of the chosen 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 can this query be updated?

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

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

The predicate for your where clause must be constructed dynamically.

Watch the predicatebuilder, please.

EDIT

PredicateBuilder allows this becauseAND and OR operators.

If usingOR You must begin with the default value ofFalse :

// 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 need to know how to do the following using System.Linq and Dynamic Linq. variable 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?

This ...LINQ dynamic library... is used in conjunction with Linq-to-Entities.... I construct the query and then iterate it using...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...
.net dynamic dynamic-linq linq linq-to-entities
asked by alpav

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

I want to utilize LINQ-to-SQL to generate my query dynamically depending on the user-selected data. I've seen ...this..., however I don't want to utilize datacontext with SQL operations....I believe that dynamic LINQ can be used to do this after doing some research online. Could someone provide an example of a case using dynamic LINQ that is simila...
dynamic-linq linq-to-sql
asked by Muhammad Adeel Zahid

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

In order to filter the results while building a method for an oData service, I need to have the following linq (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 on new {pl.ProductID, p...
anonymous-types c# dynamic-linq linq-to-entities
asked by rposbo

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

Can somebody explain to me how to utilize the LIKE operator with the ...System.Linq.Dynamic...?...I must include more than one....LIKE... my dynamic ...what question... expression.../* 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%", ...
asp.net c# dynamic-linq linq
asked by Kiarash

OrderBy inside a GroupBy using dynamic LINQ?

The following query was running flawlessly for me using regular Linq (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) }; ...However, I am unable to get it to sort by inside the groupby utilizing Dynamic ...
dynamic-linq linq linq-to-objects
asked by Martin

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

I'm attempting to utilize a dynamic Linq query to obtain an IEnumerableT> from an object collection (Linq to Object). Each object in the collection has an internal collection with a different set of objects where the data is kept....When dealing with highly typed objects, the dynamic linq query returns the filtered set as anticipated, however my ob...
c# dynamic-linq expression-trees lambda
asked by Darsegura

Dynamic LINQ Compare Dates in Entity Framework

To compare dates, I'm using the dynamic linq library with the entity framework. Based on the following SO article, ...here..., I have successfully expanded the library. However, I am unable to get the library to compare just the date section of the entity object's DateTime field, as I would be able do with a typical linq expression....I want to hav...
.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'm attempting to retrieve grouped data using a Dynamic Linq query. The data is grouped on two columns and one column uses an aggregation function.... var gFieldList = new List<string>() { "Supplier", "Country" }; var sFieldList = new List<string>() { "Sales"}; var gField = string.Join(", ", gFieldList.Select(x => "it[\"" + x + "\"] as " ...
c# dynamic-linq linq
asked by Varun Chaturvedi

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

What is System.Linq.Dynamic.Core different from System.Linq.Dynamic? System.Linq.Dynamic, which I am presently using, does not support ...Select... and ...SelectMany... (among other extension methods). Are these methods supported by System.Linq.Dynamic.Core?
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