LINQ Query and DateTimes....

Posted by AlwaysBeCoding on Stack Overflow See other posts from Stack Overflow or by AlwaysBeCoding
Published on 2010-05-31T17:19:41Z Indexed on 2010/05/31 17:23 UTC
Read the original article Hit count: 108

Filed under:

c#3.0

|

linq-to-objects

Im trying to get the Sum() from an Entityset with the next query.

(from MyObject p in SelectedObject.MyObjectEntitySet
                                            where p.AColumn.HasValue && 
                                            (p.ADate >= dateTimeValue &&
                                            p.ADate <= dateTimeValue2)
                                            select p.AColumn.Value).Sum();

with no luck retrieving correct sum.

Any Ideas?

Related posts about linq-to-objects

Linq To Objects Auto Increment Number

as seen on Stack Overflow - Search for 'Stack Overflow'
This feels like a completely basic question, but, for the life of me, I can't seem to work out an elegant solution. Basically, I am doing a Linq Query creating a new object from the query. In the new object, I want to generate a auto-incremented number to allow me to keep a selection order for… >>> More
When is LINQ (to objects) Overused?

as seen on Stack Overflow - Search for 'Stack Overflow'
My career started as a hard-core functional-paradigm developer (LISP), and now I'm a hard-care .net/C# developer. Of course I'm enamored with LINQ. However, I also believe in (1) using the right tool for the job and (2) preserving the KISS principle: of the 60+ engineers I work with, perhaps only… >>> More
LinQ to objects GroupBy() by object and Sum() by amount

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I have pretty simple case which I started solving using foreach(), but then I thought I could do It using Linq Basically I have IList that contains PaymentTransaction objects and there are 2 properties Dealer and Amount I want to GroupBy() by Dealer and Sum() bv amount. I tried to accomplish… >>> More
Linq-To-Objects group by

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey, I'm building a software for timereporting I have a Dictionary<string, Dictionary<string, double>>. The key in the main dictionary is a users name and their value is a dictionary of . I have a function GetDepartment(string UserName) which returns a string with the users department… >>> More
Switching from LinqToXYZ to LinqToObjects

as seen on Stack Overflow - Search for 'Stack Overflow'
In answering this question, it got me thinking... I often use this pattern: collectionofsomestuff //here it's LinqToEntities .Select(something=>new{something.Name,something.SomeGuid}) .ToArray() //From here on it's LinqToObjects .Select(s=>new SelectListItem() { … >>> More

Developer IT

LINQ Query and DateTimes.... - Developer IT

LINQ Query and DateTimes....

c#3.0

linq-to-objects

Related posts about c#3.0

Linq Tutorial

Related posts about linq-to-objects

Linq To Objects Auto Increment Number

When is LINQ (to objects) Overused?

LinQ to objects GroupBy() by object and Sum() by amount

Linq-To-Objects group by

Switching from LinqToXYZ to LinqToObjects

Categories cloud