- ComplexNavigationsQueryTestBase<TFixture> - MyInnerDto 
- MyOuterDto 
- ComplexNavigationsQueryTestBase(TFixture) 
- Accessing_optional_property_inside_result_operator_subquery(Boolean) 
- Collection_FirstOrDefault_entity_collection_accesses_in_projection(Boolean) 
- Collection_FirstOrDefault_entity_reference_accesses_in_projection(Boolean) 
- Collection_FirstOrDefault_property_accesses_in_projection(Boolean) 
- Comparing_collection_navigation_on_optional_reference_to_null(Boolean) 
- Complex_navigations_with_predicate_projected_into_anonymous_type(Boolean) 
- Complex_navigations_with_predicate_projected_into_anonymous_type2(Boolean) 
- Complex_query_with_let_collection_SelectMany(Boolean) 
- Complex_query_with_optional_navigations_and_client_side_evaluation(Boolean) 
- Composite_key_join_on_groupby_aggregate_projecting_only_grouping_key(Boolean) 
- Composite_key_join_on_groupby_aggregate_projecting_only_grouping_key2(Boolean) 
- Contains_over_optional_navigation_with_null_column(Boolean) 
- Contains_over_optional_navigation_with_null_constant(Boolean) 
- Contains_over_optional_navigation_with_null_entity_reference(Boolean) 
- Contains_over_optional_navigation_with_null_parameter(Boolean) 
- Contains_with_subquery_optional_navigation_and_constant_item(Boolean) 
- Contains_with_subquery_optional_navigation_scalar_distinct_and_constant_item(Boolean) 
- Correlated_nested_subquery_doesnt_project_unnecessary_columns_in_top_level(Boolean) 
- Correlated_nested_two_levels_up_subquery_doesnt_project_unnecessary_columns_in_top_level(Boolean) 
- Correlated_projection_with_first(Boolean) 
- Correlated_subquery_doesnt_project_unnecessary_columns_in_top_level_join(Boolean) 
- Correlated_subquery_doesnt_project_unnecessary_columns_in_top_level(Boolean) 
- CreateContext() 
- Element_selector_with_coalesce_repeated_in_aggregate(Boolean) 
- Entity_equality_empty(Boolean) 
- Entries_for_detached_entities_are_removed(Boolean) 
- Explicit_GroupJoin_in_subquery_with_multiple_result_operator_distinct_count_materializes_main_clause(Boolean) 
- Explicit_GroupJoin_in_subquery_with_scalar_result_operator(Boolean) 
- Explicit_GroupJoin_in_subquery_with_unrelated_projection(Boolean) 
- Explicit_GroupJoin_in_subquery_with_unrelated_projection2(Boolean) 
- Explicit_GroupJoin_in_subquery_with_unrelated_projection3(Boolean) 
- Explicit_GroupJoin_in_subquery_with_unrelated_projection4(Boolean) 
- GroupBy_aggregate_where_required_relationship_2(Boolean) 
- GroupBy_aggregate_where_required_relationship(Boolean) 
- GroupJoin_client_method_in_OrderBy(Boolean) 
- GroupJoin_client_method_on_outer(Boolean) 
- GroupJoin_in_subquery_with_client_projection_nested1(Boolean) 
- GroupJoin_in_subquery_with_client_projection_nested2(Boolean) 
- GroupJoin_in_subquery_with_client_projection(Boolean) 
- GroupJoin_in_subquery_with_client_result_operator(Boolean) 
- GroupJoin_on_a_subquery_containing_another_GroupJoin_projecting_inner(Boolean) 
- GroupJoin_on_a_subquery_containing_another_GroupJoin_projecting_outer_with_client_method(Boolean) 
- GroupJoin_on_a_subquery_containing_another_GroupJoin_projecting_outer(Boolean) 
- GroupJoin_on_a_subquery_containing_another_GroupJoin_with_orderby_on_inner_sequence_projecting_inner(Boolean) 
- GroupJoin_on_left_side_being_a_subquery(Boolean) 
- GroupJoin_on_right_side_being_a_subquery(Boolean) 
- GroupJoin_SelectMany_DefaultIfEmpty_with_predicate_using_closure_nested_same_param(Boolean) 
- GroupJoin_SelectMany_DefaultIfEmpty_with_predicate_using_closure_nested(Boolean) 
- GroupJoin_SelectMany_DefaultIfEmpty_with_predicate_using_closure(Boolean) 
- GroupJoin_SelectMany_with_predicate_using_closure_nested_same_param(Boolean) 
- GroupJoin_SelectMany_with_predicate_using_closure_nested(Boolean) 
- GroupJoin_SelectMany_with_predicate_using_closure(Boolean) 
- GroupJoin_with_complex_subquery_with_joins_does_not_get_flattened(Boolean) 
- GroupJoin_with_complex_subquery_with_joins_does_not_get_flattened2(Boolean) 
- GroupJoin_with_complex_subquery_with_joins_does_not_get_flattened3(Boolean) 
- GroupJoin_with_subquery_on_inner_and_no_DefaultIfEmpty(Boolean) 
- GroupJoin_with_subquery_on_inner(Boolean) 
- GroupJoin_without_DefaultIfEmpty(Boolean) 
- Include_multiple_collections_on_same_level(Boolean) 
- Include_reference_and_project_into_anonymous_type(Boolean) 
- Include_reference_with_groupby_in_subquery(Boolean) 
- Include_with_all_method_include_gets_ignored(Boolean) 
- Include_with_optional_navigation(Boolean) 
- Include1(Boolean) 
- Include10(Boolean) 
- Include11(Boolean) 
- Include12(Boolean) 
- Include13(Boolean) 
- Include14(Boolean) 
- Include17(Boolean) 
- Include18_1_1(Boolean) 
- Include18_1(Boolean) 
- Include18_2(Boolean) 
- Include18_3_1(Boolean) 
- Include18_3_2(Boolean) 
- Include18_3_3(Boolean) 
- Include18_3(Boolean) 
- Include18_4(Boolean) 
- Include18(Boolean) 
- Include19(Boolean) 
- Include2(Boolean) 
- Include3(Boolean) 
- Include4(Boolean) 
- Include5(Boolean) 
- Include6(Boolean) 
- Include7(Boolean) 
- Include8(Boolean) 
- Include9(Boolean) 
- Including_reference_navigation_and_projecting_collection_navigation_2(Boolean) 
- Join_condition_optimizations_applied_correctly_when_anonymous_type_with_multiple_properties(Boolean) 
- Join_condition_optimizations_applied_correctly_when_anonymous_type_with_single_property(Boolean) 
- Join_flattening_bug_4539(Boolean) 
- Join_navigation_deeply_nested_non_key_join(Boolean) 
- Join_navigation_deeply_nested_required(Boolean) 
- Join_navigation_in_inner_selector(Boolean) 
- Join_navigation_in_outer_selector_translated_to_extra_join_nested(Boolean) 
- Join_navigation_in_outer_selector_translated_to_extra_join_nested2(Boolean) 
- Join_navigation_in_outer_selector_translated_to_extra_join(Boolean) 
- Join_navigation_key_access_optional(Boolean) 
- Join_navigation_key_access_required(Boolean) 
- Join_navigation_nested(Boolean) 
- Join_navigation_nested2(Boolean) 
- Join_navigation_non_key_join(Boolean) 
- Join_navigation_self_ref(Boolean) 
- Join_navigations_in_inner_selector_translated_without_collision(Boolean) 
- Join_with_navigations_in_the_result_selector1(Boolean) 
- Join_with_navigations_in_the_result_selector2(Boolean) 
- Join_with_orderby_on_inner_sequence_navigation_non_key_join(Boolean) 
- Join_with_result_selector_returning_queryable_throws_validation_error(Boolean) 
- Key_equality_navigation_converted_to_FK(Boolean) 
- Key_equality_two_conditions_on_same_navigation(Boolean) 
- Key_equality_two_conditions_on_same_navigation2(Boolean) 
- Key_equality_using_property_method_and_member_expression1(Boolean) 
- Key_equality_using_property_method_and_member_expression2(Boolean) 
- Key_equality_using_property_method_and_member_expression3(Boolean) 
- Key_equality_using_property_method_nested(Boolean) 
- Key_equality_using_property_method_nested2(Boolean) 
- Key_equality_using_property_method_required(Boolean) 
- Key_equality_using_property_method_required2(Boolean) 
- Key_equality_when_sentinel_ef_property(Boolean) 
- Let_let_contains_from_outer_let(Boolean) 
- Level4_Include(Boolean) 
- Manually_created_left_join_propagates_nullability_to_navigations(Boolean) 
- Max_in_multi_level_nested_subquery(Boolean) 
- Member_doesnt_get_pushed_down_into_subquery_with_result_operator(Boolean) 
- Member_over_null_check_ternary_and_nested_anonymous_type(Boolean) 
- Member_over_null_check_ternary_and_nested_dto_type(Boolean) 
- Member_pushdown_chain_3_levels_deep_entity(Boolean) 
- Member_pushdown_chain_3_levels_deep(Boolean) 
- Member_pushdown_with_collection_navigation_in_the_middle(Boolean) 
- Member_pushdown_with_multiple_collections(Boolean) 
- Method_call_on_optional_navigation_translates_to_null_conditional_properly_for_arguments(Boolean) 
- Multi_include_with_groupby_in_subquery(Boolean) 
- Multi_level_include_with_short_circuiting(Boolean) 
- Multi_level_navigation_compared_to_null(Boolean) 
- Multi_level_navigation_with_same_navigation_compared_to_null(Boolean) 
- Multiple_collection_FirstOrDefault_followed_by_member_access_in_projection(Boolean) 
- Multiple_conditionals_in_projection(Boolean) 
- Multiple_joins_groupby_predicate(Boolean) 
- Multiple_optional_navs_should_not_deadlock(Boolean) 
- Multiple_required_navigation_using_multiple_selects_with_EF_Property_Include(Boolean) 
- Multiple_required_navigation_using_multiple_selects_with_Include(Boolean) 
- Multiple_required_navigation_using_multiple_selects_with_string_based_Include(Boolean) 
- Multiple_required_navigation_with_EF_Property_Include(Boolean) 
- Multiple_required_navigation_with_string_based_Include(Boolean) 
- Multiple_required_navigations_with_Include(Boolean) 
- Multiple_select_many_in_projection(Boolean) 
- Multiple_SelectMany_calls(Boolean) 
- Multiple_SelectMany_with_EF_Property_Include(Boolean) 
- Multiple_SelectMany_with_navigation_and_explicit_DefaultIfEmpty(Boolean) 
- Multiple_SelectMany_with_nested_navigations_and_explicit_DefaultIfEmpty_joined_together(Boolean) 
- Multiple_SelectMany_with_string_based_Include(Boolean) 
- Nav_rewrite_doesnt_apply_null_protection_for_function_arguments(Boolean) 
- Navigation_inside_method_call_translated_to_join(Boolean) 
- Navigation_inside_method_call_translated_to_join2(Boolean) 
- Navigation_key_access_optional_comparison(Boolean) 
- Navigation_key_access_required_comparison(Boolean) 
- Navigation_with_same_navigation_compared_to_null(Boolean) 
- Navigations_compared_to_each_other1(Boolean) 
- Navigations_compared_to_each_other2(Boolean) 
- Navigations_compared_to_each_other3(Boolean) 
- Navigations_compared_to_each_other4(Boolean) 
- Navigations_compared_to_each_other5(Boolean) 
- Nested_group_join_with_take(Boolean) 
- Nested_object_constructed_from_group_key_properties(Boolean) 
- Nested_SelectMany_correlated_with_join_table_correctly_translated_to_apply(Boolean) 
- Null_check_different_structure_does_not_remove_null_checks(Boolean) 
- Null_check_removal_applied_recursively_complex(Boolean) 
- Null_check_removal_applied_recursively(Boolean) 
- Null_conditional_is_not_applied_explicitly_for_optional_navigation(Boolean) 
- Null_reference_protection_complex_client_eval(Boolean) 
- Null_reference_protection_complex_materialization(Boolean) 
- Null_reference_protection_complex(Boolean) 
- Optional_navigation_in_subquery_with_unrelated_projection(Boolean) 
- Optional_navigation_inside_method_call_translated_to_join_keeps_original_nullability(Boolean) 
- Optional_navigation_inside_method_call_translated_to_join(Boolean) 
- Optional_navigation_inside_nested_method_call_translated_to_join_keeps_original_nullability_also_for_arguments(Boolean) 
- Optional_navigation_inside_nested_method_call_translated_to_join_keeps_original_nullability(Boolean) 
- Optional_navigation_inside_nested_method_call_translated_to_join(Boolean) 
- Optional_navigation_inside_property_method_translated_to_join(Boolean) 
- Optional_navigation_projected_into_DTO(Boolean) 
- Optional_navigation_propagates_nullability_to_manually_created_left_join1(Boolean) 
- Optional_navigation_propagates_nullability_to_manually_created_left_join2(Boolean) 
- Optional_navigation_take_optional_navigation(Boolean) 
- Optional_navigation_with_Include(Boolean) 
- Order_by_key_of_anonymous_type_projected_navigation_doesnt_get_optimized_into_FK_access_subquery(Boolean) 
- Order_by_key_of_navigation_similar_to_projected_gets_optimized_into_FK_access(Boolean) 
- Order_by_key_of_projected_navigation_doesnt_get_optimized_into_FK_access_subquery(Boolean) 
- Order_by_key_of_projected_navigation_doesnt_get_optimized_into_FK_access1(Boolean) 
- Order_by_key_of_projected_navigation_doesnt_get_optimized_into_FK_access2(Boolean) 
- Order_by_key_of_projected_navigation_doesnt_get_optimized_into_FK_access3(Boolean) 
- OrderBy_collection_count_ThenBy_reference_navigation(Boolean) 
- OrderBy_nav_prop_reference_optional_via_DefaultIfEmpty(Boolean) 
- OrderBy_nav_prop_reference_optional(Boolean) 
- Project_collection_navigation_count(Boolean) 
- Project_shadow_properties1(Boolean) 
- Project_shadow_properties10(Boolean) 
- Project_shadow_properties2(Boolean) 
- Project_shadow_properties3(Boolean) 
- Project_shadow_properties4(Boolean) 
- Project_shadow_properties5(Boolean) 
- Project_shadow_properties6(Boolean) 
- Project_shadow_properties7(Boolean) 
- Project_shadow_properties8(Boolean) 
- Project_shadow_properties9(Boolean) 
- Projecting_columns_with_same_name_from_different_entities_making_sure_aliasing_works_after_Distinct(Boolean) 
- Projection_select_correct_table_from_subquery_when_materialization_is_not_required(Boolean) 
- Projection_select_correct_table_in_subquery_when_materialization_is_not_required_in_multiple_joins(Boolean) 
- Projection_select_correct_table_with_anonymous_projection_in_subquery(Boolean) 
- Prune_does_not_throw_null_ref(Boolean) 
- Query_source_materialization_bug_4547(Boolean) 
- Required_navigation_on_a_subquery_with_complex_projection_and_First(Boolean) 
- Required_navigation_on_a_subquery_with_First_in_predicate(Boolean) 
- Required_navigation_on_a_subquery_with_First_in_projection(Boolean) 
- Result_operator_nav_prop_reference_optional_Average_with_identity_selector(Boolean) 
- Result_operator_nav_prop_reference_optional_Average_without_selector(Boolean) 
- Result_operator_nav_prop_reference_optional_Average(Boolean) 
- Result_operator_nav_prop_reference_optional_Max(Boolean) 
- Result_operator_nav_prop_reference_optional_Min(Boolean) 
- Result_operator_nav_prop_reference_optional_Sum(Boolean) 
- Result_operator_nav_prop_reference_optional_via_DefaultIfEmpty(Boolean) 
- RewriteExpectedQueryExpression(Expression) 
- Select_join_subquery_containing_filter_and_distinct(Boolean) 
- Select_join_with_key_selector_being_a_subquery(Boolean) 
- Select_multiple_nav_prop_optional_required(Boolean) 
- Select_multiple_nav_prop_reference_optional(Boolean) 
- Select_multiple_nav_prop_reference_required(Boolean) 
- Select_multiple_nav_prop_reference_required2(Boolean) 
- Select_nav_prop_reference_optional1_via_DefaultIfEmpty(Boolean) 
- Select_nav_prop_reference_optional1(Boolean) 
- Select_nav_prop_reference_optional2_via_DefaultIfEmpty(Boolean) 
- Select_nav_prop_reference_optional2(Boolean) 
- Select_nav_prop_reference_optional3(Boolean) 
- Select_optional_navigation_property_string_concat(Boolean) 
- Select_projecting_queryable_followed_by_Join(Boolean) 
- Select_projecting_queryable_followed_by_SelectMany(Boolean) 
- Select_projecting_queryable_in_anonymous_projection_followed_by_Join(Boolean) 
- Select_subquery_with_client_eval_and_multi_level_navigation(Boolean) 
- Select_subquery_with_client_eval_and_navigation1(Boolean) 
- Select_subquery_with_client_eval_and_navigation2(Boolean) 
- Select_with_joined_where_clause_cast_using_as(Boolean) 
- SelectMany_navigation_comparison1(Boolean) 
- SelectMany_navigation_comparison2(Boolean) 
- SelectMany_navigation_comparison3(Boolean) 
- SelectMany_navigation_property_and_filter_after(Boolean) 
- SelectMany_navigation_property_and_filter_before(Boolean) 
- SelectMany_navigation_property_and_projection(Boolean) 
- SelectMany_navigation_property_with_another_navigation_in_subquery(Boolean) 
- SelectMany_navigation_property(Boolean) 
- SelectMany_nested_navigation_property_optional_and_projection(Boolean) 
- SelectMany_nested_navigation_property_required(Boolean) 
- SelectMany_subquery_with_custom_projection(Boolean) 
- SelectMany_where_with_subquery(Boolean) 
- SelectMany_with_EF_Property_Include1(Boolean) 
- SelectMany_with_navigation_and_explicit_DefaultIfEmpty(Boolean) 
- SelectMany_with_navigation_filter_and_explicit_DefaultIfEmpty(Boolean) 
- SelectMany_with_navigation_filter_paging_and_explicit_DefaultIfEmpty(Boolean) 
- SelectMany_with_nested_navigation_and_explicit_DefaultIfEmpty(Boolean) 
- SelectMany_with_nested_navigation_filter_and_explicit_DefaultIfEmpty(Boolean) 
- SelectMany_with_nested_navigations_and_additional_joins_outside_of_SelectMany(Boolean) 
- SelectMany_with_nested_navigations_and_explicit_DefaultIfEmpty_followed_by_Select_required_navigation_using_different_navs(Boolean) 
- SelectMany_with_nested_navigations_and_explicit_DefaultIfEmpty_followed_by_Select_required_navigation_using_same_navs(Boolean) 
- SelectMany_with_nested_navigations_explicit_DefaultIfEmpty_and_additional_joins_outside_of_SelectMany(Boolean) 
- SelectMany_with_nested_navigations_explicit_DefaultIfEmpty_and_additional_joins_outside_of_SelectMany2(Boolean) 
- SelectMany_with_nested_navigations_explicit_DefaultIfEmpty_and_additional_joins_outside_of_SelectMany3(Boolean) 
- SelectMany_with_nested_navigations_explicit_DefaultIfEmpty_and_additional_joins_outside_of_SelectMany4(Boolean) 
- SelectMany_with_nested_required_navigation_filter_and_explicit_DefaultIfEmpty(Boolean) 
- SelectMany_with_outside_reference_to_joined_table_correctly_translated_to_apply(Boolean) 
- SelectMany_with_string_based_Include1(Boolean) 
- SelectMany_with_string_based_Include2(Boolean) 
- SelectMany_without_collection_selector_returning_queryable(Boolean) 
- Simple_level1_include(Boolean) 
- Simple_level1_level2_GroupBy_Count(Boolean) 
- Simple_level1_level2_GroupBy_Having_Count(Boolean) 
- Simple_level1_level2_include(Boolean) 
- Simple_level1_level2_level3_include(Boolean) 
- Simple_level1(Boolean) 
- Single_select_many_in_projection_with_take(Boolean) 
- String_include_multiple_derived_collection_navigation_with_same_name_and_different_type_nested_also_includes_partially_matching_navigation_chains(Boolean) 
- String_include_multiple_derived_collection_navigation_with_same_name_and_different_type(Boolean) 
- String_include_multiple_derived_collection_navigation_with_same_name_and_same_type(Boolean) 
- String_include_multiple_derived_navigation_with_same_name_and_different_type_nested_also_includes_partially_matching_navigation_chains(Boolean) 
- String_include_multiple_derived_navigation_with_same_name_and_different_type(Boolean) 
- String_include_multiple_derived_navigation_with_same_name_and_same_type(Boolean) 
- String_include_multiple_derived_navigations_complex(Boolean) 
- Subquery_with_Distinct_Skip_FirstOrDefault_without_OrderBy(Boolean) 
- Sum_with_filter_with_include_selector_cast_using_as(Boolean) 
- Sum_with_selector_cast_using_as(Boolean) 
- Union_over_entities_with_different_nullability(Boolean) 
- Where_complex_predicate_with_with_nav_prop_and_OrElse1(Boolean) 
- Where_complex_predicate_with_with_nav_prop_and_OrElse2(Boolean) 
- Where_complex_predicate_with_with_nav_prop_and_OrElse3(Boolean) 
- Where_complex_predicate_with_with_nav_prop_and_OrElse4(Boolean) 
- Where_multiple_nav_prop_optional_required(Boolean) 
- Where_multiple_nav_prop_reference_optional_compared_to_null1(Boolean) 
- Where_multiple_nav_prop_reference_optional_compared_to_null2(Boolean) 
- Where_multiple_nav_prop_reference_optional_compared_to_null3(Boolean) 
- Where_multiple_nav_prop_reference_optional_compared_to_null4(Boolean) 
- Where_multiple_nav_prop_reference_optional_compared_to_null5(Boolean) 
- Where_multiple_nav_prop_reference_optional_member_compared_to_null(Boolean) 
- Where_multiple_nav_prop_reference_optional_member_compared_to_value(Boolean) 
- Where_nav_prop_reference_optional1_via_DefaultIfEmpty(Boolean) 
- Where_nav_prop_reference_optional1(Boolean) 
- Where_nav_prop_reference_optional2_via_DefaultIfEmpty(Boolean) 
- Where_nav_prop_reference_optional2(Boolean) 
- Where_navigation_property_to_collection_of_original_entity_type(Boolean) 
- Where_navigation_property_to_collection(Boolean) 
- Where_navigation_property_to_collection2(Boolean) 
- Where_on_multilevel_reference_in_subquery_with_outer_projection(Boolean) 
- Where_predicate_on_optional_reference_navigation(Boolean) 
 
net10.0-windows7.0
    namespace Microsoft.EntityFrameworkCore.Query
{
    public abstract class ComplexNavigationsQueryTestBase<TFixture> : QueryTestBase<TFixture>
        where TFixture, new(), ComplexNavigationsQueryFixtureBase
    {
        [ConditionalTheory]
        [MemberData("IsAsyncData", new[] {  })]
        public virtual Task Optional_navigation_inside_nested_method_call_translated_to_join_keeps_original_nullability_also_for_arguments(bool async);
    }
}
            | .NET | 9.010.0 | 
|---|---|
| Information specific to net10.0 | |
| Platforms | This API is only available when you target a specific platform: | 
| Windows | 7.0 | 
| Information specific to net10.0-windows7.0 | |
| Assembly | Microsoft.EntityFrameworkCore.Specification.Tests , Version=9.0.3.0, PublicKeyToken=adb9793829ddae60 | 
| Referencing | Your project needs a package reference to  | 
| Package | Microsoft.EntityFrameworkCore.Specification.Tests (9.0.3) net9.0 | 
| Platform Restrictions | This API is supported on all platforms. | 
- Built-in API
- Package-provided API