convert DbType to/from TypeCode

[richlm]

I can find plenty of documentation on the relation between
System.Data.DbType and System.Type e.g.
http://msdn.microsoft.com/library/d...aproviderdatatypestonetframeworkdatatypes.asp

Is there a method anywhere in the .NET framework that does this mapping, or
do we have to write a long switch(...) statement?

 

[Frans Bouma [C# MVP]]

I can find plenty of documentation on the relation between
System.Data.DbType and System.Type e.g.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/htm
l/cpconmappingnetdataproviderdatatypestonetframeworkdatatypes.asp

Is there a method anywhere in the .NET framework that does this mapping, or
do we have to write a long switch(...) statement?

The long switch is the only option.

FB