[
https://issues.apache.org/jira/browse/IBATISNET-267?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12601386#action_12601386
]
Gilles Bayon commented on IBATISNET-267:
----------------------------------------
This only work if you uses new inline parameter syntax with new attribute column
@{propertyName,column=string,type=string,dbype=string,direction=[Input/Output/InputOutput],nullValue=string,handler=string}
> Support inline paramaters and dynamic element in procedure tag
> --------------------------------------------------------------
>
> Key: IBATISNET-267
> URL: https://issues.apache.org/jira/browse/IBATISNET-267
> Project: iBatis for .NET
> Issue Type: Improvement
> Components: DataMapper
> Affects Versions: DataMapper 3.0
> Reporter: Gilles Bayon
> Assignee: Gilles Bayon
> Fix For: DataMapper 3.0
>
>
> Samples
> ========
> <procedure id="SPWithInlineParameter" parameterClass="int"
> resultClass="Account">
> ps_SelectAccount @{Account_ID,column=Account_ID}
> </procedure>
> <procedure id="SPWithInlineParameterAndOutPutParam" parameterClass="map"
> resultClass="Account">
> ps_SelectAccountWithOutPutParam @{Account_ID,column=Account_ID},
> @{OutPut,column=OutPut}
> </procedure>
> <procedure id="InsertAccountViaSPAndInlineParameter" parameterClass="map"
> >
> ps_InsertAccount
> @{Id,column=Account_ID},
> @{FirstName,column=Account_FirstName},
> @{LastName,column=Account_LastName},
> @{EmailAddress,column=Account_Email,[EMAIL PROTECTED],
> @{BannerOption,column=Account_Banner_Option,dbType=Varchar,type=bool},
> @{CartOption,column=Account_Cart_Option,handler=HundredsBool}
> </procedure>
> <procedure id="InsertAccountViaSPWithDefaultParameter"
> parameterClass="map" >
> ps_InsertAccountWithDefault
> @{Id,column=Account_ID},
> @{FirstName,column=Account_FirstName},
> @{LastName,column=Account_LastName},
> @{EmailAddress,column=Account_Email,[EMAIL PROTECTED]
> </procedure>
> <procedure id="InsertAccountViaSPWithDynamicParameter"
> parameterClass="map" >
> ps_InsertAccountWithDefault
> @{Id,column=Account_ID}
> ,@{FirstName,column=Account_FirstName}
> ,@{LastName,column=Account_LastName}
> ,@{EmailAddress,column=Account_Email,[EMAIL PROTECTED]
> <isNotNull property="NullBannerOption">
>
> ,@{NullBannerOption,column=Account_Banner_Option,dbType=Varchar,type=bool}
> </isNotNull>
> @{CartOption,column=Account_Cart_Option,handler=HundredsBool}
> </procedure>
> Can be use in conjunction with procedure default parameter
> REATE PROCEDURE dbo.[ps_InsertAccountWithDefault]
> @Account_ID [int],
> @Account_FirstName [nvarchar](40),
> @Account_LastName [varchar](32),
> @Account_Email [varchar](128),
> @Account_Banner_Option [varchar](255)='Non',
> @Account_Cart_Option [int] =200
> AS
> ...
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
