Set TimeOut Expired in NHibernate

Question

I have a stored procedure in sql server 2008 R2 which was working fine, but suddenly it throws an exception of TimeOut Expiration.

BmDaoSession.CreateSQLQuery("exec SP_Name @Param1  = '" + clientCode + "', @Param2 ='" + existingDatabase + "', @Flag='" + flag + "'").ExecuteUpdate();

I am using the above NHibernate command to call my SP.

My question is how Can I set the TimeOut Expiration in NHibernate. Thanks

score 9 · Accepted Answer · edited May 23 '17 at 10:29

9

Just add fluently SetTimeout method:

BmDaoSession.CreateSQLQuery("exec SP_Name @Param1  = '" + clientCode + "', @Param2 ='" + existingDatabase + "', @Flag='" + flag + "'")
    .SetTimeout(120)
    .ExecuteUpdate();

For more information you can read here.

edited May 23 '17 at 10:29

Community

1
1

answered Apr 15 '14 at 15:34

Najera

2,869
3
28
52

1

Please note the error. .SetTimeOut should be .SetTimeout in the code. – Francois Botha Aug 11 '14 at 06:45

Set TimeOut Expired in NHibernate

1 Answers1