如何配置 Fluent NHibernate 将查询输出到 Trace 或 Debug 而不是 Console?

问题描述

如何配置 Fluent NHibernate 将查询输出到 Trace 或 Debug 而不是 Console?我正在使用 MsSqlConfiguration.MsSql2008.ShowSql() 但它没有参数，我在 Google 上找不到任何东西.

How to configure Fluent NHibernate to output queries to Trace or Debug instead of Console?I'm using MsSqlConfiguration.MsSql2008.ShowSql() but it has no parameters and I can't find anything on Google.

推荐答案

我可以从论坛和博客文章中看到，在我之前的很多其他人都在寻找一种方法来获取准备执行的 SQL 语句.答案通常类似于你不能"或你不应该".

I can see from forum and blog posts everywhere that lots of others before me have looked for a way to get the SQL statements as they're being prepared for execution. The answer typically is something along the lines of "you can't", or "you shouldn't".

无论我是否应该，这就是我想要的.

Whether I should or not, that's what I wanted.

经过数小时的搜索、调查和失败的尝试，我终于想出了这个.

After hours of searching, investigation and failed attempts, and finally I came up with this.

编写一个拦截器:

using NHibernate;
using System.Diagnostics;

public class SqlStatementInterceptor : EmptyInterceptor
{
    public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql)
    {
        Trace.WriteLine(sql.ToString());
        return sql;
    }
}

当然，您不必在此处Trace.WriteLine()，您可以将其写入日志文件或其他任何您需要的文件.

Of course, you don't have to Trace.WriteLine() here, you could write it to a log file, or whatever else you need.

在你的连接管理器中，像这样连接你的拦截器:

In your connection manager, hook up your Interceptor like so:

protected virtual void Configure(FluentConfiguration config)
{
    config.ExposeConfiguration(x =>
                                   {
                                       x.SetInterceptor(new SqlStatementInterceptor());
                                   });
}

没那么复杂.从我的角度来看，这肯定比试图通过 Fluent 将所有这些 XML 推送到 NHibernate 更容易——因为 Fluent 将 XML 文件抽象化了.

It's not that complicated. From my perspective, certainly easier than trying to get all this XML pushed through Fluent to NHibernate - since Fluent abstracts the XML file away.

请记住，您只能拥有一个拦截器 - 因此，如果您已经拥有一个拦截器，则可能需要将此功能与现有拦截器集成.在这一点上，您可能想给它一个更广泛的名称 - 例如MyAppInterceptor，以免暗示特定用途，因为您可能想稍后为其添加其他功能.

Keep in mind, you can only have a single Interceptor - so you may need to integrate this feature with your existing Interceptor, if you already have one. On that note, you might want to give it a broader name - e.g. MyAppInterceptor, so as not to imply a specific purpose, because you may want to add other features to it later.

这篇关于如何配置 Fluent NHibernate 将查询输出到 Trace 或 Debug 而不是 Console?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！