TypeConverter - DbType to >NET Type

    public static class TypeConverter

    {

        private static readonly Dictionary typeToDbType = new Dictionary

        {

            { typeof(string), DbType.String },

            { typeof(DateTime), DbType.DateTime },

            { typeof(DateTime?), DbType.DateTime },

            { typeof(int), DbType.Int32 },

            { typeof(int?), DbType.Int32 },

            { typeof(long), DbType.Int64 },

            { typeof(long?), DbType.Int64 },

            { typeof(bool), DbType.Boolean },

            { typeof(bool?), DbType.Boolean },

            { typeof(byte[]), DbType.Binary },

            { typeof(decimal), DbType.Decimal },

            { typeof(decimal?), DbType.Decimal },

            { typeof(double), DbType.Double },

            { typeof(double?), DbType.Double },

            { typeof(float), DbType.Single },

            { typeof(float?), DbType.Single },

            { typeof(Guid), DbType.Guid },

            { typeof(Guid?), DbType.Guid }

        };

 

        public static DbType ToDbType(Type type)

        {

            if (!typeToDbType.ContainsKey(type))

            {

                throw new InvalidOperationException(string.Format("Type {0} doesn't have a matching DbType configured", type.FullName));

            }

 

            return typeToDbType[type];

        }