[IBATISNET-268] Add support to Dynamic SQL via code

• 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: 01/Jun/08
• Created: 01/Jun/08 10:23
• Updated: 01/Jun/08 10:31
• Resolved: 01/Jun/08 10:31

Description

Add attribute sqlSource on statement tag, a type alias to a user class which implement interface ISqlSource

Sample
======
<select id="SqlSourceWithInlineParameter" parameterClass="Integer" sqlSource="SqlSourceWithInlineParameter" resultMap="account-result"/>

public class SqlSourceWithInlineParameter : ISqlSource
{
#region ISqlSource Members

/// <summary>
/// Gets the SQL text.
/// </summary>
/// <param name="mappedStatement">The mapped statement.</param>
/// <param name="parameterObject">The parameter object.</param>
/// <returns></returns>
public string GetSql(IMappedStatement mappedStatement, object parameterObject)
{
return "select * from Accounts where Account_ID = @

{Id}

";
}

#endregion
}