How to Convert System.Type to DBType

Question

Can some one please tell how to convert System.Type to DBType. Please response as soon as possible

it novice · Answer

many many thanks for your solution I will surely try this. Thanks

Alan · Answer

That's a reasonable solution though you don't need the 'break' statements in your switch as you've already got 'return' in each case. In fact I think you'll get an 'unreachable code detected' warning if you leave them in. You could shorten the code quite a bit using my earlier approach. This would also deal with unsigned types as well: public static DbType TypeToDbType(Type t) { DbType dbt; try { dbt = (DbType)Enum.Parse(typeof(DbType) t.Name); } catch { dbt = DbType.Object; } return dbt; }

it novice · Answer

I solved this problem by writing one function that is public static DbType TypeToDbType( Type T) { switch (T.FullName) { case System.Int64 : return DbType .Int64; break ; case System.Int32 : return DbType .Int32; break ; case System.Int16 : return DbType .Int16; break ; case System.Decimal : return DbType .Decimal; break ; case System.Double : return DbType .Double; break ; case System.Boolean : return DbType .Boolean; break ; case System.String : return DbType .String; break ; case System.DateTime : return DbType .DateTime; break ; default : return DbType .Object; break ; } } But I am looking for some better solution then this. Thanks

Alan · Answer

Do you mean something like this? using System; using System.Data; class Test { static void Main() { Type t = typeof(System.Decimal); // or whatever DbType dbt = (DbType)Enum.Parse(typeof(DbType) t.Name); Console.WriteLine(dbt.ToString()); //Decimal Console.ReadLine(); } }

Chi Cuong · Answer

hiiii