LINQ in Action roller

how to make a LINQ query return multiple count() or sum() columns?

Hi everyone, I'm pretty new to LINQ and I've run across a problem that I can't seem to fix myself. I have a working SQL query that looks like this: Code Snippet SELECT COUNT ( dbo . PDI . coilId ) AS NumberOfCoils, ROUND ( SUM ( dbo . GagTrends . coilLength ), 0 ) AS TotalLength FROM dbo . PcProcStat INNER JOIN dbo . PDI ON dbo . PcProcStat . cid = dbo . PDI . cid INNER JOIN dbo . GagTrends ON dbo . PDI . cid = dbo . GagTrends . cid WHERE ( dbo . PcProcStat . trMndClpsd_time BETWEEN @DateStart AND Read More...
Published Tuesday, January 29, 2008 7:15 PM by MSDN Forums: LINQ Project General
Anonymous comments are disabled

Featured Item

This Blog

Sponsoring

Syndication