不支持关键字 MultipleActiveResultSets

发布于 2024-08-22 22:46:37 字数 1675 浏览 10 评论 0原文

我们在 ASP.NET MVC 应用程序中使用自定义成员资格提供程序。我们一直遇到间歇性的“System.InvalidOperationException - 已经有一个与此命令关联的打开的 DataReader，必须先将其关闭。”课程出现问题，所以我决定启用 MARS。

这是 Web 配置中的连接字符串...

<add name="CustomMembershipServices" connectionString="User ID=CUSTOM_USER;Password=pwd;Database=OUR_DB;Server=.\SQLEXPRESS;MultipleActiveResultSets=true;" providerName="System.Data.SqlClient" />

我们的代码现在在下一行抛出 ArgumentException: Keyword not support: 'multipleactiverecordsets'。

protected void CreateAndOpenConnection()
{
    // Exception thrown here...
    _connection = new SqlConnection(_connectionString);
    _connection.Open();
}

针对 SQL2005 Express 和 SQL2008 Standard 版本时会出现相同的异常。有什么建议吗？

为了响应 AdaTheDev，这里是使用数据读取器的方法...

public bool CheckUserPassword(long userID, string password)
{
    bool success = false;

    if (!string.IsNullOrEmpty(password))
    {
        try
        {
            CreateAndOpenConnection();

            using (SqlCommand cmd = CreateSqlCommandForStoredProcedure("CheckPassword"))
            {
                IPasswordUtility generator = new PasswordUtility();

                cmd.Parameters.AddWithValue("UserID", userID);
                cmd.Parameters.AddWithValue("Password", generator.HashPassword(password));

                using (SqlDataReader reader = cmd.ExecuteReader())
                {
                    success = reader.HasRows;

                    reader.Close();
                }
            }
        }
        finally
        {
            CloseConnection();
        }
    }

    return success;
}

我看不出为什么这会在同一连接上创建多个数据读取器的任何原因。

原文

We are using a custom Membership Provider in an ASP.NET MVC application. We have been experiencing intermittent 'System.InvalidOperationException - There is already an open DataReader associated with this Command which must be closed first.' problems with the class so I decided to enabled MARS.

This is the connection string in the web config...

<add name="CustomMembershipServices" connectionString="User ID=CUSTOM_USER;Password=pwd;Database=OUR_DB;Server=.\SQLEXPRESS;MultipleActiveResultSets=true;" providerName="System.Data.SqlClient" />

Our code now throws an ArgumentException: Keyword not supported: 'multipleactiverecordsets' at the following line..

protected void CreateAndOpenConnection()
{
    // Exception thrown here...
    _connection = new SqlConnection(_connectionString);
    _connection.Open();
}

The same exception is seen when targeting SQL2005 Express and SQL2008 Standard editions. Any suggestions?

In response to AdaTheDev here is the method that uses the data reader...

public bool CheckUserPassword(long userID, string password)
{
    bool success = false;

    if (!string.IsNullOrEmpty(password))
    {
        try
        {
            CreateAndOpenConnection();

            using (SqlCommand cmd = CreateSqlCommandForStoredProcedure("CheckPassword"))
            {
                IPasswordUtility generator = new PasswordUtility();

                cmd.Parameters.AddWithValue("UserID", userID);
                cmd.Parameters.AddWithValue("Password", generator.HashPassword(password));

                using (SqlDataReader reader = cmd.ExecuteReader())
                {
                    success = reader.HasRows;

                    reader.Close();
                }
            }
        }
        finally
        {
            CloseConnection();
        }
    }

    return success;
}

I cannot see any reason why this would be creating multiple data readers on the same connection.

分享到QQ

分享到微博