LINQPad - Log Secondary DataContext to "SQL" Tab

Question

Its easy enough to instantiate multiple DataContexts in LINQPad. Is there any way to set these instances to Log to the "SQL" Tab of the results pane?

Setting myDataContext.Log = this.Log doesn't work.

Answer 1

The author doesn't expose this currently, the output doesn't really behave in a steam-like way. (Refreshed on result/action instead of a constant paint)

However, you can request features for LINQPad on UserVoice, and hope that it makes a future release.

Answer 2

Try this extensions for linq this will help

http://www.aneyfamily.com/terryandann/BlogAssets/LinqBatchPost.zip

Blog post: http://www.aneyfamily.com/terryandann/post/2008/04/LINQPad-Preview-DELETE-and-UPDATE-SQL-before-it-executes.aspx

Answer 3

The SQL tab output writer is now exposed in the latest LINQPad build:

myDataContext.Log = Util.SqlOutputWriter;

The latest build also refreshes both results and SQL output in real-time.