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
  • 7,872
  • 11
  • 55
  • 111

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
  • 55,302
  • 13
  • 128
  • 150
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
  • 8,786
  • 3
  • 37
  • 52