Lamda Expression (LINQ)

See more:

C#3.0

C#

Select * from Temp

----------------------
this is in database

---------------------------------------------
PlateName PlateType  Qty   Cost Rate    Machine
---------------------------------------------
P.S	Medium	4	1600.00	400.00	SM101
P.S	Short	4	1600.00	400.00	SM101
P.S	Short	4	1600.00	400.00	SM101
P.S	Short	4	1600.00	400.00	SM101
P.S	Short	4	1600.00	400.00	SM101
P.S	Short	4	1600.00	400.00	SM101
CTP	Short	4	1200.00	300.00	SM101
CTP	Short	4	1200.00	300.00	SM101
CTP	Short	4	1200.00	300.00	SM101
CTP	Short	4	1200.00	300.00	SM101
CTP	Short	4	1200.00	300.00	SM101
---------------------------------------------

SELECT PlateName, PlateType, sum(Qty) Qty, sum(Cost) Cost, Rate, Machine
FROM TempPlates WHERE PlateType='short'  and  PlateName='P.S'
GROUP BY Rate,Machine,PlateType,PlateName

Result of this is Query is

PlateName PlateType  Qty   Cost         Rate    Machine
-------------------------------------------------
P.S	  Short	     20	  8000.00	400.00	SM101
-------------------------------------------------

I need to convert this querry into Lamda Expression(LINQ) for same result

thank in advance...!!