[Firebird-net-provider] Stored Proc execution question

[Carlos G. A. <car...@te...>]

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