DevForce Community Forum : Datatype Conversion http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Datatype Conversion Mon, 13 Apr 2026 00:09:07 -700 Mon, 13 Feb 2012 08:59:12 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=3260 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Datatype Conversion : Hi SandLink,Regarding your... http://www.ideablade.com/forum/forum_posts.asp?TID=3260&PID=12656#12656 Author: sbelini
Subject: 3260
Posted: 13-Feb-2012 at 8:59am

Hi SandLink,
 
Regarding your NUMBER(1,0) type the only way I could see the 'conversion' is to actually have a custom property (boolean) that would assign/retrieve (i.e. via property interceptor) the proper int value (after all the field is of int type even though it only takes 0s and 1s).
 
As for empty strings, you can set ShouldTreatEmptyStringAsNull to false:
 
myEM.VerifierEngine.DefaultVerifierOptions.ShouldTreatEmptyStringAsNull = false;
 
Regards,
   Silvio.
]]> Mon, 13 Feb 2012 08:59:12 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3260&PID=12656#12656 Datatype Conversion : I have a legacy DB running on... http://www.ideablade.com/forum/forum_posts.asp?TID=3260&PID=12648#12648 Author: SandLink
Subject: 3260
Posted: 11-Feb-2012 at 10:06am

I have a legacy DB running on Oracle which has a few specific internal data representations which need to be converted into more standard data types in my entities. To whit:
Booleans are represented as 0 or 1, which is a NUMBER1. The designer maps the values as Int16, and throws an exception when I want to use an Boolean.
Empty strings in Oracle are represented as single space strings, while an empty string '' is NULL.
What I need is to be able to convert from the DB representation to a CLR representation in the mapping layer, but I can't find any information as to any available handles for this.
Apart from costly workarounds like duplicating all my properties, are there any elegant solutions to the problem?]]> Sat, 11 Feb 2012 10:06:11 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3260&PID=12648#12648