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();修改該數據行是有排他鎖的 但是查詢就沒有 默認的共享鎖嗎？我該怎么在c# 代碼里在開啟事務查詢時強制給查詢的數據加排他鎖？？？
1 回答
慕后森
TA貢獻1802條經驗 獲得超5個贊
使用 TABLOCKX
myCommand.CommandText = "select * from Categories WITH(TABLOCKX) where categoryid=1";
- 1 回答
- 0 關注
- 969 瀏覽
添加回答
舉報
0/150
提交
取消