[IBATISNET-269] Show NVelocity Dynamic SQL syntax support

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: DataMapper 3.0
• Fix Version/s: DataMapper 3.0
• Component/s: DataMapper
• Assignee: Gilles Bayon
• Reporter: Gilles Bayon
• Due: 03/Jun/08
• Created: 03/Jun/08 19:53
• Updated: 05/Jun/08 20:08
• Resolved: 05/Jun/08 20:08

Description

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);