Hi. I need a little help :p
Note: I'm using VS2010 with .net 4 and Firebird Net Provider 2.6.5.
I written a stored procedure to do a logic delete in my Firebird DB. I want
to map this SP in the Delete Function in one table. Here my table, domain
and sp code:
Domain:
CREATE DOMAIN UUID AS
CHAR(16) CHARACTER SET OCTETS
NOT NULL
COLLATE OCTETS;
Table:
CREATE TABLE DEPARTAMENTO (
DEPART_UUID UUID NOT NULL, -> I use #GUID# keyword description here to
force EF to read a guid type
CODIGO VARCHAR(20) CHARACTER SET NONE NOT NULL,
NOMBRE_DEPARTAMENTO VARCHAR_LARGO NOT NULL,
USUARIO_REGISTRO USUARIO NOT NULL,
FECHA_REGISTRO FECHA NOT NULL,
LOGIC_DELETED "BOOLEAN" NOT NULL);
ALTER TABLE DEPARTAMENTO ADD PRIMARY KEY (DEPART_UUID);
Stored Procedure:
CREATE PROCEDURE DEPART_LOGIC_DELETE(
/* #GUID# */
DEPART_UUID TYPE OF UUID)
RETURNS(
SUCCESS INTEGER)
AS
BEGIN
UPDATE DEPARTAMENTO
SET DEPARTAMENTO.LOGIC_DELETED = 1
WHERE DEPARTAMENTO.DEPART_UUID = :DEPART_UUID;
SUCCESS = ROW_COUNT;
SUSPEND;
END;
When I add this SP to my Entity Framework Model, the input parameter is set
to char. I add the #GUID# keyword in Description field to try to change it
to GUID type, but it doesn't work.
When I try to map the logid delete SP in the Delete Function in the Table
DEPARTAMENTO this error is displayed:
Error 1 Error 2042: Parameter Mapping specified is not valid. The type
'Edm.Guid' of member 'DEPART_UUID' in type 'ModeloEntities.DEPARTAMENTO' is
not compatible with 'FirebirdClient.char' of parameter 'DEPART_UUID' in
function 'ModeloEntities.Store.DEPART_LOGIC_DELETE'.
D:\Inventario\Inventario\DataManagement\Data\Entities\ModeloEntities.edmx
497 19 ToolsContext
Also I try to chance the code of my .edmx and set the char parameter to guid
by myself, but it doesn't work either.
What can I do to force .net EF 4 to read my input variable (DEPART_UUID)
from de SP DEPART_LOGIC_DELETE like a GUID type and not a char type?
Here pics to try to explain better:
http://img849.imageshack.us/img849/7190/00001n.jpg
http://img217.imageshack.us/img217/6366/00002oj.jpg
Thanks for all.
--
View this message in context:
http://firebird.1100200.n4.nabble.com/EF-4-Stored-Procedure-with-UUID-Input-Parameter-tp3745547p3745547.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.
------------------------------------------------------------------------------
uberSVN's rich system and user administration capabilities and model
configuration take the hassle out of deploying and managing Subversion and
the tools developers use with it. Learn more about uberSVN and get a free
download at: http://p.sf.net/sfu/wandisco-dev2dev
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
