linq to entities query for count and group by with join on 2 tables
Posted
by samsur
on Stack Overflow
See other posts from Stack Overflow
or by samsur
Published on 2010-05-08T06:55:40Z
Indexed on
2010/05/08
7:08 UTC
Read the original article
Hit count: 534
I need a linq to entities query/ lambda expression for the following statement. Any help is greatly appreciated
SELECT at.Name, Count(a.AssetTypeId) as CountofAssets, at.AssetTypeId FROM AssetTypes at, Assets a WHERE at.AssetClassId = 7 GROUP BY at.Name,at.AssetTypeID
© Stack Overflow or respective owner