void Q(ISession session)
{
	var q = session.Get<User>(101);
	q.Dump();
}

void Main()
{
	var config = MsSqlConfiguration.MsSql2008
		.ConnectionString("Data Source=.;Initial Catalog=DB_NAME;Integrated Security=true;")
		;

	var sessionFactory = Configurator
		.FluentConfiguration(config)
		.BuildSessionFactory();

	using(ISession session = sessionFactory.OpenSession(new LoggingInterceptor()))
	{
		Q(session);
	}
}

public class LoggingInterceptor : EmptyInterceptor, IInterceptor
{
 	SqlString IInterceptor.OnPrepareStatement(SqlString sql)
	{
		var linqPadAsm = AppDomain.CurrentDomain.GetAssemblies().Single(a => a.FullName.Contains("LINQPad"));
		var log = (StringWriter)(
			linqPadAsm.GetType("LINQPad.LINQPadDbController")
				.GetProperties(BindingFlags.Static | BindingFlags.Public )[0]
				.GetGetMethod()
				.Invoke(null, new object[0]));

		log.Write(sql.ToString());
		return base.OnPrepareStatement(sql);
	}
}