Interval grouping using dynamic linq (DateTime, Numeric)

c#-4.0 dynamic-linq expression-trees lambda linq

Question

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-11-01|100  
2|2010-11-01|120  
3|2010-11-02|50  
4|2010-12-01|30  
5|2010-12-01|220  
6|2011-01-01|400

How to get this data grouped by like this

-(Group by Day) following groups

->2010-11-01 = 2 elements  
->2010-11-02 = 1 elements  
->2010-12-01 = 2 elements  
->2011-01-01 = 1 elements

-(Group by Month) following groups

->2010-11 = 3 elements  
->2010-12 = 2 elements  
->2011-01 = 1 elements

-(Group by Quarter) following groups

->2010 q.03 = 5 elements  
->2011 q.01 = 1 elements

-(Group by Year) following groups

->2010 = 5 elements  
->2011 = 1 element

-(Group by Price (From 0, Each 50)) following groups

-> <0-50) = 1 elements  
-> <50-100) = 1 elements  
-> <100-150) = 2 elements  
-> <200-250) = 1 elements  
-> <400-450) = 1 elements

-(ideally it would be Group by Price (From 0-50,From 50-150, From 150-500)) following groups

-> <0-50) = 1 elements  
-> <50-150) = 3 elements  
-> <150-500) = 2 elements

Any Ideas? I stress again - it must be DYNAMIC LINQ or eventually some sophisticated lambda expression? I should been able to "group" it by column name that will be in string. e.g.

GroupBy("Date"), GroupBy("Price");
1
1
9/23/2011 1:52:54 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

Here's how to do it:

For instance:

Group by Month

public Item[] data = 
    {
        new Item { Date = new DateTime(2011, 11, 6), Price = 103, Name = "a" },
        new Item { Date = new DateTime(2011, 11, 16), Price = 110, Name = "b" },
        new Item { Date = new DateTime(2011, 12, 4), Price = 200, Name = "c" },
        new Item { Date = new DateTime(2011, 12, 4), Price = 230, Name = "d" },
        new Item { Date = new DateTime(2012, 1, 15), Price = 117, Name = "e" }
    };

var groups = data.AsQueryable().GroupBy("Date.Month", "it").Cast<IGrouping<int, Item>>();

You can use "Date.Day" and "Date.Year" and for something like a price range you could use a function which maps everything in the range onto the same value e.g. using integer division "(it.Price / 50)"

0
10/3/2011 10:17:31 AM

Related Questions

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

I tried this:...using System; using System.Linq; using System.Linq.Dynamic; using System.Collections.Generic; namespace ConsoleApplication1 { public class Customer { public string FirstName { get; set; } public string LastName { get; set; } public string Tags { get; set; } } class Program { sta...
dynamic-linq linq
asked by MattC

Does dynamic GroupBy in dynamic LINQ work with dynamic Where?

Found it, ...db.Table1.AsQueryable()... fixed it, so ...db.Table1.AsQueryable().Where("it.FieldA>10").GroupBy("it.FieldB", "it").Select("key") ... works without exception....The problem was that Microsoft Dynamic Linq library extends ...IQueryable<Table1>..., so it does not take effect on... ObjectQuery<Table1>... which is the type of ...db.Table1....
.net dynamic dynamic-linq linq linq-to-entities
asked by alpav

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

Looks like ...this... is the link you need. ...Update.... Some details: you can use the SearchType method from the post to obtain a type using the table name and then use ...Dynamic LINQ... to write queries you like.
dynamic-linq linq-to-sql
asked by Devart

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

Try using simply "CityName.Contains(@1)" this will convert to the proper lambda since its a method invocation on an accessible type....something like:...var query = db.Customers. Where("CityName.Contains(@0) or CityName.Contains(@1)", "London", "USA") ...Just tested it with the sample app that comes with the dynamic library and it generates the LIK...
asp.net c# dynamic-linq linq
asked by Jaime

OrderBy inside a GroupBy using dynamic LINQ?

This is a good question!...I simulated your situation by creating a class called Item....public class Item { public DateTime StartTime { get; set; } public string Name { get; set; } } ...and then created a basic list of items to do the groupby....List<Item> Items = new List<Item>() { new Item() { StartTime = DateTime.Today, Name = "item...
dynamic-linq linq linq-to-objects
asked by Bengel

Dynamic LINQ DateTime Comparison String Building - Linq To Entities

It seems what I was trying to do is not possible with the current DynamicLINQ library. The reason it didn't work was well outlined below by Tilak....My solution was to modify the DynamicLINQ library to allow the query to be written as a string and passed to the where clause for Date/Time datatypes. The modification was found here by Paul Hatcher: ....
c# dynamic-linq entity-framework linq string
asked by Ricketts

Use a numeric value in a linq dynamic query string

You should not build a query string with inline predicate values. Use parameters in stead. Then will also be able to specify the type:...var whereConditions= "it.CARD_NUMBER = @cardNumber"; var param = new ObjectParameter("cardNumber", typeof(decimal)) { Value = 1 }; objQry = from o in m_Db.OBJECTS.Where(whereConditions, param); ...Edit...I don't k...
c# decimal dynamic-linq linq
asked by Gert Arnold

Dynamic linq query is not working with numeric value

You use parametrized query and pass as parameter string value, so this parameter have type string and you get error with operand types....for solving just pass decimal value, like...dgvLoadTable.DataSource = EntityName .TableName .Where(columnName + " = @0", int.Parse(searchValue) ) .ToList();
c# dynamic-linq winforms
asked by Grundy

Dynamic Linq + Entity Framework: datetime modifications for dynamic select

You can post process the query expression with custom ...ExpressionVisitor... and replace the unsupported methods with their ...DbFunctions... equivalents....Here is a starting point just to get the idea:...public static class QueryableExtensions { public static IQueryable BindDbFunctions(this IQueryable source) { var expression = n...
.net c# dynamic-linq entity-framework-6
asked by Ivan Stoev

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

System.Linq.Dynamic.Core... is more up to date and has more functionality and does also support NET Core / NETStandard (besides net35, net40 and net45 and up)...SelectMany... is indeed supported....For more information see the ...github... page and browse the examples, unit-tests and help page....Note: I'm the maintainer from this project.
dynamic-linq
asked by Stef Heyenrath

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