[C#] 觀察LINQ to SQL所產生的T-SQL語法

原作者 : Kris Vadermotten
類別名稱 : DebuggerWriter

使用方法
Step1. 專案加入 DebuggerWriter.cs ( *註一 )
Step2. 專案加入Linq to Sql 類別
Step3. 程式碼
ClassDataContext iCE = new ClassDataContext();
iCE.Log = new DebuggerWriter();

接下來，只要runtime有觸發查詢，就會在 [輸出] 列印出TSQL。


參考文章 : http://blog.darkthread.net/post-2009-07-12-linq-to-sql-debugger.aspx


*註一

using System;

using System.Diagnostics;

using System.Globalization;

using System.IO;

using System.Text;

/// <summary>

/// Original by Kris Vadermotten: http://www.u2u.info/Blogs/Kris/Lists/Posts/Post.aspx?ID=11 <br />

/// Remixed by Jeffrey Lee, 2009-07-11 http://blog.darkthread.net<br />

/// Implements a <see cref="TextWriter"/> for writing information to the debugger log. 

/// </summary>

/// <seealso cref="Debugger.Log"/>

public class DebuggerWriter : TextWriter

{

private bool isOpen;

private static UnicodeEncoding encoding =

new UnicodeEncoding(false, false);

public int Level { get; private set; }

public string Category { get; private set; }

/// <summary>

/// Initializes a new instance of the <see cref="DebuggerWriter"/> class.

/// </summary>

public DebuggerWriter()

: this(0, Debugger.DefaultCategory) { }

/// <summary>

/// Initializes a new instance of the <see cref="DebuggerWriter"/> class with the specified level and category.

/// </summary>

/// <param name="level">A description of the importance of the messages.</param>

/// <param name="category">The category of the messages.</param>

public DebuggerWriter(int level, string category)

: this(level, category, CultureInfo.CurrentCulture) { }

/// <summary>

/// Initializes a new instance of the <see cref="DebuggerWriter"/> class with the specified level, category and format provider.

/// </summary>

/// <param name="level">A description of the importance of the messages.</param>

/// <param name="category">The category of the messages.</param>

/// <param name="formatProvider">An <see cref="IFormatProvider"/> object that controls formatting.</param>

public DebuggerWriter(int level, string category, IFormatProvider formatProvider)

: base(formatProvider)

{

Level = level;

Category = category;

this.isOpen = true;

}

protected override void Dispose(bool disposing)

{

isOpen = false;

base.Dispose(disposing);

}

public override void Write(char value)

{

if (!isOpen)

throw new ObjectDisposedException(null);

Debugger.Log(Level, Category, value.ToString());

}

public override void Write(string value)

{

if (!isOpen)

throw new ObjectDisposedException(null);

if (value != null)

Debugger.Log(Level, Category, value);

}

public override void Write(char[] buffer, int index, int count)

{

if (!isOpen)

throw new ObjectDisposedException(null);

if (buffer == null || index < 0 || count < 0 || buffer.Length - index < count)

base.Write(buffer, index, count); // delegate throw exception to base class

Debugger.Log(Level, Category, new string(buffer, index, count));

}

public override Encoding Encoding

{

get { return encoding; }

}

}