[ 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.