Keith,
Thanks for the response
Would I be better off caching the parameters in advance, in the Application_Start method in the Global.ASAX file?
Thanks again
Rex
>The advantage is that you don't have to hand-code a bunch of SqlCommand.Parameters.Add() statements. The other available method of setting up the SqlCommand parameters is to use the SqlCommandBuilder, which has a larger footprint than the Blocks and retreives the parameter metadata from SQL Server each time it is used.
>
>P.S. The parameters collection is instanced each time a SqlCommand object is created, but not when the stored procedure is used.
>
>>All,
>>
>>In the Microsoft Data Access Application Block I noticed that parameter caching was used. What are the advantages of data caching instead of instantiating the parameter objects each time a stored procedure is used?
>>
>>Thanks
>>
>>Rex
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only