Hello. I want to execute MS SQL procedure with optional parameters. Tell me please - how parameter map should looks to make it possible. AFAIU procedure statement should contain only procedure name or it is possible to list all paramaters with commas?
Could I write something like <parameterMap> <parameter property="prop1" column="param1"/> <parameter property="prop2" column="param2"/> <parameter property="prop3" column="param3"/> <parameter property="prop4" column="param4"/> </parameterMap> <procedure id="TestProcedure" parameterMap="TestProcedureParams"> TestProcedure #param1#, #param2#, #param3#, , , #param4# </procedure> I don't want add unnecessary properties to my objects. -- С уважением, Алексей Бородай Отдел разработки ПО ___________________________________________________________________________ This communication is confidential and may be legally privileged. If you believe you are not an intended recipient, please inform the sender, delete the e-mail and do not copy, print or use it or disclose it to others. You can inform the sender by replying to this e-mail or by telephone (+380 44 4906080).
