convert a Type to DBType ?!

[franky]

For convert a Type to DBType do I need absolutly to proceed with a switch?

switch(var1.GetType().Name.ToString())
{
case("int"): parameter.DbType = (DbType)SqlDbType.Int;
break;
case("string"): parameter.DbType = (DbType)SqlDbType.NVarChar;
break;
case("bool"): parameter.DbType = (DbType)SqlDbType.Bit;
break;
}

 

[William Ryan eMVP]

AFAIK, yes

 

[Alex Feinman [MVP]]

Yes, unless someone has figured out a very clever trick