查看ef生成的sql有很多种方法,这里介绍两种几种的方法
方法1:浏览器直接方法/Home/getsql直接查看sql
//方法1:浏览器直接方法/Home/getsql直接查看sql public string GetSql() { dbEntities db = new dbEntities(); return db.news.Where(m => m.hot == 1).OrderByDescending(m => m.ID).Take(5).ToString(); }
方法2:把生成的sql保存在磁盘中
//方法2:把sql保存在磁盘中 public ActionResult Index2() { dbEntities db = new dbEntities(); var sw = new StreamWriter(@"d:" + DateTime.Now.ToFileTime().ToString() + ".log") { AutoFlush = true }; db.Database.Log = s =>{sw.Write(s);}; var list = db.news.Where(m => m.hot == 1).OrderByDescending(m => m.ID).Take(5).ToList(); return View(list); }
方法3:MiniProfiler
建议使用vs2015以上nuget搜索MiniProfiler安装
需要安装MiniProfiler、MiniProfiler ef6、MiniProfiler mvc,如果最新版安装不成功的话安装低版本即可
安装完成后需要设置Global.asax、web.config、view
Global.asax(新加红色代码)
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Http; using System.Web.Mvc; using System.Web.Optimization; using System.Web.Routing; using StackExchange.Profiling; using StackExchange.Profiling.EntityFramework6; namespace cms.Web { public class MvcApplication : System.Web.HttpApplication { protected void Application_Start() { AreaRegistration.RegisterAllAreas(); WebApiConfig.Register(GlobalConfiguration.Configuration); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); BundleTable.EnableOptimizations = true;//js/css压缩 MiniProfilerEF6.Initialize();//MiniProfiler监控ef } protected void Application_BeginRequest() { if (Request.IsLocal)//这里是允许本地访问启动监控,可不写 { MiniProfiler.Start(); } } protected void Application_EndRequest() { MiniProfiler.Stop(); } } }
web.config
<system.webServer> <validation validateIntegratedModeConfiguration="false" /> <handlers> <add name="MiniProfiler" path="mini-profiler-resources/*" verb="*" type="System.Web.Routing.UrlRoutingModule" resourceType="Unspecified" preCondition="integratedMode" /> </handlers> </system.webServer>
随便一个view
@using StackExchange.Profiling;
@MiniProfiler.RenderIncludes();
注意:如果想监控所有的页面,推荐加在布局页(_Layout)中
运行效果