LINQ da SQL deki max islemini nasil mi yapariz?
Asagidaki sekilde,
MDDBDataContext dc = new MDDBDataContext();
var lastNumber = (from r in dc.RevenueSharings
select (int?)r.StatementNumber).Max();
SQL server profiler tarafinda asagidaki sekilde goreceksiniz...
SELECT MAX([t0].[StatementNumber]) AS [value]
FROM [dbo].[RevenueSharing] AS [t0]
Tags: linq, asp.net, c#, sql