Nu weet ik dat hier ook wat C# mensen zitten, vandaar de vraag:
Volgende TSQL statement:
Code:
DECLARE @offset INT=0;
SELECT TOP 1
[t1].[MyINT]+1 AS [MyINT]
FROM [MyTable] [t1]
WHERE (NOT ([t1].[MyINT] IS NULL))
AND ([t1].[MyINT]>@offset)
AND (NOT EXISTS(SELECT * FROM [MyTable] [t2] WHERE [t2].[MyINT]>@offset AND [t2].[MyINT]=[t1].[MyINT]+1))
ORDER BY [t1].[MyINT]
Hoe krijg je de laatste "NOT Exists" in de EF LAMBDA?
Zal iets worden als:
Code:
int offset = 0;
var item = db.MyTable.Where(x => x.MyINT != null && x.MyINT > offset).OrderBy(x => x.MyINT).First();
maar daar moet dus nog die "NOT Exists" bij...
Bookmarks