Automatically Convert DB Type to .NET Type

[David Elliott]

Is there an API to convert from a Database type to a .NET System type.

I could create a switch statement using the info here:
http://msdn.microsoft.com/library/d...aproviderdatatypestonetframeworkdatatypes.asp
but was really hoping not to have to do this.

Thanks,
Dave

 

[Miha Markic [MVP C#]]

Hi David,

You'll have to switch.

 

[William Ryan eMVP]

David:

This happens automatically in most cases, so depending on what you want to
do, this may not be necessary. However, to answer your question, I don't
know of a function or API that will do all of them but I'm guessing there's
something in reflection that does it for you...haven't found it yet though.