What are the correct parameter types to put in the config files?
• A – Good question. For the built in providers, the specific parameter types can be used. However, this is in conflict with the goal of virtualizing the database between providers, so the first choice should be to use normal clr types. There is a mapping between the clr types and provider specific types. If the provider specific type can’t be matched, an attempt is made to map to DbType. Finally, an exception is thrown.
