title: How to read sql generated by NHibernate in Visual Studio
body: <p>According to what I know, there are 3 ways to read the sql script generated by NHibernate:
  1. log4net
  2. sql profiler
  3. show_sql = true</p>
  
  <p>Here I just want to talk about 3rd one for it's said that I can read the sql in the output window in Visual Studio. But whatever I do, I can see nothing?!</p>
  
  <p>Becasue some guy said the "show_sql = true" just means "Console.WriteLine()", so I post a question <a href="https://stackoverflow.com/questions/129133/how-do-i-view-the-sql-that-is-generated-by-nhibernate">here</a>.</p>
  
  <p>I have to say I don't get what I want, so here I summarize my questions:
  in the output window in an web application:</p>
  
  <ol>
  <li>Can the result of "Console.WriteLine()" be shown?</li>
  <li>Can "show_sql=true" make the sql script be shown?</li>
  </ol>
  
  <p>If yes, how?</p>