Using Entity Framework and Raw SQL for stored procedures and exception handling

I can successfully use stored procedures using ExecuteSqlRawAsync or FromSqlRaw in EF but I want to be able to catch exceptions in case the stored procedure returns an error using ERROR_SEVERITY().

For example I have an insert statement in a stored procedure and I am using a Try Catch in the procedure. In the catch I use,

SELECT 
    ERROR_SEVERITY() AS ErrorSeverity, 
    ERROR_PROCEDURE() AS ErrorProcedure,
    ERROR_MESSAGE() AS ErrorMessage;

In C# I use ExecuteSqlRawAsync to execute the procedure and if there is a SQL error I don't get the Severity code since there is no return value in ExecuteSqlRawAsync. Do I need to use FromSqlRaw to get the returned value even for an insert?

I want to catch the exception on the C# side.