/// <summary> /// The EF code first. /// </summary> /// <returns>the entity framework code first view.</returns> public ActionResult EFCodeFirst() { int count; int?newCount = null; EFContext context = null; using (MiniProfiler.Current.Step("EF Stuff")) { try { using (MiniProfiler.Current.Step("Create Context")) context = new EFContext(); // this is not correct, as the count from this assignment is never actually used 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(); } // this count is actually used. using (MiniProfiler.Current.Step("Second count")) count = context.People.Count(); const string sql = "Select count(*) from People"; using (MiniProfiler.Current.Step("Get Count from SqlQuery Method - no sql recorded")) { newCount = context.Database.SqlQuery <int>(sql).Single(); } using (MiniProfiler.Current.Step("Get Count using ProfiledConnection - sql recorded")) { using (var conn = new ProfiledDbConnection(context.Database.Connection, MiniProfiler.Current)) { conn.Open(); newCount = conn.Query <int>(sql).Single(); conn.Close(); } } } finally { if (context != null) { context.Dispose(); } } } return(Content(string.Format("EF Code First complete - count: {0}, sqlQuery count {1}", count, newCount))); }
public void TestProfiledStoredProcWithParameters() { using (var connection = ConnectionWithTransaction()) { connection.ExecuteSql("CREATE PROC InsightTestProcMiniProfiler (@Value int = 5) AS SELECT Value=@Value"); var profiled = new ProfiledDbConnection((DbConnection)connection, MiniProfiler.Current); var result = profiled.Query <int>("InsightTestProcMiniProfiler", new { Value = 1 }).First(); Assert.AreEqual((int)1, result); } }
/// <summary> /// The EF core. /// </summary> /// <returns>The entity framework core.</returns> public ActionResult EFCore() { int count; int?newCount = null; EFContext context = null; //using (var connection = new ProfiledDbConnection(new SqliteConnection("DataSource=:memory:"), MiniProfiler.Current)) // dotnet\sdk\NuGetFallbackFolder\microsoft.data.sqlite.core\2.0.0\lib\netstandard2.0\Microsoft.Data.Sqlite.dll using (var connection = new SqliteConnection("DataSource=:memory:")) using (MiniProfiler.Current.Step("EF Core Stuff")) { try { connection.Open(); var options = new DbContextOptionsBuilder <EFContext>() .UseSqlite(connection) .Options; using (MiniProfiler.Current.Step("Create Context")) { context = new EFContext(options); } using (MiniProfiler.Current.Step("Create Schema")) { context.Database.EnsureCreated(); } // this is not correct, as the count from this assignment is never actually used 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(); } // this count is actually used. using (MiniProfiler.Current.Step("Second count")) { count = context.People.Count(); } using (MiniProfiler.Current.Step("Get Count from SqlQuery Method - no sql recorded")) { newCount = context.People.FromSql("Select * from People").Count(); } using (MiniProfiler.Current.Step("Get Count using ProfiledConnection - sql recorded")) { using (var conn = new ProfiledDbConnection(context.Database.GetDbConnection(), MiniProfiler.Current)) { conn.Open(); newCount = conn.Query <int>("Select Count(*) from People").Single(); conn.Close(); } } } finally { context?.Dispose(); } } return(Content(string.Format("EF Code First complete - count: {0}, sqlQuery count {1}", count, newCount))); }