RE: [Firebird-net-provider] Stored Proc execution question

[Alan M. <al...@me...>]

I'm easy on this...
I'm afraid I rarely use this syntax in the world of ASP, I use
MyConnection.Execute("EXECUTE STORED PROCEDURE(..")
since it reduces overhead a little more than having to create parameters
etc.

Doesn't the old ADO way of doing it mean that the @ID parameter is not
explicit either?
doesn't the old way go something like

command.CommandType = CommandType.StoredProcedure;
command.CommandText = "SP_NAME";

then you create and add the parameters to the command


Alan


> -----Original Message-----
> From: fir...@li...
> [mailto:fir...@li...]On Behalf Of
> Carlos Guzman Alvarez
> Sent: Saturday, 21 June 2003 8:11 PM
> To: Firebird .Net Provider
> Subject: [Firebird-net-provider] Stored Proc execution question
>
>
> Hello:
>
>
> Now the CommandText for execute an stored proc needs to have the EXECUTE
> PROCEDURE and the begin:
>
>
> 	command.CommandType = CommandType.StoredProcedure;
>     	command.CommandText = "EXECUTE PROCEDURE SP_NAME(@ID)";
>
> I'm thinking in add a change to the 1.1 branch for allow stored proc to
> be executed as:
>
> 	command.CommandType = CommandType.StoredProcedure;
> 	command.CommandText = "SP_NAME(@ID)";
>
> And add a check to the CommandText when the CommandType =
> CommandType.StoredProcedure for see if it's needed to add the EXECUTE
> PROCEDURE string at the begining automatically.
>
>
>
> Any thoughts ????
>
>
>
> --
> Best regards
>
> Carlos Guzmán Álvarez
> Vigo-Spain
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: INetU
> Attention Web Developers & Consultants: Become An INetU Hosting Partner.
> Refer Dedicated Servers. We Manage Them. You Get 10% Monthly Commission!
> INetU Dedicated Managed Hosting http://www.inetu.net/partner/index.php
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>