5

How might I see the SQL query generated from LINQ to SQL when debugging inside a WCF service? I thought I might just set dataContext.Log = Console.Out and the SQL would be written to the output/immediate window. It doesn't--is that because I am hosting using IIS? Console.WriteLine("Hello") doesn't even write anything to the output/immediate window.

How do see my console output?

Patrick Szalapski
  • 8,738
  • 11
  • 67
  • 129

2 Answers2

6

You can try to use System.Diagnostics.Debug.WriteLine(), so when you distribute Release app these lines will be stripped out from code.

Marco
  • 56,740
  • 14
  • 129
  • 152
2

You may want to write it to a file instead. dataContext.Log takes any TextWriter.

See this comment for a nice way to get a text writer writing to Debug.

Community
  • 1
  • 1
YetAnotherUser
  • 9,156
  • 3
  • 39
  • 53