/// <summary>
/// Converts the given DbType to an OracleDbType.
/// </summary>
/// <param name="dbType">The type to be converted.</param>
/// <returns>The converted Type.</returns>
private static OracleDbType DbTypeToOracleDbType(Database.DbType dbType)
{
switch (dbType)
{
case Database.DbType.BIT:
return(OracleDbType.Decimal);
case Database.DbType.CHAR:
return(OracleDbType.Char);
case Database.DbType.DATE:
return(OracleDbType.Date);
case Database.DbType.DATETIME:
return(OracleDbType.TimeStamp);
case Database.DbType.DECIMAL:
return(OracleDbType.Decimal);
case Database.DbType.VARCHAR:
return(OracleDbType.Varchar2);
}
return(OracleDbType.Varchar2);
}
/// <summary>
/// Converts the given DbType to a SqlDbType.
/// </summary>
/// <param name="dbType">The type to be converted.</param>
/// <returns>The converted Type.</returns>
private static SqlDbType DbTypeToSqlDbType(Database.DbType dbType)
{
switch (dbType)
{
case Database.DbType.BIT:
return(SqlDbType.Bit);
case Database.DbType.CHAR:
return(SqlDbType.Char);
case Database.DbType.DATE:
return(SqlDbType.Date);
case Database.DbType.DATETIME:
return(SqlDbType.DateTime2);
case Database.DbType.DECIMAL:
return(SqlDbType.Decimal);
case Database.DbType.VARCHAR:
return(SqlDbType.VarChar);
}
return(SqlDbType.VarChar);
}