How expensive is SqlCommandBuilder.DeriveParameters?

Question

What is the cost of calling SqlCommandBuilder.DeriveParameters? I understand that a DB server is required to get the parameters. After this is called, will the provider cache the information, or will it be re-requested EVERY time this method is called?

Answer 1

See this article about adding parameter caching to SqlCommandBuilder.DeriveParameters

Answer 2

When calling DeriveParameters, a database call is required (each time). There is no integrated caching, you have to implement this yourself.