public static SqlDbType SQL(WMSDBType pWMSDBType)
{
switch (pWMSDBType)
{
case WMSDBType.BLOB:
return SqlDbType.Text;
case WMSDBType.BYTE:
return SqlDbType.Bit;
case WMSDBType.CHAR:
return SqlDbType.Char;
case WMSDBType.DATE:
return SqlDbType.Date;
case WMSDBType.DATETIME:
return SqlDbType.DateTime;
case WMSDBType.DOUBLE:
case WMSDBType.DECIMAL:
return SqlDbType.Decimal;
case WMSDBType.INT16:
case WMSDBType.INT32:
case WMSDBType.INT64:
return SqlDbType.Int;
case WMSDBType.LONG:
return SqlDbType.BigInt;
case WMSDBType.NCHAR:
return SqlDbType.NChar;
case WMSDBType.TIMESTAMP:
return SqlDbType.Timestamp;
case WMSDBType.VARCHAR2:
return SqlDbType.VarChar;
case WMSDBType.XMLTYPE:
return SqlDbType.Xml;
default:
throw new Exception("SQLType inválido");
}
}
public static SqlDbType SQL(WMSDBType pWMSDBType)
{
switch (pWMSDBType)
{
case WMSDBType.BLOB:
return(SqlDbType.Text);
case WMSDBType.BYTE:
return(SqlDbType.Bit);
case WMSDBType.CHAR:
return(SqlDbType.Char);
case WMSDBType.DATE:
return(SqlDbType.Date);
case WMSDBType.DATETIME:
return(SqlDbType.DateTime);
case WMSDBType.DOUBLE:
case WMSDBType.DECIMAL:
return(SqlDbType.Decimal);
case WMSDBType.INT16:
case WMSDBType.INT32:
case WMSDBType.INT64:
return(SqlDbType.Int);
case WMSDBType.LONG:
return(SqlDbType.BigInt);
case WMSDBType.NCHAR:
return(SqlDbType.NChar);
case WMSDBType.TIMESTAMP:
return(SqlDbType.Timestamp);
case WMSDBType.VARCHAR2:
return(SqlDbType.VarChar);
case WMSDBType.XMLTYPE:
return(SqlDbType.Xml);
default:
throw new Exception("SQLType inválido");
}
}
