SqlConnection myconnection = new SqlConnection(SqlDapperHelper.connStrWrite);myconnection.Open();SqlTransaction myTrans = myconnection.BeginTransaction();SqlCommand myCommand = new SqlCommand();myCommand.Connection = myconnection;myCommand.Transaction = myTrans;myCommand.CommandText = "select * from Categories where categoryid=1";myCommand.ExecuteNonQuery();myTrans.Commit();修改該數(shù)據(jù)行是有排他鎖的 但是查詢就沒有 默認(rèn)的共享鎖嗎？我該怎么在c# 代碼里在開啟事務(wù)查詢時(shí)強(qiáng)制給查詢的數(shù)據(jù)加排他鎖？？？
1 回答
慕后森
TA貢獻(xiàn)1802條經(jīng)驗(yàn) 獲得超5個(gè)贊
使用 TABLOCKX
myCommand.CommandText = "select * from Categories WITH(TABLOCKX) where categoryid=1";
- 1 回答
- 0 關(guān)注
- 958 瀏覽
添加回答
舉報(bào)
0/150
提交
取消