SqlKata: SELECT STUFF

514 Views Asked by At

I have a stored procedure in SQL Server and I would like to transfer it to C# code using sqlKata.

I was able to do most of the transcripts but I am having trouble with one fragment.

It is my SQL Server stored procedure:

ALTER PROCEDURE [dbo].[my_procedure] 
    @UserId INT = 0
AS
BEGIN
    SELECT 
        STUFF((SELECT InboxHtml AS [text()]
               FROM [dbo].[my_procedure] WITH (NOLOCK)
               WHERE UserId = @UserId
                 AND DATEDIFF(DAY, GETDATE(), VisibleUntil) > 0
               FOR XML PATH(''), TYPE).value('text()[1]', 'nvarchar(max)'), 1, 0, NULL) AS InboxHtml 
END

And in C# with sqlkata:

db.Query("my_procedure").Select("InboxHtml").Where(new { UserId = id })
                .WhereRaw("DATEDIFF(DAY, GETDATE(), VisibleUntil) > ?", 0)

How can I add STUFF ... FOR XML PATH with sqlKata??

Thanks ! :)

0

There are 0 best solutions below