Re: [Firebird-net-provider] Stored Procedures Entity Framework

2011-04-27 Thread Jiri Cincura 
It's probably bug. Create a tracker ticket for it, please.

-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

--
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

[Firebird-net-provider] Stored Procedures Entity Framework

2011-04-25 Thread Doru Constantin 
Hello,

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 ObjectResultglobal::System.String
sp_Tables(ObjectParameter tABLE_NAME)
{
return
base.ExecuteFunctionglobal::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 ObjectResultglobal::System.String sp_Tables()
{
return base.ExecuteFunctionglobal::System.String(sp_Tables);
}

but it gets overwritten every time I upate the entity model.

Thank you for your time.
*
*
*Doru *
--
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

[Firebird-net-provider] Stored Procedures Entity Framework

2011-04-25 Thread Doru Constantin 
Hello,

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 ObjectResultglobal::System.String
sp_Tables(ObjectParameter tABLE_NAME)
{
return
base.ExecuteFunctionglobal::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 ObjectResultglobal::System.String sp_Tables()
{
return base.ExecuteFunctionglobal::System.String(sp_Tables);
}

but it gets overwritten every time I upate the entity model.

Thank you for your time.
*
*
*Doru

*
--
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