I seem to be having problems importing stored procedure in entity framework for child tables.
As verbose as this error may seem I have no idea how to fix it besides maybe deleting the relationship then importing the stored procedures, then add back the relationships after(not a good idea).
I turned off the cascades delete and update but its still a no go.
This is my error.
The tables
I am using VS2012
As verbose as this error may seem I have no idea how to fix it besides maybe deleting the relationship then importing the stored procedures, then add back the relationships after(not a good idea).
I turned off the cascades delete and update but its still a no go.
This is my error.
The tables
Code:
delimiter $$
CREATE DEFINER=`root`@`%` PROCEDURE `sp_AddPool`(
IN rid INTEGER,
IN pid VARCHARACTER(50),
IN pnam VARCHARACTER (50),
IN wmin DECIMAL,
IN wmax DECIMAL)
BEGIN
INSERT INTO pool (raceid,poolid,
poolname,wagermin,
wagermax)
VALUES (rid, pid,
pnam, wmin, wmax);
SELECT LAST_INSERT_ID();
END$$
I am using VS2012