This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
How to work with specific data types. Imagine, I have oracle table with column which datatype is "Interval day to second". Mindscape designer suggests use System.Object as type for entity propertie. How will Lightspeed convert System.Object to value while preparing SQL Query to oracle, by using ToString()? |
|
|
|
|
System.Object is our default placeholder for "we don't recognise this column type" -- it's not something you really want to be using. Instead, you can map a custom data type, whether one defined by Oracle or by yourself. If the Oracle ADO.NET driver surfaces the column as the desired property type, then you just need to reference the data type via Add New User-Defined Type; if you need to convert from the native Oracle driver to your desired type, then you'll need to specify a custom field converter. For information about how to do this, see http://www.mindscape.co.nz/blog/index.php/2010/08/22/ninja-data-type-mappings-in-lightspeed/ (note that you don't need to define an IFieldConverter or fill in the Converter Type box if you're using a data type defined by the Oracle ADO.NET provider). |
|
|
|
