设置事务级别为 IsolationLevel.ReadUncommitted 但还是把目标表给锁了,无法查询。
谁能帮忙分析下?                using (SqlConnection conn = new SqlConnection(connectionString))
                {
                    conn.Open();
                    SqlCommand cmd = new SqlCommand();
                    cmd.Connection = conn;
                    SqlTransaction tx = conn.BeginTransaction(IsolationLevel.ReadUncommitted);
                    cmd.Transaction = tx;
                    SqlBulkCopy sbc = new SqlBulkCopy(conn, SqlBulkCopyOptions.Default, tx);
                    string sql = string.Empty;
                        for (int n = 0; n < listSql.Count; n++)
                        {
                            string strsql = listSql[n];
                            if (strsql.Trim().Length > 1)
                            {
                                cmd.CommandText = strsql;
                                sql = strsql;
                                cmd.ExecuteNonQuery();
                            }
                        }
                        sbc.DestinationTableName = tableName;
                        sbc.WriteToServer(dt);
                        tx.Commit();
                }
另外这段代码是在一个线程中执行。