internal static int SqlDbTypeToJdbcType(SqlDbType sqlDbType)
{
switch(sqlDbType) {
case SqlDbType.BigInt : return Types.BIGINT;
case SqlDbType.Binary : return Types.BINARY;
case SqlDbType.Bit : return Types.BIT;
case SqlDbType.Char : return Types.CHAR;
case SqlDbType.DateTime : return Types.TIMESTAMP;
case SqlDbType.Decimal : return Types.DECIMAL;
case SqlDbType.Float : return Types.FLOAT;
case SqlDbType.Image : return Types.LONGVARBINARY;
case SqlDbType.Int : return Types.INTEGER;
case SqlDbType.Money : return Types.DECIMAL;
case SqlDbType.NChar : return Types.CHAR;
case SqlDbType.NText : return Types.LONGVARCHAR;
case SqlDbType.NVarChar : return Types.VARCHAR;
case SqlDbType.Real : return Types.REAL;
case SqlDbType.UniqueIdentifier : return Types.CHAR;
case SqlDbType.SmallDateTime : return Types.DATE;
case SqlDbType.SmallInt : return Types.SMALLINT;
case SqlDbType.SmallMoney : return Types.DECIMAL;
case SqlDbType.Text : return Types.LONGVARCHAR;
case SqlDbType.Timestamp : return Types.TIMESTAMP;
case SqlDbType.TinyInt : return Types.TINYINT;
case SqlDbType.VarBinary : return Types.VARBINARY;
case SqlDbType.VarChar : return Types.VARCHAR;
case SqlDbType.Variant : return Types.VARCHAR; // note : ms jdbc driver recognize this sqlserver as varchar
default : throw ExceptionHelper.InvalidSqlDbType((int)sqlDbType);
}
}