public void WithSqlTimings()
{
MiniProfiler mp;
using (BaseTest.GetRequest())
using (var conn = GetProfiledConnection())
{
mp = MiniProfiler.Current;
// one sql in the root timing
conn.Query("select 1");
using (mp.Step("Child step"))
{
conn.Query("select 2 where 1 = @one", new { one = 1 });
}
}
Assert.IsFalse(mp.HasDuplicateSqlTimings);
AssertSqlTimingsExist(mp.Root, 1);
var t = mp.Root.Children.Single();
AssertSqlTimingsExist(t, 1);
AssertSqlParametersExist(t.SqlTimings.Single(), 1);
var mp2 = MiniProfiler.Settings.Storage.Load(mp.Id);
AssertProfilersAreEqual(mp, mp2);
}
public void DataAdapter()
{
MiniProfiler mp;
var factory = EFProfiledDbProviderFactory <SqlCeProviderFactory> .Instance;
using (BaseTest.GetRequest())
using (var da = factory.CreateDataAdapter())
{
var cmd = factory.CreateCommand();
Debug.Assert(cmd != null, "cmd != null");
cmd.CommandText = "select 1 as A, 2 as B";
Debug.Assert(da != null, "da != null");
da.SelectCommand = cmd;
da.SelectCommand.Connection = GetConnection();
var ds = new DataSet();
da.Fill(ds);
Assert.That(((int)ds.Tables[0].Rows[0][0]) == 1);
mp = MiniProfiler.Current;
}
Assert.That(mp.ExecutedReaders == 1);
Assert.That(mp.ExecutedScalars == 0);
Assert.That(mp.ExecutedNonQueries == 0);
}