Figure 1. Trace That Method. As you can see from this SQL Trace window, calling a Command object's Refresh method to retrieve parameter information results in a lot of round-trips to the database server-one for each parameter in the stored procedure. You can avoid round-trips by explicitly creating your command parameters. |