public void Command_trees_for_initialization_and_simple_query_and_update_commands_can_be_logged()
{
// Make sure that HistoryContext has been used to ensure test runs consistently regardless of
// whether or not other tests have run before it.
using (var initContext = new BlogContextNoInit())
{
ExtendedSqlAzureExecutionStrategy.ExecuteNew(
() =>
{
initContext.Database.Initialize(force: false);
});
}
var logger = new CommandTreeLogger();
DbInterception.Add(logger);
BlogContextLogAll context;
try
{
using (context = new BlogContextLogAll())
{
BlogContext.DoStuff(context);
}
}
finally
{
DbInterception.Remove(logger);
}
// Sanity check that we got tree creations logged
Assert.True(logger.Log.OfType <DbQueryCommandTree>().Any(t => t.DataSpace == DataSpace.CSpace));
Assert.True(logger.Log.OfType <DbQueryCommandTree>().Any(t => t.DataSpace == DataSpace.SSpace));
Assert.True(logger.Log.OfType <DbInsertCommandTree>().Any(t => t.DataSpace == DataSpace.SSpace));
#if !NET40
Assert.True(logger.Log.OfType <DbUpdateCommandTree>().Any(t => t.DataSpace == DataSpace.SSpace));
Assert.True(
logger.Log.OfType <DbUpdateCommandTree>()
.Any(
t => t.SetClauses.OfType <DbSetClause>()
.Any(
c => ((DbPropertyExpression)c.Property).Property.Name == "Title" &&
(string)((DbConstantExpression)c.Value).Value == "I'm a logger and I'm okay...")));
#endif
foreach (var interceptionContext in logger.LogWithContext.Select(t => t.Item2))
{
Assert.Contains(context, interceptionContext.DbContexts);
}
}
public void Command_trees_for_initialization_and_simple_query_and_update_commands_can_be_logged()
{
// Make sure that HistoryContext has been used to ensure test runs consistently regardless of
// whether or not other tests have run before it.
using (var initContext = new BlogContextNoInit())
{
ExtendedSqlAzureExecutionStrategy.ExecuteNew(
() =>
{
initContext.Database.Initialize(force: false);
});
}
var logger = new CommandTreeLogger();
DbInterception.Add(logger);
BlogContextLogAll context;
try
{
using (context = new BlogContextLogAll())
{
BlogContext.DoStuff(context);
}
}
finally
{
DbInterception.Remove(logger);
}
// Sanity check that we got tree creations logged
Assert.True(logger.Log.OfType<DbQueryCommandTree>().Any(t => t.DataSpace == DataSpace.CSpace));
Assert.True(logger.Log.OfType<DbQueryCommandTree>().Any(t => t.DataSpace == DataSpace.SSpace));
Assert.True(logger.Log.OfType<DbInsertCommandTree>().Any(t => t.DataSpace == DataSpace.SSpace));
#if !NET40
Assert.True(logger.Log.OfType<DbUpdateCommandTree>().Any(t => t.DataSpace == DataSpace.SSpace));
Assert.True(
logger.Log.OfType<DbUpdateCommandTree>()
.Any(
t => t.SetClauses.OfType<DbSetClause>()
.Any(
c => ((DbPropertyExpression)c.Property).Property.Name == "Title"
&& (string)((DbConstantExpression)c.Value).Value == "I'm a logger and I'm okay...")));
#endif
foreach (var interceptionContext in logger.LogWithContext.Select(t => t.Item2))
{
Assert.Contains(context, interceptionContext.DbContexts);
}
}
public void Multiple_contexts_running_concurrently_can_log_command_trees_except_trees_for_cached_queries()
{
// Make sure no logs get initialization trees
using (var context = new BlogContextAllTrees())
{
ExtendedSqlAzureExecutionStrategy.ExecuteNew(
() =>
{
context.Database.Initialize(force: false);
});
}
// Run the test code once to log both update and query trees
using (var context = new BlogContextAllTrees())
{
var logger = new CommandTreeLogger(context);
DbInterception.Add(logger);
try
{
BlogContext.DoStuff(context);
}
finally
{
DbInterception.Remove(logger);
}
#if NET40
Assert.Equal(7, logger.Log.Count);
#else
Assert.Equal(8, logger.Log.Count);
#endif
Assert.True(logger.Log.OfType <DbQueryCommandTree>().Any(t => t.DataSpace == DataSpace.CSpace));
Assert.True(logger.Log.OfType <DbInsertCommandTree>().Any(t => t.DataSpace == DataSpace.SSpace));
#if !NET40
Assert.True(logger.Log.OfType <DbUpdateCommandTree>().Any(t => t.DataSpace == DataSpace.SSpace));
#endif
}
// Now run again multiple times concurrently--only update trees logged
var loggers = new ConcurrentBag <CommandTreeLogger>();
const int executionCount = 5;
ExecuteInParallel(
() =>
{
using (var context = new BlogContextAllTrees())
{
var logger = new CommandTreeLogger(context);
DbInterception.Add(logger);
loggers.Add(logger);
try
{
BlogContext.DoStuff(context);
}
finally
{
DbInterception.Remove(logger);
}
}
}, executionCount);
Assert.Equal(executionCount, loggers.Count);
foreach (var logger in loggers)
{
#if NET40
Assert.Equal(1, logger.Log.Count);
#else
Assert.Equal(2, logger.Log.Count);
#endif
Assert.False(logger.Log.OfType <DbQueryCommandTree>().Any(t => t.DataSpace == DataSpace.CSpace));
Assert.True(logger.Log.OfType <DbInsertCommandTree>().Any(t => t.DataSpace == DataSpace.SSpace));
#if !NET40
Assert.True(logger.Log.OfType <DbUpdateCommandTree>().Any(t => t.DataSpace == DataSpace.SSpace));
#endif
}
}
public void Multiple_contexts_running_concurrently_can_log_command_trees_except_trees_for_cached_queries()
{
// Make sure no logs get initialization trees
using (var context = new BlogContextAllTrees())
{
ExtendedSqlAzureExecutionStrategy.ExecuteNew(
() =>
{
context.Database.Initialize(force: false);
});
}
// Run the test code once to log both update and query trees
using (var context = new BlogContextAllTrees())
{
var logger = new CommandTreeLogger(context);
DbInterception.Add(logger);
try
{
BlogContext.DoStuff(context);
}
finally
{
DbInterception.Remove(logger);
}
#if NET40
Assert.Equal(7, logger.Log.Count);
#else
Assert.Equal(8, logger.Log.Count);
#endif
Assert.True(logger.Log.OfType<DbQueryCommandTree>().Any(t => t.DataSpace == DataSpace.CSpace));
Assert.True(logger.Log.OfType<DbInsertCommandTree>().Any(t => t.DataSpace == DataSpace.SSpace));
#if !NET40
Assert.True(logger.Log.OfType<DbUpdateCommandTree>().Any(t => t.DataSpace == DataSpace.SSpace));
#endif
}
// Now run again multiple times concurrently--only update trees logged
var loggers = new ConcurrentBag<CommandTreeLogger>();
const int executionCount = 5;
ExecuteInParallel(
() =>
{
using (var context = new BlogContextAllTrees())
{
var logger = new CommandTreeLogger(context);
DbInterception.Add(logger);
loggers.Add(logger);
try
{
BlogContext.DoStuff(context);
}
finally
{
DbInterception.Remove(logger);
}
}
}, executionCount);
Assert.Equal(executionCount, loggers.Count);
foreach (var logger in loggers)
{
#if NET40
Assert.Equal(1, logger.Log.Count);
#else
Assert.Equal(2, logger.Log.Count);
#endif
Assert.False(logger.Log.OfType<DbQueryCommandTree>().Any(t => t.DataSpace == DataSpace.CSpace));
Assert.True(logger.Log.OfType<DbInsertCommandTree>().Any(t => t.DataSpace == DataSpace.SSpace));
#if !NET40
Assert.True(logger.Log.OfType<DbUpdateCommandTree>().Any(t => t.DataSpace == DataSpace.SSpace));
#endif
}
}
