I've created a custom stored procedure and during modelling, nhydrate modeler throw an error saying there must be at least one field. I've tried going through the documentation and couldn't find how do i create that field, in the issue list, i saw someone
doing something like this:
exec sp_executesql @query
--Added this because entity framework will not accept sp without return
DECLARE @Result INT
SET @Result = 1
Just to satisfy the modelling tool, and i manually added a new Field during the modelling called "res"
But when i tried to execute the stored procedure, thrown back with this error:
The data reader is incompatible with the specified 'MyCustomStoredProcedureColumn'. A member of the type, 'res', does not have a corresponding column in the data reader with the same name.
I'm very impressed by all the capabilities that this ORM brings, but even in the source code examples, there are no samples showing this, can anyone help please