mysql + .NET连接器:"Column 'CharacterID'不能为空

我正在尝试使用。net连接器插入一些数据到我的MySql数据库。

存储过程如下:

CREATE PROCEDURE `spr_StoreMoveData2`(IN `@characterID` INT, IN `@moveName` VARCHAR(1000), IN `@validBlocks` VARCHAR(50), IN `@damage` VARCHAR(500), IN `@stun` VARCHAR(500), IN `@cancelAbility` VARCHAR(50), IN `@framesStartup` VARCHAR(500), IN `@framesActive` VARCHAR(500), IN `@framesRecovery` VARCHAR(500), IN `@framesAdvOnHit` VARCHAR(500), IN `@framesAdvOnBlock` VARCHAR(500), IN `@additionalNotes` VARCHAR(5000))
    LANGUAGE SQL
    NOT DETERMINISTIC
    MODIFIES SQL DATA
    SQL SECURITY DEFINER
    COMMENT 'test'
BEGIN
INSERT INTO movedata 
(characterid, movename, validblocks, damage, stun, supermetergain,cancelability, framesStartup, framesActive, framesRecovery, framesAdvOnHit, framesAdvOnBlock, AdditionalNotes) 
VALUES 
(@characterID, @moveName, @validBlocks, @damage, @stun, @superMeterGain, @cancelAbility, @framesStartup, @framesActive, @framesRecovery, @framesAdvOnHit, @framesAdvOnBlock, @additionalNotes);
END

这似乎保存得很好。

我的。net代码如下:

 using (MySqlConnection conn = new MySqlConnection())
                {
                    conn.ConnectionString = ConfigurationManager.AppSettings["connectionString"].ToString();
                    conn.Open();
                    MoveData move1 = lmd[0];
                    MySqlCommand cmd = new MySqlCommand("spr_StoreMoveData", conn);
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.AddWithValue("CharacterID", move1.CharacterID);
                    cmd.Parameters.AddWithValue("movename", move1.MoveName);
                    cmd.Parameters.AddWithValue("validblocks", move1.ValidBlocks);
                    cmd.Parameters.AddWithValue("damage", move1.Damage);
                    cmd.Parameters.AddWithValue("stun", move1.Stun);
                    cmd.Parameters.AddWithValue("supermetergain", move1.SuperMeterGain);
                    cmd.Parameters.AddWithValue("cancelability", move1.CancelAbility);
                    cmd.Parameters.AddWithValue("framesstartup", move1.Frames_Startup);
                    cmd.Parameters.AddWithValue("framesactive", move1.Frames_Active);
                    cmd.Parameters.AddWithValue("framesrecovery", move1.Frames_Recovery);
                    cmd.Parameters.AddWithValue("framesAdvOnHit", move1.Frames_AdvantageOnHit);
                    cmd.Parameters.AddWithValue("framesAdvOnBlock", move1.Frames_AdvantageOnBlock);
                    cmd.Parameters.AddWithValue("additionalNotes", move1.AdditionalNotes);
                    cmd.ExecuteNonQuery();
                    cmd.Dispose();
                    cmd = null;
                }

如果我使用这个，或者如果我使用以下测试查询

call spr_StoreMoveData (1, '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1')

出现错误"Column 'CharacterID' cannot be null"。我将列设置为允许空值，并将插入一行，其中包含所有空值。我有点困惑。

我试着在网上看了所有的答案，但我似乎错过了一些语法的微妙之处。有人能帮忙吗?