[
https://issues.apache.org/jira/browse/IBATISNET-269?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gilles Bayon closed IBATISNET-269.
----------------------------------
Resolution: Fixed
In SVN
It's also allowed to change the iBATIS Dynamic SQL engine via code
configuration, see the property DynamicSqlEngine on ConfigurationSetting
> 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.
