设置超时在NHibernate中过期 [英] Set TimeOut Expired in NHibernate

问题描述

我在sql server 2008 R2中有一个存储过程，该存储过程运行良好，但突然它抛出TimeOut Expiration异常.

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();

我正在使用上面的NHibernate命令来调用我的SP.

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

我的问题是如何在NHibernate中设置超时期限.谢谢

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

推荐答案

只需流畅地添加SetTimeout方法:

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

有关更多信息，您可以在此处阅读.

For more information you can read here.

这篇关于设置超时在NHibernate中过期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！