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.

Reply via email to