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

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

Hello:

> 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


I'm reviewing how the Sql Server provider works and seems that you are 
right:


http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconusingstoredprocedureswithcommand.asp





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain