Ibatis.net with oracle batch delete implementation code
- 2020-05-19 04:28:55
- OfStack
The string to delete is ID
Define 1 public Array SDSALES_IDs {get; set; }
XML:
string SDSALES_IDString = 1,2,3,4,5,6,7
// into Array
Array array = SDSALES_IDString.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries).ToArray<string>();
Define 1 public Array SDSALES_IDs {get; set; }
XML:
<delete id="DeleteManyT_LABEL_SDSALES" parameterClass="T_LABEL_SDSALES">
DELETE FROM T_LABEL_SDSALES WHERE
<isNotNull property="SDSALES_IDs">
SDSALES_ID IN
<iterate property="SDSALES_IDs" conjunction="," open="(" close=")">
#SDSALES_IDs[]#
</iterate>
</isNotNull>
</delete>