Re: [Firebird-net-provider] DeriveParameters question

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

Hello:

> Yes that's exactly what I want to do :)

Thanks, finally i have implmented it in 1.5 version, an example:

FbConnection connection = new FbConnection(connectionString);
connection.Open();

FbCommandBuilder builder = new FbCommandBuilder();
			
FbCommand command = new FbCommand("GETVARCHARFIELD", connection);
			
command.CommandType = CommandType.StoredProcedure;
						
FbCommandBuilder.DeriveParameters(command);
			
Console.WriteLine("Derived Parameters");
			
for (int i = 0; i < command.Parameters.Count; i++)
{
	Console.WriteLine("Parameter name: {0}\tParameter Source 			 
Column:{1}\tDirection:{2}",
		command.Parameters[i].ParameterName,
		command.Parameters[i].SourceColumn,
		command.Parameters[i].Direction);
}
		
connection.Close();

The resulting command text ( that will be auto generated ) is:

execute procedure GETVARCHARFIELD(@ID)






-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain