ado.net ExecuteNonQuery参数不为空导致参数为空异常

EDIT使用实体框架/EDIT

目前我有一个神秘的问题与ADO。. Net和Sybase SQL Anywhere(版本16.0.0.21584)。如果我试图在一个过程上写一个长varchar到数据库(大约80MB)， ExecuteNonQuery在参数名称desintation处抛出异常The value cannot be NULL。问题是，没有参数为空，也没有参数命名为desintation。在执行过程之前，我已经将所有值写入文件系统，为了调试系统，所有文件都有一个内容，所以这里没有null。

还有一件事，如果我写更小的数据到数据库，一切都很好。

程序如下:

ALTER PROCEDURE "admin"."DCS_SQLI_PARM_SetKeyValue"( 
  in @in_lvc_parmName long varchar,
  in @in_bint_workflowID bigint default null,
  in @in_bint_contentID bigint default null,
  in @in_lvc_parm_value long varchar ) 
begin
  declare @bint_id bigint;
  set @bint_id = ISNULL((select ID from DCS_INPUT_Parameter_KeyValue
      where parameter_name = @in_lvc_parmName and ISNULL(ContentID,0) = ISNULL(@in_bint_contentID,0) and WorkflowID = @in_bint_workflowID),
    GET_IDENTITY('DCS_INPUT_Parameter_KeyValue',1));
  insert 
into DCS_INPUT_Parameter_KeyValue
    ( ID,
    parameter_name,
    parameter_value,
    ContentID,
    WorkflowID ) on existing update defaults off values
    ( @bint_id,
    @in_lvc_parmName,
    @in_lvc_parm_value,
    @in_bint_contentID,
    @in_bint_workflowID ) 
end

这个方法正在执行过程:

public static void ExecuteProcedure(string SqlStatement, string ConnectionName, params object[] Parameter)
{
    SAConnection cConnection = DAL.ConnectionManager.GetOpenPoolConnection<SAConnection>(Connection: ConnectionName);
    try
    {
        SACommand cCommand = new SACommand(SqlStatement, cConnection);
        cCommand.CommandType = CommandType.StoredProcedure;
        if (Parameter != null)
        {
            foreach (var cParam in Parameter)
            {
                cCommand.Parameters.Add(new SAParameter() { Value = cParam });
            }
        }
        cCommand.ExecuteNonQuery();
    }
    catch (Exception ex)
    {
        if (UserRightManager.UserHasRightsFrom(0))
        {
            if (System.Environment.UserInteractive)
            {
                MessageBox.Show("SQL-Text: " + SqlStatement + "'r'n" + ex.ToString(), "SQL-Error", MessageBoxButton.OK, MessageBoxImage.Warning);
            }
        }
        else
        {
            if (System.Environment.UserInteractive)
            {
                MessageBox.Show("--- --- --- ---.", "SQL-Fehler", MessageBoxButton.OK, MessageBoxImage.Warning);
            }
        }
        if (cConnection != null)
        {
            if (cConnection.State != ConnectionState.Closed)
            {
                cConnection.Close();
            }
        }
        Base.ExceptionHandling.Write("Error during executing a procedure", Foundation.ExceptionLevel.Error, ex, SqlStatement);
        throw new Exception("Error in ExecuteProcedure", ex);
    }
    cConnection.Close();
}

ExecuteProcedure方法是非常旧的，必须重写，但这应该不会导致当前的问题。

编辑使用Entity-Framework会导致相同的错误:

public void SetParameter(string parameterName, object parameterValue)
{
    try
    {
        //Simplic.PlugIn.DocCenterServer.AS.Core.DB.Database.Instance.ExecuteProcedure("DCS_SQLI_PARM_SetKeyValue", new object[] { parameterName, this.wf.ID, this.ID, parameterValue }); 
        using (FrameworkDbContext dbContext = new FrameworkDbContext())
        {
            // Get Existing id
            var entry = dbContext.DCS_INPUT_Parameter_KeyValue.Where(item => item.Parameter_name == parameterName && item.WorkflowID == this.wf.ID && item.ContentID == this.ID)
                    .FirstOrDefault();
            if (entry == null)
            {
                DCS_INPUT_Parameter_KeyValue value = new DCS_INPUT_Parameter_KeyValue();
                value.Parameter_name = parameterName;
                value.Parameter_value = parameterValue == null ? "" : parameterValue.ToString();

      value.ContentID = this.ID;
                    value.WorkflowID = this.wf.ID;
                    dbContext.DCS_INPUT_Parameter_KeyValue.Add(value);
                    var size = value.Parameter_value.Length;
                    Console.WriteLine("Parameter-Size: " + size.ToString());
                    dbContext.SaveChanges();
                }
                else
                {
                    entry.Parameter_name = parameterName;
                    entry.Parameter_value = parameterValue == null ? null : parameterValue.ToString();
                    dbContext.SaveChanges();
                }
            }
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.ToString());
        }
    }

编辑2 从long varchar切换到long binary似乎可以解决这个问题。

有谁知道是什么问题吗?

谢谢。