执行读取器永远不会返回

Question

我通过 devart dotconnect 使用 mysql。上面的代码是多线程类的一部分。

public  void DoQuery(ref Devart.Data.MySql.MySqlDataReader Dr, string QryStr)
        {
            lock (locker)
            {
               //Program.MyMutex.WaitOne();
                Devart.Data.MySql.MySqlCommand Command = new Devart.Data.MySql.MySqlCommand();
                int ThreadID = Convert.ToInt32(Thread.CurrentThread.Name);
                MySqlConnection FCon = Program.Con[ThreadID];
                if (FCon.State != System.Data.ConnectionState.Open) Program.Con[ThreadID] = Program.BuildDbConnection();
                Command.Connection = FCon;
                Command.CommandTimeout = 0;
                Command.FetchAll = true;
                Command.CommandText = QryStr;
                if (Dr != null) Dr.Dispose();
                if (QryStr.Substring(0, 6).Equals("select", StringComparison.CurrentCultureIgnoreCase) != true) Command.ExecuteNonQuery(); else Dr = Command.ExecuteReader(); this line randomly stuck on ExecuteReader.
                Command.Dispose();
            }
        }

Answer 1

您通过 Dr 只是为了稍后处理它吗？您还应该从阅读器中读取以获取数据。

while (reader.Read())
    {
        Console.WriteLine(String.Format("{0", reader[0]));
    }