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ù)加排他鎖？？？