[FB-Tracker] Created: (DNET-708) DbModelBuilder.Entity<TEntity>().MapToStoredProcedures() creates an empty procedure

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[FB-Tracker] Created: (DNET-708) DbModelBuilder.Entity<TEntity>().MapToStoredProcedures() creates an empty procedure

JIRA tracker@firebirdsql.org
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider