public void Test_Avg() { DetachedCriteria expected = DetachedCriteria.For <Person>() .SetProjection(Projections.Avg("Age")); DetachedCriteria actual = DetachedCriteria.For <Person>() .SetProjection(LambdaProjection.Avg <Person>(p => p.Age)); AssertCriteriaAreEqual(expected, actual); }
public void Test_GroupProperty() { DetachedCriteria expected = DetachedCriteria.For <Person>() .SetProjection(Projections.GroupProperty("Name")); DetachedCriteria actual = DetachedCriteria.For <Person>() .SetProjection(LambdaProjection.GroupProperty <Person>(p => p.Name)); AssertCriteriaAreEqual(expected, actual); }
public void TestCountDistinct() { DetachedCriteria expected = DetachedCriteria.For <Person>() .SetProjection(Projections.CountDistinct("Name")); DetachedCriteria actual = DetachedCriteria.For <Person>() .SetProjection(LambdaProjection.CountDistinct <Person>(p => p.Name)); AssertCriteriaAreEqual(expected, actual); }
public void Test_AliasedProperty() { DetachedCriteria expected = DetachedCriteria.For <Person>("personAlias") .SetProjection(Projections.Property("personAlias.Age")); Person personAlias = null; DetachedCriteria actual = DetachedCriteria <Person> .Create(() => personAlias) .SetProjection(LambdaProjection.Property(() => personAlias.Age)); AssertCriteriaAreEqual(expected, actual); }
public void Test_PropertyAliasUsingFluentInterface() { DetachedCriteria expected = DetachedCriteria.For <Person>() .SetProjection(Projections.Property("Age").As("ageAlias")); int ageAlias = 0; DetachedCriteria actual = DetachedCriteria.For <Person>() .SetProjection(LambdaProjection.Property <Person>(p => p.Age).As(() => ageAlias)); AssertCriteriaAreEqual(expected, actual); }
public void TestPropertyAliasWithValueType() { DetachedCriteria expected = DetachedCriteria.For <Person>() .SetProjection(Projections.Alias(Projections.Property("Age"), "ageAlias")); int ageAlias = 0; DetachedCriteria actual = DetachedCriteria.For <Person>() .SetProjection(LambdaProjection.Alias(LambdaProjection.Property <Person>(p => p.Age), () => ageAlias)); AssertCriteriaAreEqual(expected, actual); }
public void Test_PropertyUsingAlias() { DetachedCriteria expected = DetachedCriteria.For <Person>() .SetProjection(Projections.Alias(Projections.Property("Name"), "nameAlias")); string nameAlias = null; DetachedCriteria actual = DetachedCriteria.For <Person>() .SetProjection(LambdaProjection.Alias(LambdaProjection.Property <Person>(p => p.Name), () => nameAlias)); AssertCriteriaAreEqual(expected, actual); }
public void TestCountDistinctUsingAlias() { DetachedCriteria expected = DetachedCriteria.For <Person>("personAlias") .SetProjection(Projections.CountDistinct("personAlias.Age")); Person personAlias = null; DetachedCriteria actual = DetachedCriteria <Person> .Create(() => personAlias) .SetProjection(LambdaProjection.CountDistinct(() => personAlias.Age)); AssertCriteriaAreEqual(expected, actual); }