the RefCursor returned is for a DTO, that is not an entity set in the DbContext.
context.Database.ExecuteSqlRaw(sql, parms)
Is this a supported scenario?
Are there any examples?
Are there specific settings to keep connection open to allow to retrieve the ref cursor?
In ASP.NET Core app, with Microsoft Dependency Injection, it seems I get the value of the OUT Parameter, but when executing GetDataReader() , exception is thrown:
System.InvalidOperationException: 'Invalid operation on a closed object'