How to convert a SqlDbType to plain Type

Hi there,

Given a collection of SqlDbType enums (eg, {BigInt, VarChar, Bit}), I
need to convert it to a collection of corresponding C# Types (here,
{long, string, bool}).

The contents of the source collection is not known ahead of time; it
could be any valid combination of enums in the SqlDbType enumeration.

Short of writing an explicit switch statement for all elements in the
enumeration, is there a neat way to convert SqlDbType enums to Types?


thanks for your help,

b.