SubSonic 抛出“System.IndexOutOfRangeException”当处于 Visual Studio 调试模式时

发布于 2024-12-09 07:29:01 字数 1678 浏览 2 评论 0原文

我最近继承了我现在拥有的产品的代码集，该产品使用 Subsonic 2.1.0 来执行其数据访问。

当我进入调试所述代码集时，我在 Visual Studio 2010 的“输出”窗口中得到的所有内容如下（对于尝试加载的每个对象的几乎每一列）

A first chance exception of type 'System.IndexOutOfRangeException' occurred in System.Data.dll

：在 Subsonic 中，它位于 SubSonic.RecordBase 类中，看起来像这样：

/// <summary>
    /// Loads the object with the current reader's values. Assumes the reader is already moved to
    /// first position in recordset (aka has been "Read()")
    /// </summary>
    /// <param name="dataReader">The data reader.</param>
    public virtual void Load(IDataReader dataReader)
    {
        foreach(TableSchema.TableColumn col in BaseSchema.Columns)
        {
            try
            {
                SetColumnValue(col.ColumnName, dataReader[col.ColumnName]);
            }
            catch(Exception)
            {
                // turning off the Exception for now
                // to support partial loads

                // throw new Exception("Unable to set column value for " + col.ColumnName + ": " + x.Message);
            }
        }

        SetLoadState();
        MarkClean();
    }

其中有问题的行是：

 SetColumnValue(col.ColumnName, dataReader[col.ColumnName]);

col.ColumnName 此时与 dataReader 中的任何内容都不匹配。这几乎就像它正在使用旧的/之前的 dataReader 来尝试从中提取数据。

我希望其他人也遇到过这个问题，因为我对 Subsonic 还很陌生，并且过去只使用 Hibernate 进行 ORM。

这种情况发生在我的旧机器和我刚刚构建的新机器上，它们都运行 Windows 7 Professional x64，并使用 Visual Studio 2010 Professional 作为 IDE。

我浏览了论坛、谷歌和许多其他网站，但尚未发现其他人遇到此问题。

如果需要更多信息，请告诉我，我很乐意发帖！

提前致谢！

贾斯汀

原文

I recently inherited the code set for a Product I now own which uses Subsonic 2.1.0 to perform its data-access.

When I go in to debug said code set, all that I get in the Output window of Visual Studio 2010 is the following (for pretty much every column of every object trying to be loaded):

A first chance exception of type 'System.IndexOutOfRangeException' occurred in System.Data.dll

This is the block of code where it is blowing up in Subsonic, which is located in the SubSonic.RecordBase class, which looks like so:

/// <summary>
    /// Loads the object with the current reader's values. Assumes the reader is already moved to
    /// first position in recordset (aka has been "Read()")
    /// </summary>
    /// <param name="dataReader">The data reader.</param>
    public virtual void Load(IDataReader dataReader)
    {
        foreach(TableSchema.TableColumn col in BaseSchema.Columns)
        {
            try
            {
                SetColumnValue(col.ColumnName, dataReader[col.ColumnName]);
            }
            catch(Exception)
            {
                // turning off the Exception for now
                // to support partial loads

                // throw new Exception("Unable to set column value for " + col.ColumnName + ": " + x.Message);
            }
        }

        SetLoadState();
        MarkClean();
    }

The offending line in there is:

 SetColumnValue(col.ColumnName, dataReader[col.ColumnName]);

col.ColumnName doesn't match anything in the dataReader at this point. It's almost like it's using an old/prior dataReader to attempt to pull data from.

I'm hoping someone else has encountered this issue, as I'm still fairly new to Subsonic and have only used Hibernate in the past for an ORM.

This happens on both my older machine and a new one I just built, both running Windows 7 Professional x64 w/ Visual Studio 2010 Professional as the IDE.

I've gone through the forums, Google, and many other sites out there, but have yet to find anyone else encountering this issue.

If more information is required, please let me know and I'll be happy to post!

Thanks in advance!