I have the following T-SQL:
DELETE FROM Table
WHERE UserId=@UserId
AND TableId NOT IN
(SELECT TOP 10 TableId
FROM Table
WHERE UserId=@UserId
ORDER BY DateColumn)
What is the NHiberante equivalent?
Cheers.
I have the following T-SQL:
DELETE FROM Table
WHERE UserId=@UserId
AND TableId NOT IN
(SELECT TOP 10 TableId
FROM Table
WHERE UserId=@UserId
ORDER BY DateColumn)
What is the NHiberante equivalent?
Cheers.