System.Data.SqlClient.SqlConvert.SqlDbTypeToJdbcType C# (CSharp) Method

		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);
			}
		}

 protected internal sealed override int JdbcTypeFromProviderType()
 {
     return(SqlConvert.SqlDbTypeToJdbcType(SqlDbType));
 }