Friday, December 12, 2008

Group By in LINQ TO SQL [Multiple Columns]

 

Today I have to write a  Operation [WCF] which  takes  Input as a String  Metal type and  it will  group the Records by a column XXXX in a Table and sum XX and YY column. 

Here i am going to use North wind  Database  for DEMO . I can not post my Project code.

image

 

Here I am using Group By and SUM Aggregate Functions to add all Freight Charge.

 

image

Thanks

SreenivasaRagavan.

1 comment:

Prabhu Raja said...

Hi,

This Sample code helps me a lot..

and it is understandable...

Good Job... Keep Posting on Linq