ASP.NET中显示Linq To SQL输出的SQL语句
<p >最近在使用Linq To SQL的时候，为了了解不同Linq语句对性能造成的不同影响，需要获得Linq To SQL生成的SQL语句。<p ><p >如果是在桌面程序中，只需要<p ><p >_context.Log = Console.Out;<p >即可在控制台输出SQL语句。可是在ASP.NET中又该怎么办呢?<p ><p >这时我想起了StringWriter。用它就可以代替Console.Out帮我们接收输出的日志，保存在一个StringBuilder里。<p ><p >于是构造一个辅助类：<p ><p >using System;<p >using System.Collections.Generic;<p >using System.Linq;<p >using System.Web;<p >using System.IO;<p >using System.Text;<p ><p >namespace Clowwindy.Models<p >{<p > public static class LogHelper<p > {<p > public static StringBuilder Log = new StringBuilder();<p > public static TextWriter In = new StringWriter(Log);<p > public static string GetAllLog()<p > {<p > In.Flush();<p > return Log.ToString();<p > }<p > public static void Clean()<p > {<p > Log = new StringBuilder();<p > In = new StringWriter(Log);<p > }<p > }<p >}<p ><p >再添加一个页面log.aspx，用来显示日志： <p ><p ><p ><%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Log.aspx.cs" Inherits="Clowwindy.Log" %><p ><p ><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><p ><p ><html xmlns="http://www.w3.org/1999/xhtml" ><p ><head runat="server"><p ><title>SQL Log</title><p ></head><p ><body><p ><form id="form1" runat="server"><p ><asp:Button ID="btn_Clean" runat="server" Text="清空" <p > onclick="btn_Clean_Click"/><p ><div><p ><p ></div><p ></form><p ></body><p ></html><p ><p ><p ><p >using System;<p >using System.Collections.Generic;<p >using System.Linq;<p >using System.Web;<p >using System.Web.UI;<p >using System.Web.UI.WebControls;<p >using Clowwindy.Models;<p ><p >namespace Clowwindy<p >{<p > public partial class Log : System.Web.UI.Page<p > {<p > protected void Page_Load(object sender, EventArgs e)<p > {<p > if (Request.UserHostAddress != "127.0.0.1")<p > {<p > Response.End();<p > return;<p > }<p > Literal1.Text = LogHelper.GetAllLog().Replace("\n","\n<br/>");<p > }<p ><p > protected void btn_Clean_Click(object sender, EventArgs e)<p > {<p > LogHelper.Clean();<p > Literal1.Text = null;<p > }<p > }<p >}<p ><p >最后在所有new DataContext的地方<p >加上_context.Log = LogHelper.In: <p ><p ><p > public Repository()<p > {<p > _context = new TDataContext();<p > _context.Log = LogHelper.In;<p > }<p >打开log.aspx，即可看到之前执行的SQL语句。<p ><P align=right></P><p align="center"></p></p>
页:
[1]