Nhibernate Executiontimeout * No Lock RRS feed

  • Question

  • User1203305613 posted

    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

    Wednesday, October 14, 2020 11:59 AM