设置事务级别为 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();
}
另外这段代码是在一个线程中执行。
谁能帮忙分析下? 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();
}
另外这段代码是在一个线程中执行。
修改Read(select)的环境的为:读未提交