Submitted by: Charles J Christie II (sonicbhoc)

I attempted to map my entities as procedures in the model builder. I then went to test my database and, upon calling SaveChanges on my context, I got the following exception:
"Dynamic SQL Error
SQL error code = -84
procedure Address_Insert does not return any values
At line 1, column 15"

I opened the database using DBeaver and loaded the code used for the generated stored procedure:
CREATE OR ALTER PROCEDURE Address_Insert ("FirstName" VARCHAR(100), "LastName" VARCHAR(100), "AttnLine" VARCHAR(100), "Line1" VARCHAR(255), "Line2" VARCHAR(255), "City" VARCHAR(50), "State" VARCHAR(50), "Zip" VARCHAR(10), "Country" VARCHAR(53), "Job_Id" INTEGER, "Profile_Id" INTEGER)
AS
BEGIN

END

And in the migration:
CreateStoredProcedure(
"dbo.Address_Insert",
p => new
{
FirstName = p.String(maxLength: 100),
LastName = p.String(maxLength: 100),
AttnLine = p.String(maxLength: 100),
Line1 = p.String(maxLength: 255),
Line2 = p.String(maxLength: 255),
City = p.String(maxLength: 50),
State = p.String(maxLength: 50),
Zip = p.String(maxLength: 10),
Country = p.String(maxLength: 53),
Job_Id = p.Int(),
Profile_Id = p.Int(),
},
body: ""
);

All of the generated stored procedures have the same problem. They're all completely blank.
For now I won't use them. I'd suggest that if you don't want to implement this functionality any time soon, that you make it throw a NotImplementedException if you can, or have it prominently shown in your documentation that it doesn't do anything. Thank you.