public void TestDateTimeWhereCompareWithStaticVariable()
{
using (var env = new MethodEnvironment(classEnv))
{
//SETUP
var linq = env.Db.EfParents.Where(x => x.StartDate > dateConst).Select(x => x.StartDate).ToList();
//ATTEMPT
env.AboutToUseDelegateDecompiler();
var dd = env.Db.EfParents.Where(x => x.StartDateGreaterThanStaticVar).Select(x => x.StartDate).Decompile().ToList();
//VERIFY
env.CompareAndLogList(linq, dd);
}
}
public void TestAllFilterOnChildrenInt()
{
using (var env = new MethodEnvironment(classEnv))
{
//SETUP
var linq = env.Db.EfParents.Select(x => x.Children.All(y => y.ChildInt == 123)).ToList();
//ATTEMPT
env.AboutToUseDelegateDecompiler();
var dd = env.Db.EfParents.Select(x => x.AllFilterOnChildrenInt).Decompile().ToList();
//VERIFY
env.CompareAndLogList(linq, dd);
}
}
public void TestSelectMethodWithoutComputedAttribute()
{
using (var env = new MethodEnvironment(classEnv))
{
//SETUP
var linq = env.Db.EfPersons.Select(x => x.FirstName + " " + x.MiddleName + " " + x.LastName).ToList();
//ATTEMPT
env.AboutToUseDelegateDecompiler();
var dd = env.Db.EfPersons.Select(x => x.GetFullNameNoAttibute()).Decompile().ToList();
//VERIFY
env.CompareAndLogList(linq, dd);
}
}
public void TestSingletonAllFilter()
{
using (var env = new MethodEnvironment(classEnv))
{
//SETUP
var linq = env.Db.EfParents.All(x => x.ParentInt == 123);
//ATTEMPT
env.AboutToUseDelegateDecompiler();
var dd = env.Db.EfParents.Decompile().All(x => x.IntEqualsConstant);
//VERIFY
env.CompareAndLogSingleton(linq, dd);
}
}
public void TestSelectAbstractMemberOverTphHierarchyAfterRestrictingToSubtype()
{
using (var env = new MethodEnvironment(classEnv))
{
//SETUP
var linq = env.Db.LivingBeeing.OfType <Animal>().ToList().Select(p => p.Species).ToList();
//ATTEMPT
env.AboutToUseDelegateDecompiler();
var dd = env.Db.LivingBeeing.OfType <Animal>().Select(p => p.Species).Decompile().ToList();
//VERIFY
env.CompareAndLogList(linq, dd);
}
}
public void TestSelectMultipleLevelsOfAbstractMembersOverTphHierarchy()
{
using (var env = new MethodEnvironment(classEnv))
{
//SETUP
var linq = env.Db.LivingBeeing.OfType <Animal>().ToList().Select(p => p.Species + " : " + p.IsPet).ToList();
//ATTEMPT
env.AboutToUseDelegateDecompiler();
var dd = env.Db.LivingBeeing.OfType <Animal>().Select(p => p.Species + " : " + p.IsPet).Decompile().ToList();
//VERIFY
env.CompareAndLogList(linq, dd);
}
}
public void TestWhereFiltersOnMultipleLevelsOfAbstractMembersOverTphHierarchy()
{
using (var env = new MethodEnvironment(classEnv))
{
//SETUP
var linq = env.Db.LivingBeeing.OfType <Animal>().ToList().Where(p => string.Concat(p.Species, " : ", p.IsPet) == "Apis mellifera : False").Select(x => x.Id).ToList();
//ATTEMPT
env.AboutToUseDelegateDecompiler();
var dd = env.Db.LivingBeeing.OfType <Animal>().Where(p => string.Concat(p.Species, " : ", p.IsPet) == "Apis mellifera : False").Select(x => x.Id).Decompile().ToList();
//VERIFY
env.CompareAndLogList(linq, dd);
}
}
public void TestWhereFiltersOnAbstractMembersOverTphHierarchy()
{
using (var env = new MethodEnvironment(classEnv))
{
//SETUP
var linq = env.Db.LivingBeeing.ToList().Where(x => x.Species == "Human").Select(x => x.Id).ToList();
//ATTEMPT
env.AboutToUseDelegateDecompiler();
var dd = env.Db.LivingBeeing.Where(x => x.Species == "Human").Select(x => x.Id).Decompile().ToList();
//VERIFY
env.CompareAndLogList(linq, dd);
}
}
public void TestWhereBoolEqualsStaticVariable()
{
using (var env = new MethodEnvironment(classEnv))
{
//SETUP
var linq = env.Db.EfParents.Where(x => x.ParentBool == staticBool).Select(x => x.EfParentId).ToList();
//ATTEMPT
env.AboutToUseDelegateDecompiler();
var dd = env.Db.EfParents.Where(x => x.BoolEqualsStaticVariable).Select(x => x.EfParentId).Decompile().ToList();
//VERIFY
env.CompareAndLogList(linq, dd);
}
}
public async Task TestBoolEqualsStaticVariableToArrayAsync()
{
using (var env = new MethodEnvironment(classEnv))
{
//SETUP
var linq = await env.Db.EfParents.Select(x => x.ParentBool == staticBool).ToListAsync();
//ATTEMPT
env.AboutToUseDelegateDecompiler();
var dd = await env.Db.EfParents.Select(x => x.BoolEqualsStaticVariable).DecompileAsync().ToListAsync();
//VERIFY
env.CompareAndLogList(linq, dd);
}
}
public void TestConcatenatePersonHandleNull()
{
using (var env = new MethodEnvironment(classEnv))
{
//SETUP
var linq = env.Db.EfPersons.Select(x => x.FirstName + (x.MiddleName == null ? "" : " ") + x.MiddleName + " " + x.LastName).ToList();
//ATTEMPT
env.AboutToUseDelegateDecompiler();
var dd = env.Db.EfPersons.Select(x => x.FullNameHandleNull).Decompile().ToList();
//VERIFY
env.CompareAndLogList(linq, dd);
}
}
public async Task TestAsync()
{
using (var env = new MethodEnvironment(classEnv))
{
//SETUP
var linq = await env.Db.EfParents.ToListAsync();
//ATTEMPT
env.AboutToUseDelegateDecompiler();
var dd = await env.Db.EfParents.DecompileAsync().ToListAsync();
//VERIFY
env.CompareAndLogList(linq, dd);
}
}
public void TestIntNotEqualsStringLength()
{
using (var env = new MethodEnvironment(classEnv))
{
//SETUP
var linq = env.Db.EfParents.Select(x => x.ParentInt != x.ParentString.Length).ToList();
//ATTEMPT
env.AboutToUseDelegateDecompiler();
var dd = env.Db.EfParents.Select(x => x.IntNotEqualsStringLength).Decompile().ToList();
//VERIFY
env.CompareAndLogList(linq, dd);
}
}
public void TestIntEqualsConstant()
{
using (var env = new MethodEnvironment(classEnv))
{
//SETUP
var linq = env.Db.EfParents.Select(x => x.ParentNullableInt == 123).ToList();
//ATTEMPT
env.AboutToUseDelegateDecompiler();
var dd = env.Db.EfParents.Select(x => x.ParentNullableIntEqualsConstant).Decompile().ToList();
//VERIFY
env.CompareAndLogList(linq, dd);
}
}
public void TestNullableAdd()
{
using (var env = new MethodEnvironment(classEnv))
{
//SETUP
var linq = env.Db.EfParents.Select(x => x.ParentNullableDecimal1 + x.ParentNullableDecimal2).ToList();
//ATTEMPT
env.AboutToUseDelegateDecompiler();
var dd = env.Db.EfParents.Select(x => x.ParentNullableDecimalAdd).Decompile().ToList();
//VERIFY
env.CompareAndLogList(linq, dd);
}
}
public async Task TestDecompileUpfrontBoolEqualsConstantAsync()
{
using (var env = new MethodEnvironment(classEnv))
{
//SETUP
var linq = await env.Db.EfParents.Select(x => x.ParentBool == true).ToListAsync();
//ATTEMPT
env.AboutToUseDelegateDecompiler();
var dd = await env.Db.EfParents.DecompileAsync().Select(x => x.BoolEqualsConstant).ToListAsync();
//VERIFY
env.CompareAndLogList(linq, dd);
}
}
public void TestSumCountInChildrenWhereChildrenCanBeNone()
{
using (var env = new MethodEnvironment(classEnv))
{
//SETUP
var linq = env.Db.EfParents.Select(x => x.Children.Sum(y => (int?)y.ChildInt) ?? 0).ToList();
//ATTEMPT
env.AboutToUseDelegateDecompiler();
var dd = env.Db.EfParents.Select(x => x.SumIntInChildrenWhereChildrenCanBeNone).Decompile().ToList();
//VERIFY
env.CompareAndLogList(linq, dd);
}
}
public void TestCountChildrenWithFilterByClosure()
{
using (var env = new MethodEnvironment(classEnv))
{
//SETUP
var linq = env.Db.EfParents.Select(x => x.Children.Count(y => y.ChildInt == x.EfParentId)).ToList();
//ATTEMPT
env.AboutToUseDelegateDecompiler();
var dd = env.Db.EfParents.Select(x => x.CountChildrenWithFilterByClosure).Decompile().ToList();
//VERIFY
env.CompareAndLogList(linq, dd);
}
}
public void TestSingletonCountChildrenWithFilter()
{
using (var env = new MethodEnvironment(classEnv))
{
//SETUP
var linq = env.Db.EfParents.Count(x => x.Children.Count() == 2);
//ATTEMPT
env.AboutToUseDelegateDecompiler();
var dd = env.Db.EfParents.Decompile().Count(x => x.CountChildren == 2);
//VERIFY
env.CompareAndLogSingleton(linq, dd);
}
}
public void TestStringContainsConstantStringWithFilter()
{
using (var env = new MethodEnvironment(classEnv))
{
//SETUP
var linq =
env.Db.EfParents.Where(x => x.ParentString.Contains("2")).Select(x => x.ParentString).ToList();
//ATTEMPT
env.AboutToUseDelegateDecompiler();
var dd = env.Db.EfParents.Where(x => x.StringContainsConstantString).Select(x => x.ParentString).Decompile().ToList();
//VERIFY
env.CompareAndLogList(linq, dd);
}
}
public async Task TestCountChildrenWithFilterAsync()
{
using (var env = new MethodEnvironment(classEnv))
{
//SETUP
var linq = await env.Db.EfParents.Select(x => x.Children.Count(y => y.ChildInt == 123)).ToListAsync();
//ATTEMPT
env.AboutToUseDelegateDecompiler();
var dd = await env.Db.EfParents.Select(x => x.CountChildrenWithFilter).DecompileAsync().ToListAsync();
//VERIFY
env.CompareAndLogList(linq, dd);
}
}
public void TestOrderByChildrenCountThenByStringLength()
{
using (var env = new MethodEnvironment(classEnv))
{
//SETUP
var linq = env.Db.EfParents.OrderBy(x => x.Children.Count).ThenBy(x => x.ParentString.Length).Select(x => x.EfParentId).ToList();
//ATTEMPT
env.AboutToUseDelegateDecompiler();
var dd = env.Db.EfParents.OrderBy(x => x.CountChildren).ThenBy(x => x.GetStringLength).Select(x => x.EfParentId).Decompile().ToList();
//VERIFY
env.CompareAndLogList(linq, dd);
}
}
public void TestWhereAnyChildrenThenOrderByThenSkipTake()
{
using (var env = new MethodEnvironment(classEnv))
{
//SETUP
var linq = env.Db.EfParents.Where(x => x.Children.Any()).OrderBy(x => x.Children.Count).Select(x => x.EfParentId).Skip(1).Take(1).ToList();
//ATTEMPT
env.AboutToUseDelegateDecompiler();
var dd = env.Db.EfParents.Where(x => x.AnyChildren).OrderBy(x => x.CountChildren).Select(x => x.EfParentId).Decompile().Skip(1).Take(1).ToList();
//VERIFY
env.CompareAndLogList(linq, dd);
}
}
public async Task TestCountChildrenWithFilterByExternalClosure2Async()
{
using (var env = new MethodEnvironment(classEnv))
{
//SETUP
var i = 123;
var j = 456;
var linq = await env.Db.EfParents.Select(x => x.Children.Count(y => y.ChildInt == i && y.EfParentId == j)).ToListAsync();
//ATTEMPT
env.AboutToUseDelegateDecompiler();
var dd = await env.Db.EfParents.Select(x => x.GetCountChildrenWithFilterByExternalClosure(i, j)).DecompileAsync().ToListAsync();
//VERIFY
env.CompareAndLogList(linq, dd);
}
}
public void TestDelegateDEcompilerExceptionOk()
{
try
{
using (var env = new MethodEnvironment(classEnv))
{
//SETUP
//ATTEMPT
env.AboutToUseDelegateDecompiler();
throw new Exception("Failed");
}
}
catch
{
//VERIFY
classEnv.GetLastMethodLog().State.ShouldEqual(LogStates.NotSupported);
}
}
public async Task TestSingleIntEqualsUniqueValueAsync()
{
using (var env = new MethodEnvironment(classEnv))
{
//SETUP
var linq = (await
env.Db.EfParents.Select(x => new { x.EfParentId, x.ParentInt })
.SingleAsync(x => x.ParentInt == DatabaseHelpers.ParentIntUniqueValue)).EfParentId;
//ATTEMPT
env.AboutToUseDelegateDecompiler();
var dd = (await
env.Db.EfParents.Select(x => new { x.EfParentId, x.IntEqualsUniqueValue })
.DecompileAsync()
.SingleAsync(x => x.IntEqualsUniqueValue))
.EfParentId;
//VERIFY
env.CompareAndLogSingleton(linq, dd);
}
}
