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.
