How expensive is SqlCommandBuilder.DeriveParameters?

Question

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

Answer 1

See this article on adding Parameter Caching to SqlCommandBuilder.DeriveParameters

Answer 2

Calling DeriveParameters will require a DB call (every time). There is no integrated caching, you would have to implement this yourself.