[ http://issues.apache.org/jira/browse/IBATISNET-109?page=all ]
Ron Grabowski resolved IBATISNET-109:
-------------------------------------
Resolution: Duplicate
Fixed in IBATISNET-120
> Allow use of built-in magic numbers (int.MinValue, DateTime.MaxValue) for
> nullValues with nullValueTypeProperty
> ---------------------------------------------------------------------------------------------------------------
>
> Key: IBATISNET-109
> URL: http://issues.apache.org/jira/browse/IBATISNET-109
> Project: iBatis for .NET
> Type: Improvement
> Reporter: Ron Grabowski
> Priority: Trivial
>
> Instead of having to specify a known value for a nullValue:
> <parameter property="EmailAddress" type="string" nullValue="[EMAIL
> PROTECTED]" column="EMAIL" />
> It would be nice to use the magic values built into the Framework:
> string.Empty
> int.MinValue
> int.MaxValue
> DateTime.MinValue
> DateTime.MaxValue
> etc...
> Using syntax like this means I don't have to embed the magic string "[EMAIL
> PROTECTED]" into my application:
> <parameter property="EmailAddress" type="string"
> nullValueTypeProperty="Empty" column="EMAIL" />
> int.MinValue is a static const and DateTime.MinValue is a static readonly so
> I don't know if property would be the correct wording. Is there a more
> general term for properties, fields, public constants, etc?
> <parameter property="EmailAddress" type="string" nullValueTypeMember="Empty"
> column="EMAIL" />
> nullValueTypeMember should be shorter too...
> An alternative approach (I like this idea more) would be to ship IBatisNet
> with things like:
> StringEmptyNullValueTypeHandler
> DateTimeMaxValueNullValueTypeHandler
> DateTimeMinValueNullValueTypeHandler
> Int32MinValueNullValueTypeHandler
> Int32MaxValueNullValueTypeHandler
> They would have a dual purpose of inserting a null value when a string.Empty
> or an int.MinValue were encountered as well as setting a property to
> string.Empty or int.MinValue when a NULL is returned from the database.
> <!-- insert NULL if EmailAddress is the empty string -->
> <parameter property="EmailAddress" column="EMAIL_ADDRESS"
> handler="StringEmptyNullValueTypeHandler" />
> <!-- set ExpirationDate to DateTime.MaxValue if the database returns NULL -->
> <result property="ExpirationDate" column="EXPIRATION_DATE"
> handler="DateTimeMaxValueNullValueTypeHandler" />
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
