07/08/24 01:56:37
>>31
var rs2 = from c in dc.Shop orderby c.ID select c;
var rs = rs2.Distinct().Take(2);
で、こんなSQLになってた。Expressinの魔術ですな。
SELECT TOP 2 [t1].[ID], [t1].[Name], [t1].[timestamp]
FROM (
SELECT DISTINCT [t0].[ID], [t0].[Name], [t0].[timestamp]
FROM [dbo].[Shop] AS [t0]
) AS [t1]