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.