Simon Mourier's Blog - Linking TypeCode and SqlDbType or DbType

c#
reflection
sql

Linking TypeCode and SqlDbType or DbType

Oct 22, 2011 See the question and my original answer on StackOverflow

Here is a trick to get the SqlDbType value for any given object. (It's not based on the TypeCode):

// create an SQL Parameter object
SqlParameter p = new SqlParameter("dummy", myObj);

// ask SQL code to compute its SqlDbType for us
Console.WriteLine(p.SqlDbType);