How to Log All the queries with their parameter values

[Roshan Budhathoki]

I could log queries using Interceptor but paramerters are not being logged.

-------

public class NhibernateQueryLogger : EmptyInterceptor
{
    private Logger _logger;
    public NhibernateQueryLogger()
    {
        _logger = new LoggerConfiguration().WriteTo.RollingFile("logs/nhibernate-log-{Date}.txt").CreateLogger();
    }

    public override SqlString OnPrepareStatement(SqlString sql)
    {
        _logger.Information(sql.ToString());
        return base.OnPrepareStatement(sql);
    }
}

-----------------