[jira] Commented: (IBATISNET-269) Show NVelocity Dynamic SQL syntax support

["Gilles Bayon (JIRA)" <ib...@incubator.apache.org>]

    [ https://issues.apache.org/jira/browse/IBATISNET-269?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12602048#action_12602048 ] 

Gilles Bayon commented on IBATISNET-269:
----------------------------------------

Used Castle NVelocity 
http://www.castleproject.org/others/nvelocity/index.html

> Show NVelocity Dynamic SQL syntax support
> -----------------------------------------
>
>                 Key: IBATISNET-269
>                 URL: https://issues.apache.org/jira/browse/IBATISNET-269
>             Project: iBatis for .NET
>          Issue Type: New Feature
>          Components: DataMapper
>    Affects Versions: DataMapper 3.0
>            Reporter: Gilles Bayon
>            Assignee: Gilles Bayon
>             Fix For: DataMapper 3.0
>
>
> Paremeters should be typeof  IDictionary<string, object>
> Samples
> =======
>     <!-- Nvelocity dynamic source -->
>     <select id="NVelocity.Simple" sqlSource="NVelocitySqlSource" resultMap="account-result" parameterClass="map">
>       select * from Accounts where Account_Id= $account.id
>     </select>
>     <select id="NVelocity.If" sqlSource="NVelocitySqlSource" resultClass="Account" remapResults="true" parameterClass="map">
>       SELECT
>       Account_ID as Id,
>       #if($account.FirstName == "Joe")
>       Account_FirstName as FirstName,
>       #elseif($account.LastName == "Dalton")
>       Account_LastName as LastName,
>       #end
>       Account_Email as EmailAddress
>       FROM
>       Accounts
>       where Account_Id= $account.id
>     </select>
> Use as usual
>             IDictionary<string, object> parameters = new Dictionary<string, object>();
>             parameters.Add("account", paramAccount);
>             Account account = dataMapper.QueryForObject<Account>("NVelocity.Simple", parameters);

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.