private OracleType GetMappedDBType(ProcedureParameter.DBType dbType)
{
switch (dbType)
{
case ProcedureParameter.DBType.Bit:
throw new Exception("Bit不能用于Oracle");
case ProcedureParameter.DBType.Char:
return(OracleType.Char);
case ProcedureParameter.DBType.VarChar:
return(OracleType.VarChar);
case ProcedureParameter.DBType.NVarChar:
return(OracleType.NVarChar);
case ProcedureParameter.DBType.NClob:
return(OracleType.NClob);
case ProcedureParameter.DBType.Float:
return(OracleType.Number);
case ProcedureParameter.DBType.Int:
return(OracleType.Int16);
case ProcedureParameter.DBType.BigInt:
return(OracleType.Int32);
case ProcedureParameter.DBType.Date:
case ProcedureParameter.DBType.DateTime:
return(OracleType.DateTime);
case ProcedureParameter.DBType.Cursor:
return(OracleType.Cursor);
default:
return(OracleType.NVarChar);
}
}
private SqlDbType GetMappedDBType(ProcedureParameter.DBType dbType)
{
switch (dbType)
{
case ProcedureParameter.DBType.Bit:
return(SqlDbType.Bit);
case ProcedureParameter.DBType.Char:
return(SqlDbType.Char);
case ProcedureParameter.DBType.VarChar:
return(SqlDbType.VarChar);
case ProcedureParameter.DBType.NVarChar:
return(SqlDbType.NVarChar);
case ProcedureParameter.DBType.Float:
return(SqlDbType.Float);
case ProcedureParameter.DBType.Int:
return(SqlDbType.Int);
case ProcedureParameter.DBType.BigInt:
return(SqlDbType.BigInt);
case ProcedureParameter.DBType.Date:
return(SqlDbType.Date);
case ProcedureParameter.DBType.DateTime:
return(SqlDbType.DateTime);
case ProcedureParameter.DBType.Cursor:
throw new Exception("Cursor不能用于SqlServer");
default:
return(SqlDbType.NVarChar);
}
}
