[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:
         Environment: Windows 7, Visual Studio 2015 Enterprise, Firebird, 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)


And in the migration:
                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]