internal static DbType SqlDbTypeToDbType(SqlDbType sqlDbType)
{
switch (sqlDbType) {
case SqlDbType.BigInt : return DbType.Int64;
case SqlDbType.Binary : return DbType.Binary;
case SqlDbType.Bit : return DbType.Boolean;
case SqlDbType.Char : return DbType.AnsiStringFixedLength;
case SqlDbType.DateTime : return DbType.DateTime;
case SqlDbType.Decimal : return DbType.Decimal;
case SqlDbType.Float : return DbType.Double;
case SqlDbType.Image : return DbType.Binary;
case SqlDbType.Int : return DbType.Int32;
case SqlDbType.Money : return DbType.Currency;
case SqlDbType.NChar : return DbType.StringFixedLength;
case SqlDbType.NText : return DbType.String;
case SqlDbType.NVarChar : return DbType.String;
case SqlDbType.Real : return DbType.Single;
case SqlDbType.UniqueIdentifier : return DbType.Guid;
case SqlDbType.SmallDateTime : return DbType.DateTime;
case SqlDbType.SmallInt : return DbType.Int16;
case SqlDbType.SmallMoney : return DbType.Currency;
case SqlDbType.Text : return DbType.AnsiString;
case SqlDbType.Timestamp : return DbType.Binary;
case SqlDbType.TinyInt : return DbType.Byte;
case SqlDbType.VarBinary : return DbType.Binary;
case SqlDbType.VarChar : return DbType.AnsiString;
case SqlDbType.Variant : return DbType.Object;
default : throw ExceptionHelper.InvalidSqlDbType((int)sqlDbType);
}
}