Wrong Entity Framwork generated model for stored procedure
----------------------------------------------------------
Key: DNET-378
URL: http://tracker.firebirdsql.org/browse/DNET-378
Project: .NET Data provider
Issue Type: Bug
Components: Entity Framework support
Affects Versions: 2.6
Reporter: Doru Constantin
Assignee: Jiri Cincura
I use VS2010 Pro with FirebirdSQL.NET provider 2.6 + C# 4.0 on FirebirdSQL
Server 2.5.1.26237.
I've generated the edmx model an work with data.All fine.
Now I try to run a simple stored procedure. My SP takes no parameters, but when
I try to call it VS2010 IntelliSense say that I have to provide one parameter
of type ObjectParameter
This is the generated model for stored procedure:
public ObjectResult<global::System.String> sp_Tables(ObjectParameter
tABLE_NAME)
{
return base.ExecuteFunction<global::System.String>("sp_Tables",
tABLE_NAME);
}
and this is the stored preocedure DDL:
CREATE OR ALTER PROCEDURE SP_TABLES
RETURNS(
table_name char(31))
AS
BEGIN
FOR SELECT RDB$RELATION_NAME
FROM RDB$RELATIONS
WHERE (LEFT(RDB$RELATION_NAME, 4) NOT IN('RDB$', 'MON$')) AND
(RDB$VIEW_SOURCE IS NULL)
INTO :TABLE_NAME
DO SUSPEND;
END
I can modify the code like this (and it works fine):
public ObjectResult<global::System.String> sp_Tables()
{
return base.ExecuteFunction<global::System.String>("sp_Tables");
}
but it gets overwritten every time I upate the entity model.
I think (by comparing with model generated for SQL Server Express) that edmx
file is generated Ok. The problem is in .cs associated file.
Thank you for your time.
Doru
--
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
------------------------------------------------------------------------------
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network
management toolset available today. Delivers lowest initial
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
