Converting SQL to LINQ, Part 5: GROUP BY and HAVING (Bill Horst)

re: Converting SQL to LINQ, Part 5: GROUP BY and HAVING (Bill Horst)

Oracy — Thu, 20 Dec 2007 02:53:36 GMT

I'm not sure there is such a SQL statement

SELECT CustomerID, State

FROM CustomerTable

GROUP BY State

From my experience using SQL Server, CustomerID should be at the GROUP BY clause too, or it should be used by an aggregate function, like MIN.

Aprendiendo LINQ para Visual Basic 2008

Jorge Serrano - MVP Visual Developer - Visual Basic — Thu, 20 Dec 2007 10:16:58 GMT

Si quieres aprender LINQ para Visual Basic 2008, quizás te interesen los siguientes artículos que el

re: Converting SQL to LINQ, Part 5: GROUP BY and HAVING (Bill Horst)

VBTeam — Mon, 31 Dec 2007 21:12:27 GMT

Hi Oracy,

I stand corrected - in a SQL statement, indeed, all fields in the Select clause must either be Aggregated or used in the Group By. This restriction does not exist in LINQ (which is why I forgot about it :).

I'll try to update this post slightly to avoid confusion.

Thanks for the feedback,

- Bill

Aprendiendo LINQ para Visual Basic 2008

El blog de Jorge — Tue, 01 Jan 2008 12:59:55 GMT

Si quieres aprender LINQ para Visual Basic 2008, quizás te interesen los siguientes artículos que el

Converting SQL to LINQ, Part 7: UNION, TOP, Subqueries (Bill Horst)

The Visual Basic Team — Tue, 08 Jan 2008 23:44:45 GMT

This post assumes you’ve read the previous posts in this series: Converting SQL to LINQ, Part 1: The

Converting SQL to LINQ, Part 6: Joins (Bill Horst)

The Visual Basic Team — Tue, 08 Jan 2008 23:45:39 GMT

This post assumes you’ve read the previous posts in this series: Converting SQL to LINQ, Part 1: The

SQL から LINQ への変換、パート 7 : UNION、TOP、サブクエリ (Bill Horst)

The Visual Basic Team — Thu, 29 May 2008 10:50:14 GMT

ここでは、このシリーズの前の投稿をお読みになっていることを前提としています。 Converting SQL to LINQ, Part 1: The Basics ( 英語 ) Converting SQL