无法获得的NHibernate 3.1登录SQL UPDATE或DELETE语句 [英] Can't get NHibernate 3.1 to log sql update or delete statements

问题描述

我目前在ASP.Net应用程序使用NHibernate 3.1和得到它的工作pretty以及（与流利）。我设法让它记录所有生成的SQL查询到我的输出选项卡，同时在使用的Application_Start下面的代码片断调试：

I'm currently using NHibernate 3.1 in a ASP.Net application and got it working pretty well (with Fluent). I managed to make it log all generated SQL queries to my output tab while debugging by using the following snippet in Application_Start:

私有静态DebugTextWriter _writer;

受保护的虚拟无效的Application_Start（对象发件人，EventArgs的发送）
{
     _writer =新DebugTextWriter（）;
     Console.SetOut（_writer）;结果
}

我最近升级NHibernate的从2.1到3.1，现在我的更新和删除语句不再被输出到记录...

I recently upgraded NHibernate from 2.1 to 3.1 and now my update and delete statements are no longer being output to the to log...

难道你们有什么想法，为什么？

Do you guys have any idea why?

感谢

推荐答案

我终于找到什么导致这种行为。事实证明，在hibernate.cfg.xml文件中adonet.batch_size项导致问题。删除此属性元素，更新和删除语句后如预期最终输出。

I finally found what was causing this behavior. It turns out that the adonet.batch_size entry in the hibernate.cfg.xml file is causing the problem. After removing this property element, the update and delete statements were finally output as expected.

谢谢您的回答和评论。

这篇关于无法获得的NHibernate 3.1登录SQL UPDATE或DELETE语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！