如何在ASP.NET中了解LINQ語句性能

　　如果是在桌面程序中只需要

　　_contextLog = ConsoleOut;

　　即可在控制台輸出SQL語句可是在ASPNET中又該怎麼辦呢?

　　這時我想起了StringWriter用它就可以代替ConsoleOut幫我們接收輸出的日志保存在一個StringBuilder裡

　　於是構造一個輔助類

　　using System;
using SystemCollectionsGeneric;
using SystemLinq;
using SystemWeb;
using SystemIO;
using SystemText;
namespace ClowwindyModels
{
public static class LogHelper
{
public static StringBuilder Log = new StringBuilder();
public static TextWriter In = new StringWriter(Log);
public static string GetAllLog()
{
InFlush();
return LogToString();
}
public static void Clean()
{
Log = new StringBuilder();
In = new StringWriter(Log);
}
}
}

　　再添加一個頁面logaspx用來顯示日志

　　<%@ Page Language=C# AutoEventWireup=true

　　CodeBehind=Logaspxcs Inherits=ClowwindyLog %>
<!DOCTYPE html PUBLIC //WC//DTD XHTML Transitional//EN

　　transitionaldtd>
<html xmlns= >
<head runat=server>
<title>SQL Log</title>
</head>
<body>
<form id=form runat=server>
<asp:Button ID=btn_Clean runat=server Text=清空
onclick=btn_Clean_Click/>
<div>
<asp:Literal ID=Literal runat=server></asp:Literal>
</div>
</form>
</body>
</html>

　　using System;
using SystemCollectionsGeneric;
using SystemLinq;
using SystemWeb;
using SystemWebUI;
using SystemWebUIWebControls;
using ClowwindyModels;
namespace Clowwindy
{
public partial class Log : SystemWebUIPage
{
protected void Page_Load(object sender EventArgs e)
{
if (RequestUserHostAddress != )
{
ResponseEnd();
return;
}
LiteralText = LogHelperGetAllLog()Replace(\n\n<br/>);
}
protected void btn_Clean_Click(object sender EventArgs e)
{
LogHelperClean();
LiteralText = null;
}
}
}

　　最後在所有new DataContext的地方

　　加上_contextLog = LogHelperIn:

　　public Repository()
{
_context = new TDataContext();
_contextLog = LogHelperIn;
}

　　打開logaspx即可看到之前執行的SQL語句

From:http://tw.wingwit.com/Article/program/net/201311/13540.html