https://www.codetrigger.com/forum/topic18-oracle-number-column-used-for-id-column.aspx CodeTrigger - General - Oracle Number(31) column used for ID column - Messages en-us http://blogs.law.harvard.edu/tech/rss Jitbit AspNetForum Mon, 04 Dec 2017 13:48:37 GMT Mon, 04 Dec 2017 13:48:37 GMT https://www.codetrigger.com/forum/topic18-oracle-number-column-used-for-id-column.aspx Release 4.8.6.2 (June 2016)
Added Support for non native Boolean field representation for Oracle - using Number(1) convention
Added support for Identity Fields in Oracle 12+
edited by migrator on 12/4/2017]]> Mon, 04 Dec 2017 13:48:37 GMT https://www.codetrigger.com/forum/topic18-oracle-number-column-used-for-id-column.aspx If you look in the generated Data Access Base Class: XXXXBaseData.Cs, you will see a section called BoxRowValue. This is where some special processing is placed to handle Number(1). The function is designed for such cases, so I think the best approach might be to look at that function and make some changes in there to handle Number(31). Might be best to just write a safe convert to decimal in that function for the Number(31) case. Please let me know how you get on as we would be very interested in this UseCase.


#region oracle parameter helpers
protected static object BoxRowValue(object value, string entityName, string fieldName)
{
//write any necessary conversion code
if(entityName == "sometablename" && fieldName == anumber31fieldName) return mySafeConvertFunction(value);

//for eg change up from NUMBER(1) to boolean if required
return (object)(value != null ? ((short)value != 0) : default(bool));
}

protected virtual object UnboxOracleParam(OracleParameter oracleParam, string entityName)
{
...
...
}]]> Mon, 04 Dec 2017 13:44:55 GMT https://www.codetrigger.com/forum/topic18-oracle-number-column-used-for-id-column.aspx PeopleSoft tables contain Number(31) columns that it uses for “ID” type columns. CodeTrigger treats these as .Net decimal types which causes data overflow issues in the business layer. One of the approaches we have used with these colums is to apply Oracle to_char functions and treat them as strings. Can something like this be done with CodeTrigger?]]> Mon, 04 Dec 2017 13:44:27 GMT