DbModelBuilder.Entity<TEntity>().MapToStoredProcedures() creates an empty
procedure
-----------------------------------------------------------------------------------
Key: DNET-708
URL: http://tracker.firebirdsql.org/browse/DNET-708
Project: .NET Data provider
Issue Type: Bug
Components: Entity Framework support
Affects Versions: 5.5.0.0
Environment: Windows 7, Visual Studio 2015 Enterprise, Firebird
3.0.0.32485, EntityFramework.Firebird 5.5.0, FirebirdSql.Data.FirebirdClient
5.5.0
Reporter: Charles J Christie II
Assignee: Jiri Cincura
Priority: Minor
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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
