public void Get_students_no_filtered_inlude_no_filter_select_expand_definition() { ICollection <StudentModel> students = ProjectionOperations <StudentModel, Student> .GetItems ( serviceProvider.GetRequiredService <ISchoolRepository>(), serviceProvider.GetRequiredService <IMapper>(), new FilterLambdaOperatorParameters ( new GreaterThanBinaryOperatorParameters ( new CountOperatorParameters ( new MemberSelectorOperatorParameters("Enrollments", new ParameterOperatorParameters("f")) ), new ConstantOperatorParameters(0) ), typeof(StudentModel), "f" ), null, null ); Assert.Null(students.First().Enrollments); }
public void Get_students_with_filtered_inlude_with_filter_select_expand_definition() { ICollection <StudentModel> students = ProjectionOperations <StudentModel, Student> .GetItems ( serviceProvider.GetRequiredService <ISchoolRepository>(), serviceProvider.GetRequiredService <IMapper>(), new FilterLambdaOperatorParameters ( new GreaterThanBinaryOperatorParameters ( new CountOperatorParameters ( new MemberSelectorOperatorParameters("Enrollments", new ParameterOperatorParameters("f")) ), new ConstantOperatorParameters(0) ), typeof(StudentModel), "f" ), null, new SelectExpandDefinitionParameters ( null, new List <SelectExpandItemParameters> { new SelectExpandItemParameters ( "enrollments", new SelectExpandItemFilterParameters ( new FilterLambdaOperatorParameters ( new EqualsBinaryOperatorParameters ( new MemberSelectorOperatorParameters("enrollmentID", new ParameterOperatorParameters("a")), new ConstantOperatorParameters(-1) ), typeof(EnrollmentModel), "a" ) ), null, null, null ) } ) ); Assert.False(students.First().Enrollments.Any()); }
public void Get_enrollments_filtered_by_grade_letter() { ICollection <EnrollmentModel> enrollments = ProjectionOperations <EnrollmentModel, Enrollment> .GetItems ( serviceProvider.GetRequiredService <ISchoolRepository>(), serviceProvider.GetRequiredService <IMapper>(), new FilterLambdaOperatorParameters ( new EqualsBinaryOperatorParameters ( new MemberSelectorOperatorParameters("GradeLetter", new ParameterOperatorParameters("f")), new ConstantOperatorParameters("A") ), typeof(EnrollmentModel), "f" ), null, null ); Assert.Single(enrollments); }
public void Get_students_with_filtered_inlude_no_filter_sort_skip_and_take_select_expand_definition() { ICollection <StudentModel> students = ProjectionOperations <StudentModel, Student> .GetItems ( serviceProvider.GetRequiredService <ISchoolRepository>(), serviceProvider.GetRequiredService <IMapper>(), new FilterLambdaOperatorParameters ( new AndBinaryOperatorParameters ( new EqualsBinaryOperatorParameters ( new MemberSelectorOperatorParameters("FirstName", new ParameterOperatorParameters("f")), new ConstantOperatorParameters("Carson") ), new EqualsBinaryOperatorParameters ( new MemberSelectorOperatorParameters("LastName", new ParameterOperatorParameters("f")), new ConstantOperatorParameters("Alexander") ) ), typeof(StudentModel), "f" ), null, new SelectExpandDefinitionParameters ( null, new List <SelectExpandItemParameters> { new SelectExpandItemParameters ( "enrollments", new SelectExpandItemFilterParameters ( new FilterLambdaOperatorParameters ( new GreaterThanBinaryOperatorParameters ( new MemberSelectorOperatorParameters("enrollmentID", new ParameterOperatorParameters("a")), new ConstantOperatorParameters(0) ), typeof(EnrollmentModel), "a" ) ), new SelectExpandItemQueryFunctionParameters ( new SortCollectionParameters ( new List <SortDescriptionParameters> { new SortDescriptionParameters("Grade", ListSortDirection.Descending) }, 1, 2 ) ), null, null ) } ) ); Assert.Single(students); Assert.Equal(2, students.First().Enrollments.Count); Assert.Equal("A", students.First().Enrollments.Last().GradeLetter); }
public void Get_students_with_filtered_inlude_no_filter_sorted_select_expand_definition() { ICollection <StudentModel> students = ProjectionOperations <StudentModel, Student> .GetItems ( serviceProvider.GetRequiredService <ISchoolRepository>(), serviceProvider.GetRequiredService <IMapper>(), new FilterLambdaOperatorParameters ( new GreaterThanBinaryOperatorParameters ( new CountOperatorParameters ( new MemberSelectorOperatorParameters("Enrollments", new ParameterOperatorParameters("f")) ), new ConstantOperatorParameters(0) ), typeof(StudentModel), "f" ), null, new SelectExpandDefinitionParameters ( null, new List <SelectExpandItemParameters> { new SelectExpandItemParameters ( "enrollments", new SelectExpandItemFilterParameters ( new FilterLambdaOperatorParameters ( new GreaterThanBinaryOperatorParameters ( new MemberSelectorOperatorParameters("enrollmentID", new ParameterOperatorParameters("a")), new ConstantOperatorParameters(0) ), typeof(EnrollmentModel), "a" ) ), new SelectExpandItemQueryFunctionParameters ( new SortCollectionParameters ( new List <SortDescriptionParameters> { new SortDescriptionParameters("Grade", ListSortDirection.Ascending) }, null, null ) ), null, null ) } ) ); Assert.True(students.First().Enrollments.Count > 0); Assert.True ( string.Compare ( students.First().Enrollments.First().GradeLetter, students.Skip(1).First().Enrollments.First().GradeLetter ) <= 0 ); }