The below Nhibernate call is failing with "Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."}
totalDenied = (From denialRep In denialRepQry
Join claimRep In _claimRepository.Query On claimRep.Id Equals denialRep.Claim.Id
Join encounterRep In _encounterRepository.Query() On encounterRep.Id Equals claimRep.Encounter.Id
Join transRep In _transactionRepository.Query On denialRep.Transaction.Id Equals transRep.Id
Select denialRep.AdjustmentAmount).ToList()
I checked and I need to add Indexes
But with ado.net we could add Commandtimeout to 120 or 240 , how do we do in nhibernate
Member
62 Points
113 Posts
Nhibernate Executiontimeout * No Lock
Oct 14, 2020 11:59 AM|KALYANA ALLAM|LINK
The below Nhibernate call is failing with "Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."}
totalDenied = (From denialRep In denialRepQry
Join claimRep In _claimRepository.Query On claimRep.Id Equals denialRep.Claim.Id
Join encounterRep In _encounterRepository.Query() On encounterRep.Id Equals claimRep.Encounter.Id
Join transRep In _transactionRepository.Query On denialRep.Transaction.Id Equals transRep.Id
Select denialRep.AdjustmentAmount).ToList()
I checked and I need to add Indexes
But with ado.net we could add Commandtimeout to 120 or 240 , how do we do in nhibernate
Also How do we add No Lock to the queries
Contributor
4973 Points
4264 Posts
Re: Nhibernate Executiontimeout * No Lock
Oct 15, 2020 05:33 AM|DA924|LINK
I suggest you can figure out how to set the Timeout.
http://mausch.github.io/nhibernate-3.2.0GA/html/196bf46d-0aae-6bd1-be90-6ec3692ed171.htm
As for the no lock, you may have to do a read uncommitted using System.Transaction scope
https://www.geeksforgeeks.org/transaction-isolation-levels-dbms/#:~:text=Read%20Uncommitted%20%E2%80%93%20Read%20Uncommitted%20is,not%20isolated%20from%20each%20other.