Capturing Output Arguments from Stored Procedures in SQL Server with Entity Framework Core

Question

Dear Friends,

I would appreciate an explanation of how to capture the values of output parameters when calling stored procedures in SQL Server 2019 from Entity Framework Core 6.

Thank you for your trouble, and best regards,

Eric Weinberger

Answer 1

Hi @Pamphylios ，

About FromSqlRaw(), FromSqlInterpolated(), you can see:

Working with Stored Procedure in Entity Framework Core

EF core provides:
DbSet<TEntity>.FromSql()
DbContext.Database.ExecuteSqlCommand()

How to use a SQL output parameter with FromSqlInterpolated? Or alternative

and

How to call stored procedures with OUTPUT parameters with FromSqlRaw in EF Core

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

With SqlParameter and Direction property = Output.
https://learn.microsoft.com/en-us/dotnet/api/system.data.parameterdirection?view=net-6.0&viewFallbackFrom=dotnet-plat-ext-6.0

Answer 3

Thank you, @Olaf Helper .
It looks as though this solution would work in ADO.NET.
I should have been more specific, but I am looking for a way to capture output arguments from stored procedures using FromSqlRaw(), FromSqlInterpolated(), or something similar.