public void TestScope()
{
using (var userContext = new UserContext())
{
userContext.Database.Initialize(true);
}
using (var test = new TaskContext())
{
test.Database.Initialize(true);
}
DbInterception.Add(new HintInterceptor());
DbInterception.Add(new Log4NetCommandInterceptor());
var testing = Log4NetTestHelper.RecordLog(() =>
{
using (var db = new GenericContext())
{
using (var qh = new JoinHintScope <GroupHierarchy>("HASH"))
{
var tasks = db.Set <Task>().Include(t => t.User).Where(t => db.Set <User>().
Where(UserExpressions.UserByGroups(1)).Any(u => u.Id == t.UserId));
var testarr = tasks.ToArray();
}
}
});
Assert.IsTrue(testing[0].Contains("INNER HASH JOIN [dbo].[v_GroupHierarchy]"));
}
public void TestTasks()
{
DbInterception.Add(new HintInterceptor());
using (var userContext = new UserContext())
{
userContext.Database.Initialize(true);
}
using (var test = new TaskContext())
{
test.Database.Initialize(true);
}
using (var db = new GenericContext())
{
using (var qh = new HintScope("HASH JOIN"))
{
var tasks = db.Set <Task>().Include(t => t.User).Where(t => db.Set <User>().
Where(UserExpressions.UserByGroups(1)).Any(u => u.Id == t.UserId));
var testarr = tasks.ToArray();
Assert.AreEqual(4, testarr.Length);
}
}
}
