LINQ to SQL selecting fields

Posted by user3686904 on Stack Overflow See other posts from Stack Overflow or by user3686904
Published on 2014-05-29T09:16:32Z Indexed on 2014/05/29 9:25 UTC
Read the original article Hit count: 128

Filed under:
|
|

I am trying to populate more columns in the query below, could someone assist me?

QUERY:

var query = from r in SQLresults.AsEnumerable()
            group r by r.Field<string>("COLUMN_ONE") into groupedTable
            select new
            {
                 c1 = groupedTable.Key,
                 c2 = groupedTable.Sum(s => s.Field<decimal>("COLUMN_TWO")),                            
            };

How could I get a column named COLUMN_THREE in this query ?

Thanks in advance

© Stack Overflow or respective owner

Related posts about c#

Related posts about sql