DynInsParameter of dynamic insert does not be disabled by null value setting. about opentouryo

[daisukenishino]

Additinal information

Under the circumstances, "DaoGen_Tool" generates the sql statement as follows.

<?xml version="1.0" encoding="UTF-8" ?>
<ROOT>
-- DaoCategories_D1_Insert
-- 2013/1/10 日立 太郎
INSERT INTO 
  [Categories]
    (
      <DELCMA>
        <INSCOL name="CategoryID">[CategoryID],</INSCOL>
        <INSCOL name="CategoryName">[CategoryName],</INSCOL>
        <INSCOL name="Description">[Description],</INSCOL>
        <INSCOL name="Picture">[Picture],</INSCOL>
      </DELCMA>
    )
VALUES
    (
      <DELCMA>
        <IF>@CategoryID,</IF>
        <IF>@CategoryName,</IF>
        <IF>@Description,</IF>
        <IF>@Picture,</IF>
      </DELCMA>
    )
</ROOT>

For example, if the user substitutes null value for parameter "@CategoryID", the exception occurs. This is because ELSE tag does not exist in IF tag. Therefore, please revise "DaoGen_Tool" to generate ELSE tag in IF tag.

Check situations

And, please perform an operation check in the following two situations.

• "timestamp" column exists in the table.
• "timestamp" column does not exist in the table.

Check Items

• Does modified "DaoGen_Tool" generate ELSE tag normally?
• When you substitute various value for parameter, does modified "DaoGen_Tool" return expected result?

Example 1

• You substitute non-null value for all parameters.
  (I expect that non-null value is inserted in all columns.)

Example 2

• You substitute DBNull.Value for some parameters.
  (I expect that null value is inserted in the columns.)

Example 3

• You substitute null value for some parameters.
  (I expect that default value of the columns is inserted in the columns. And the information of the column does not appear in generated "INSERT statement".)