public static void PreStart() { MiniProfiler.Settings.SqlFormatter = new MvcMiniProfiler.SqlFormatters.SqlServerFormatter(); var sqlConnectionFactory = new SqlConnectionFactory(ConfigurationManager.ConnectionStrings["NuGetGallery"].ConnectionString); var profiledConnectionFactory = new MvcMiniProfiler.Data.ProfiledDbConnectionFactory(sqlConnectionFactory); Database.DefaultConnectionFactory = profiledConnectionFactory; DynamicModuleUtility.RegisterModule(typeof(MiniProfilerStartupModule)); GlobalFilters.Filters.Add(new ProfilingActionFilter()); }
public ActionResult EFCodeFirst() { int count; // this would usually go in Global.asax.cs in Application_Start { var factory = new SqlCeConnectionFactory("System.Data.SqlServerCe.4.0"); // for sql server you could do ... //var factory = new SqlConnectionFactory("Data Source=.;Initial Catalog=tempdb;Integrated Security=True"); var profiled = new MvcMiniProfiler.Data.ProfiledDbConnectionFactory(factory); Database.DefaultConnectionFactory = profiled; Database.SetInitializer<EFContext>(new DropCreateDatabaseIfModelChanges<EFContext>()); } // end EFContext context = null; using (MiniProfiler.Current.Step("EF Stuff")) { try { using (MiniProfiler.Current.Step("Create Context")) context = new EFContext(); using (MiniProfiler.Current.Step("First count")) count = context.People.Count(); using (MiniProfiler.Current.Step("Insertion")) { var p = new Person { Name = "sam" }; context.People.Add(p); context.SaveChanges(); } using (MiniProfiler.Current.Step("Second count")) count = context.People.Count(); } finally { if (context != null) { context.Dispose(); } } } return Json(count, JsonRequestBehavior.AllowGet); }