- GearsOfWarQueryTestBase<TFixture> - MyDTO 
- GearsOfWarQueryTestBase(TFixture) 
- Accessing_derived_property_using_hard_and_soft_cast(Boolean) 
- Accessing_property_of_optional_navigation_in_child_projection_works(Boolean) 
- Accessing_reference_navigation_collection_composition_generates_single_query(Boolean) 
- All_with_optional_navigation_is_translated_to_sql(Boolean) 
- Anonymous_projection_take_followed_by_projecting_single_element_from_collection_navigation(Boolean) 
- Any_with_optional_navigation_as_subquery_predicate_is_translated_to_sql(Boolean) 
- Array_access_on_byte_array(Boolean) 
- Basic_query_gears(Boolean) 
- Bitwise_operation_with_non_null_parameter_optimizes_null_checks(Boolean) 
- Bitwise_operation_with_null_arguments(Boolean) 
- Bitwise_projects_values_in_select(Boolean) 
- Bool_projection_from_subquery_treated_appropriately_in_where(Boolean) 
- Byte_array_contains_literal(Boolean) 
- Byte_array_contains_parameter(Boolean) 
- Byte_array_filter_by_length_literal_does_not_cast_on_varbinary_n(Boolean) 
- Byte_array_filter_by_length_literal(Boolean) 
- Byte_array_filter_by_length_parameter_compiled() 
- Byte_array_filter_by_length_parameter(Boolean) 
- Byte_array_filter_by_SequenceEqual(Boolean) 
- Cast_OfType_works_correctly(Boolean) 
- Cast_ordered_subquery_to_base_type_using_typed_ToArray(Boolean) 
- Cast_result_operator_on_subquery_is_properly_lifted_to_a_convert(Boolean) 
- Cast_subquery_to_base_type_using_typed_ToList(Boolean) 
- Cast_to_derived_followed_by_include_and_FirstOrDefault(Boolean) 
- Cast_to_derived_followed_by_multiple_includes(Boolean) 
- Cast_to_derived_type_after_OfType_works(Boolean) 
- Cast_to_derived_type_causes_client_eval(Boolean) 
- Checked_context_throws_on_client_evaluation(Boolean) 
- Checked_context_with_addition_does_not_fail(Boolean) 
- Checked_context_with_cast_does_not_fail(Boolean) 
- ClearLog() 
- Client_eval_followed_by_aggregate_operation(Boolean) 
- Client_member_and_unsupported_string_Equals_in_the_same_query(Boolean) 
- Client_method_on_collection_navigation_in_additional_from_clause(Boolean) 
- Client_method_on_collection_navigation_in_order_by(Boolean) 
- Client_method_on_collection_navigation_in_outer_join_key(Boolean) 
- Client_method_on_collection_navigation_in_predicate_accessed_by_ef_property(Boolean) 
- Client_method_on_collection_navigation_in_predicate(Boolean) 
- Client_projection_with_nested_unmapped_property_bubbles_up_translation_failure_info(Boolean) 
- Client_side_equality_with_parameter_works_with_optional_navigations(Boolean) 
- Client<TEntity>(TEntity) 
- Coalesce_operator_in_predicate_with_other_conditions(Boolean) 
- Coalesce_operator_in_predicate(Boolean) 
- Coalesce_operator_in_projection_with_other_conditions(Boolean) 
- Coalesce_used_with_non_unicode_string_column_and_constant(Boolean) 
- Collection_navigation_access_on_derived_entity_using_cast_in_SelectMany(Boolean) 
- Collection_navigation_access_on_derived_entity_using_cast(Boolean) 
- Collection_navigation_ofType_filter_works(Boolean) 
- Collection_with_inheritance_and_join_include_joined(Boolean) 
- Collection_with_inheritance_and_join_include_source(Boolean) 
- CompareTo_used_with_non_unicode_string_column_and_constant(Boolean) 
- Comparing_entities_using_Equals_inheritance(Boolean) 
- Comparing_two_collection_navigations_composite_key(Boolean) 
- Comparing_two_collection_navigations_inheritance(Boolean) 
- Comparison_with_value_converted_subclass(Boolean) 
- Complex_GroupBy_after_set_operator_using_result_selector(Boolean) 
- Complex_GroupBy_after_set_operator(Boolean) 
- Complex_predicate_with_AndAlso_and_nullable_bool_property(Boolean) 
- Composite_key_entity_equal_null(Boolean) 
- Composite_key_entity_equal(Boolean) 
- Composite_key_entity_not_equal_null(Boolean) 
- Composite_key_entity_not_equal(Boolean) 
- Concat_anonymous_with_count(Boolean) 
- Concat_scalars_with_count(Boolean) 
- Concat_with_collection_navigations(Boolean) 
- Concat_with_count(Boolean) 
- Concat_with_scalar_projection(Boolean) 
- Conditional_expression_with_test_being_simplified_to_constant_complex(Boolean) 
- Conditional_expression_with_test_being_simplified_to_constant_simple(Boolean) 
- Conditional_with_conditions_evaluating_to_false_gets_optimized(Boolean) 
- Conditional_with_conditions_evaluating_to_true_gets_optimized(Boolean) 
- Constant_enum_with_same_underlying_value_as_previously_parameterized_int(Boolean) 
- Contains_on_byte_array_property_using_byte_column(Boolean) 
- Contains_on_collection_of_byte_subquery(Boolean) 
- Contains_on_collection_of_nullable_byte_subquery_null_constant(Boolean) 
- Contains_on_collection_of_nullable_byte_subquery_null_parameter(Boolean) 
- Contains_on_collection_of_nullable_byte_subquery(Boolean) 
- Contains_on_nullable_array_produces_correct_sql(Boolean) 
- Contains_on_readonly_enumerable(Boolean) 
- Contains_with_local_nullable_guid_list_closure(Boolean) 
- Correlated_collection_after_distinct_3_levels_without_original_identifiers(Boolean) 
- Correlated_collection_after_distinct_3_levels(Boolean) 
- Correlated_collection_order_by_constant_null_of_non_mapped_type(Boolean) 
- Correlated_collection_order_by_constant(Boolean) 
- Correlated_collection_take(Boolean) 
- Correlated_collection_via_SelectMany_with_Distinct_missing_indentifying_columns_in_projection(Boolean) 
- Correlated_collection_with_complex_order_by_funcletized_to_constant_bool(Boolean) 
- Correlated_collection_with_complex_OrderBy(Boolean) 
- Correlated_collection_with_distinct_3_levels(Boolean) 
- Correlated_collection_with_distinct_not_projecting_identifier_column_also_projecting_complex_expressions(Boolean) 
- Correlated_collection_with_distinct_not_projecting_identifier_column(Boolean) 
- Correlated_collection_with_distinct_projecting_identifier_column_and_correlation_key(Boolean) 
- Correlated_collection_with_distinct_projecting_identifier_column_composite_key(Boolean) 
- Correlated_collection_with_distinct_projecting_identifier_column(Boolean) 
- Correlated_collection_with_groupby_not_projecting_identifier_column_but_only_grouping_key_in_final_projection(Boolean) 
- Correlated_collection_with_groupby_not_projecting_identifier_column_with_group_aggregate_in_final_projection_multiple_grouping_keys(Boolean) 
- Correlated_collection_with_groupby_not_projecting_identifier_column_with_group_aggregate_in_final_projection(Boolean) 
- Correlated_collection_with_groupby_with_complex_grouping_key_not_projecting_identifier_column_with_group_aggregate_in_final_projection(Boolean) 
- Correlated_collection_with_inner_collection_references_element_two_levels_up(Boolean) 
- Correlated_collection_with_top_level_Count(Boolean) 
- Correlated_collection_with_top_level_FirstOrDefault(Boolean) 
- Correlated_collection_with_top_level_Last_with_order_by_on_inner(Boolean) 
- Correlated_collection_with_top_level_Last_with_orderby_on_outer(Boolean) 
- Correlated_collection_with_very_complex_order_by(Boolean) 
- Correlated_collections_basic_projecting_constant_bool(Boolean) 
- Correlated_collections_basic_projecting_constant(Boolean) 
- Correlated_collections_basic_projecting_single_property(Boolean) 
- Correlated_collections_basic_projection_composite_key(Boolean) 
- Correlated_collections_basic_projection_explicit_to_array(Boolean) 
- Correlated_collections_basic_projection_explicit_to_list(Boolean) 
- Correlated_collections_basic_projection_ordered(Boolean) 
- Correlated_collections_basic_projection(Boolean) 
- Correlated_collections_complex_scenario1(Boolean) 
- Correlated_collections_complex_scenario2(Boolean) 
- Correlated_collections_deeply_nested_left_join(Boolean) 
- Correlated_collections_different_collections_projected(Boolean) 
- Correlated_collections_from_left_join_with_additional_elements_projected_of_that_join(Boolean) 
- Correlated_collections_inner_subquery_predicate_references_outer_qsre(Boolean) 
- Correlated_collections_inner_subquery_selector_references_outer_qsre(Boolean) 
- Correlated_collections_left_join_with_self_reference(Boolean) 
- Correlated_collections_multiple_nested_complex_collections(Boolean) 
- Correlated_collections_naked_navigation_with_ToArray(Boolean) 
- Correlated_collections_naked_navigation_with_ToList_followed_by_projecting_count(Boolean) 
- Correlated_collections_naked_navigation_with_ToList(Boolean) 
- Correlated_collections_nested_inner_subquery_references_outer_qsre_one_level_up(Boolean) 
- Correlated_collections_nested_inner_subquery_references_outer_qsre_two_levels_up(Boolean) 
- Correlated_collections_nested_mixed_streaming_with_buffer1(Boolean) 
- Correlated_collections_nested_mixed_streaming_with_buffer2(Boolean) 
- Correlated_collections_nested_with_custom_ordering(Boolean) 
- Correlated_collections_nested(Boolean) 
- Correlated_collections_on_left_join_with_null_value(Boolean) 
- Correlated_collections_on_left_join_with_predicate(Boolean) 
- Correlated_collections_on_select_many(Boolean) 
- Correlated_collections_project_anonymous_collection_result(Boolean) 
- Correlated_collections_projection_of_collection_thru_navigation(Boolean) 
- Correlated_collections_same_collection_projected_multiple_times(Boolean) 
- Correlated_collections_similar_collection_projected_multiple_times(Boolean) 
- Correlated_collections_with_Distinct(Boolean) 
- Correlated_collections_with_FirstOrDefault(Boolean) 
- Correlated_collections_with_funky_orderby_complex_scenario1(Boolean) 
- Correlated_collections_with_funky_orderby_complex_scenario2(Boolean) 
- Correlated_collections_with_Skip(Boolean) 
- Correlated_collections_with_Take(Boolean) 
- Count_with_optional_navigation_is_translated_to_sql(Boolean) 
- CreateContext() 
- DateTimeOffset_Contains_Less_than_Greater_than(Boolean) 
- DateTimeOffset_Date_returns_datetime(Boolean) 
- DateTimeOffset_DateAdd_AddDays(Boolean) 
- DateTimeOffset_DateAdd_AddHours(Boolean) 
- DateTimeOffset_DateAdd_AddMilliseconds(Boolean) 
- DateTimeOffset_DateAdd_AddMinutes(Boolean) 
- DateTimeOffset_DateAdd_AddMonths(Boolean) 
- DateTimeOffset_DateAdd_AddSeconds(Boolean) 
- DateTimeOffset_DateAdd_AddYears(Boolean) 
- DateTimeOffset_to_unix_time_milliseconds(Boolean) 
- DateTimeOffset_to_unix_time_seconds(Boolean) 
- DateTimeOffsetNow_minus_timespan(Boolean) 
- Derived_reference_is_skipped_when_base_type(Boolean) 
- Distinct_on_subquery_doesnt_get_lifted(Boolean) 
- Distinct_with_optional_navigation_is_translated_to_sql(Boolean) 
- Double_order_by_binary_expression(Boolean) 
- Double_order_by_on_is_null(Boolean) 
- Double_order_by_on_Like(Boolean) 
- Double_order_by_on_nullable_bool_coming_from_optional_navigation(Boolean) 
- Double_order_by_on_string_compare(Boolean) 
- EF_Property_based_Include_navigation_on_derived_type(Boolean) 
- ElementAt_basic_with_OrderBy(Boolean) 
- ElementAtOrDefault_basic_with_OrderBy_parameter(Boolean) 
- ElementAtOrDefault_basic_with_OrderBy(Boolean) 
- Entity_equality_empty(Boolean) 
- Enum_array_contains(Boolean) 
- Enum_closure_typed_as_underlying_type_generates_correct_parameter_type(Boolean) 
- Enum_flags_closure_typed_as_different_type_generates_correct_parameter_type(Boolean) 
- Enum_flags_closure_typed_as_underlying_type_generates_correct_parameter_type(Boolean) 
- Enum_matching_take_value_gets_different_type_mapping(Boolean) 
- Filter_on_subquery_projecting_one_value_type_from_empty_collection(Boolean) 
- Filter_with_complex_predicate_containing_subquery(Boolean) 
- Filter_with_new_Guid_closure(Boolean) 
- Filter_with_new_Guid(Boolean) 
- Filtered_collection_projection_with_order_comparison_predicate_converted_to_join(Boolean) 
- Filtered_collection_projection_with_order_comparison_predicate_converted_to_join2(Boolean) 
- Filtered_collection_projection_with_order_comparison_predicate_converted_to_join3(Boolean) 
- Find_underlying_property_after_GroupJoin_DefaultIfEmpty(Boolean) 
- First_on_byte_array(Boolean) 
- FirstOrDefault_navigation_access_entity_equality_in_where_predicate_apply_peneding_selector(Boolean) 
- FirstOrDefault_on_empty_collection_of_DateTime_in_subquery(Boolean) 
- FirstOrDefault_over_int_compared_to_zero(Boolean) 
- FirstOrDefault_with_manually_created_groupjoin_is_translated_to_sql(Boolean) 
- GetValueOrDefault_in_filter_non_nullable_column(Boolean) 
- GetValueOrDefault_in_filter(Boolean) 
- GetValueOrDefault_in_order_by(Boolean) 
- GetValueOrDefault_in_projection(Boolean) 
- GetValueOrDefault_on_DateTimeOffset(Boolean) 
- GetValueOrDefault_with_argument_complex(Boolean) 
- GetValueOrDefault_with_argument(Boolean) 
- Group_by_nullable_property_and_project_the_grouping_key_HasValue(Boolean) 
- Group_by_nullable_property_HasValue_and_project_the_grouping_key(Boolean) 
- Group_by_on_StartsWith_with_null_parameter_as_argument(Boolean) 
- Group_by_over_projection_with_multiple_properties_accessed_thru_navigation(Boolean) 
- Group_by_with_aggregate_max_on_entity_type(Boolean) 
- Group_by_with_having_StartsWith_with_null_parameter_as_argument(Boolean) 
- Group_by_with_include_with_entity_in_result_selector(Boolean) 
- Groupby_anonymous_type_with_navigations_followed_up_by_anonymous_projection_and_orderby(Boolean) 
- GroupBy_Property_Include_Aggregate_with_anonymous_selector(Boolean) 
- GroupBy_Property_Include_Select_Average(Boolean) 
- GroupBy_Property_Include_Select_Count(Boolean) 
- GroupBy_Property_Include_Select_LongCount(Boolean) 
- GroupBy_Property_Include_Select_Max(Boolean) 
- GroupBy_Property_Include_Select_Min(Boolean) 
- GroupBy_Property_Include_Select_Sum(Boolean) 
- GroupBy_Select_sum(Boolean) 
- GroupBy_with_boolean_groupin_key_thru_navigation_access(Boolean) 
- GroupBy_with_boolean_grouping_key(Boolean) 
- GroupJoin_Composite_Key(Boolean) 
- GroupJoin_on_entity_qsre_keys_inner_key_is_nested_navigation(Boolean) 
- Include_after_select_anonymous_projection_throws(Boolean) 
- Include_after_Select_throws(Boolean) 
- Include_after_select_with_cast_throws(Boolean) 
- Include_after_select_with_entity_projection_throws(Boolean) 
- Include_after_SelectMany_throws(Boolean) 
- Include_base_navigation_on_derived_entity(Boolean) 
- Include_collection_and_invalid_navigation_using_string_throws(Boolean) 
- Include_collection_on_derived_type_using_EF_Property(Boolean) 
- Include_collection_on_derived_type_using_lambda_with_soft_cast(Boolean) 
- Include_collection_on_derived_type_using_lambda(Boolean) 
- Include_collection_on_derived_type_using_string(Boolean) 
- Include_collection_OrderBy_aggregate(Boolean) 
- Include_collection_with_Cast_to_base(Boolean) 
- Include_collection_with_complex_OrderBy2(Boolean) 
- Include_collection_with_complex_OrderBy3(Boolean) 
- Include_multiple_circular_with_filter(Boolean) 
- Include_multiple_circular(Boolean) 
- Include_multiple_include_then_include(Boolean) 
- Include_multiple_one_to_one_and_one_to_many_self_reference(Boolean) 
- Include_multiple_one_to_one_and_one_to_many(Boolean) 
- Include_multiple_one_to_one_and_one_to_one_and_one_to_many(Boolean) 
- Include_multiple_one_to_one_optional_and_one_to_one_required(Boolean) 
- Include_navigation_on_derived_type(Boolean) 
- Include_on_derived_entity_using_OfType(Boolean) 
- Include_on_derived_entity_with_cast(Boolean) 
- Include_on_derived_multi_level(Boolean) 
- Include_on_derived_type_with_order_by_and_paging(Boolean) 
- Include_on_entity_that_is_not_present_in_final_projection_but_uses_TypeIs_instead(Boolean) 
- Include_on_GroupJoin_SelectMany_DefaultIfEmpty_with_coalesce_result1() 
- Include_on_GroupJoin_SelectMany_DefaultIfEmpty_with_coalesce_result2() 
- Include_on_GroupJoin_SelectMany_DefaultIfEmpty_with_coalesce_result3(Boolean) 
- Include_on_GroupJoin_SelectMany_DefaultIfEmpty_with_coalesce_result4(Boolean) 
- Include_on_GroupJoin_SelectMany_DefaultIfEmpty_with_complex_projection_result(Boolean) 
- Include_on_GroupJoin_SelectMany_DefaultIfEmpty_with_conditional_result(Boolean) 
- Include_on_GroupJoin_SelectMany_DefaultIfEmpty_with_inheritance_and_coalesce_result(Boolean) 
- Include_one_to_many_on_composite_key_then_orderby_key_properties(Boolean) 
- Include_reference_on_derived_type_using_EF_Property(Boolean) 
- Include_reference_on_derived_type_using_lambda_with_soft_cast(Boolean) 
- Include_reference_on_derived_type_using_lambda_with_tracking(Boolean) 
- Include_reference_on_derived_type_using_lambda(Boolean) 
- Include_reference_on_derived_type_using_string_nested1(Boolean) 
- Include_reference_on_derived_type_using_string_nested2(Boolean) 
- Include_reference_on_derived_type_using_string(Boolean) 
- Include_using_alternate_key(Boolean) 
- Include_where_list_contains_navigation(Boolean) 
- Include_where_list_contains_navigation2(Boolean) 
- Include_with_client_method_and_member_access_still_applies_includes(Boolean) 
- Include_with_complex_order_by(Boolean) 
- Include_with_concat(Boolean) 
- Include_with_group_by_and_FirstOrDefault_gets_properly_applied(Boolean) 
- Include_with_join_and_inheritance_with_orderby_before_and_after_include(Boolean) 
- Include_with_join_and_inheritance1(Boolean) 
- Include_with_join_and_inheritance2(Boolean) 
- Include_with_join_and_inheritance3(Boolean) 
- Include_with_join_collection1(Boolean) 
- Include_with_join_collection2(Boolean) 
- Include_with_join_multi_level(Boolean) 
- Include_with_join_reference1(Boolean) 
- Include_with_join_reference2(Boolean) 
- Include_with_nested_navigation_in_order_by(Boolean) 
- Include_with_order_by_constant(Boolean) 
- Include_with_projection_of_unmapped_property_still_gets_applied(Boolean) 
- Join_entity_with_itself_grouped_by_key_followed_by_include_skip_take(Boolean) 
- Join_include_coalesce_nested(Boolean) 
- Join_include_coalesce_simple(Boolean) 
- Join_include_conditional(Boolean) 
- Join_inner_source_custom_projection_followed_by_filter(Boolean) 
- Join_navigation_translated_to_subquery_composite_key(Boolean) 
- Join_on_entity_qsre_keys_composite_key(Boolean) 
- Join_on_entity_qsre_keys_inheritance(Boolean) 
- Join_on_entity_qsre_keys_inner_key_is_navigation_composite_key(Boolean) 
- Join_on_entity_qsre_keys_inner_key_is_navigation(Boolean) 
- Join_on_entity_qsre_keys_inner_key_is_nested_navigation(Boolean) 
- Join_on_entity_qsre_keys_outer_key_is_navigation(Boolean) 
- Join_on_entity_qsre_keys(Boolean) 
- Join_predicate_condition_equals_condition(Boolean) 
- Join_predicate_value_equals_condition(Boolean) 
- Join_predicate_value(Boolean) 
- Join_with_complex_key_selector(Boolean) 
- Join_with_inner_being_a_subquery_projecting_anonymous_type_with_single_property(Boolean) 
- Join_with_inner_being_a_subquery_projecting_single_property(Boolean) 
- Join_with_order_by_on_inner_sequence_navigation_translated_to_subquery_composite_key(Boolean) 
- Join_with_order_by_without_skip_or_take_nested(Boolean) 
- Join_with_order_by_without_skip_or_take(Boolean) 
- Left_join_predicate_condition_equals_condition(Boolean) 
- Left_join_predicate_value_equals_condition(Boolean) 
- Left_join_predicate_value(Boolean) 
- Left_join_projection_using_coalesce_tracking(Boolean) 
- Left_join_projection_using_conditional_tracking(Boolean) 
- Left_join_with_GroupBy_with_composite_group_key(Boolean) 
- Logical_operation_with_non_null_parameter_optimizes_null_checks(Boolean) 
- Member_access_on_derived_entity_using_cast_and_let(Boolean) 
- Member_access_on_derived_entity_using_cast(Boolean) 
- Member_access_on_derived_materialized_entity_using_cast(Boolean) 
- Multiple_derived_included_on_one_method(Boolean) 
- Multiple_includes_with_client_method_around_entity_and_also_projecting_included_collection() 
- Multiple_order_bys_are_properly_lifted_from_subquery_created_by_include(Boolean) 
- Multiple_orderby_with_navigation_expansion_on_one_of_the_order_bys_inside_subquery_complex_orderings(Boolean) 
- Multiple_orderby_with_navigation_expansion_on_one_of_the_order_bys_inside_subquery_duplicated_orderings(Boolean) 
- Multiple_orderby_with_navigation_expansion_on_one_of_the_order_bys_inside_subquery(Boolean) 
- Multiple_orderby_with_navigation_expansion_on_one_of_the_order_bys(Boolean) 
- Nav_expansion_inside_Contains_argument(Boolean) 
- Nav_expansion_inside_ElementAt_correlated_to_source(Boolean) 
- Nav_expansion_inside_Skip_correlated_to_source(Boolean) 
- Nav_expansion_inside_Take_correlated_to_source(Boolean) 
- Nav_expansion_with_member_pushdown_inside_Contains_argument(Boolean) 
- Nav_expansion_with_member_pushdown_inside_Take_correlated_to_source(Boolean) 
- Nav_rewrite_Distinct_with_convert_anonymous() 
- Nav_rewrite_Distinct_with_convert() 
- Nav_rewrite_with_convert1(Boolean) 
- Nav_rewrite_with_convert2(Boolean) 
- Nav_rewrite_with_convert3(Boolean) 
- Navigation_access_fk_on_derived_entity_using_cast(Boolean) 
- Navigation_access_on_derived_entity_using_cast(Boolean) 
- Navigation_access_on_derived_materialized_entity_using_cast(Boolean) 
- Navigation_access_via_EFProperty_on_derived_entity_using_cast(Boolean) 
- Navigation_accessed_twice_outside_and_inside_subquery(Boolean) 
- Navigation_based_on_complex_expression1(Boolean) 
- Navigation_based_on_complex_expression2(Boolean) 
- Navigation_based_on_complex_expression3(Boolean) 
- Navigation_based_on_complex_expression4(Boolean) 
- Navigation_based_on_complex_expression5(Boolean) 
- Navigation_based_on_complex_expression6(Boolean) 
- Navigation_inside_interpolated_string_expanded(Boolean) 
- Negated_bool_ternary_inside_anonymous_type_in_projection(Boolean) 
- Nested_contains_with_enum(Boolean) 
- Non_string_concat_uses_appropriate_type_mapping(Boolean) 
- Non_unicode_parameter_is_used_for_non_unicode_column(Boolean) 
- Non_unicode_string_literal_is_used_for_non_unicode_column_right(Boolean) 
- Non_unicode_string_literal_is_used_for_non_unicode_column(Boolean) 
- Non_unicode_string_literals_in_contains_is_used_for_non_unicode_column(Boolean) 
- Non_unicode_string_literals_is_used_for_non_unicode_column_in_subquery(Boolean) 
- Non_unicode_string_literals_is_used_for_non_unicode_column_with_contains(Boolean) 
- Non_unicode_string_literals_is_used_for_non_unicode_column_with_subquery(Boolean) 
- Null_checks_in_correlated_predicate_are_correctly_translated(Boolean) 
- Null_propagation_optimization1(Boolean) 
- Null_propagation_optimization2(Boolean) 
- Null_propagation_optimization3(Boolean) 
- Null_propagation_optimization4(Boolean) 
- Null_propagation_optimization5(Boolean) 
- Null_propagation_optimization6(Boolean) 
- Null_semantics_is_correctly_applied_for_function_comparisons_that_take_arguments_from_optional_navigation_complex(Boolean) 
- Null_semantics_is_correctly_applied_for_function_comparisons_that_take_arguments_from_optional_navigation(Boolean) 
- Null_semantics_on_nullable_bool_from_inner_join_subquery_is_fully_applied(Boolean) 
- Null_semantics_on_nullable_bool_from_left_join_subquery_is_fully_applied(Boolean) 
- Nullable_bool_comparison_is_translated_to_server(Boolean) 
- OfType_in_subquery_works(Boolean) 
- OfTypeNav1(Boolean) 
- OfTypeNav2(Boolean) 
- OfTypeNav3(Boolean) 
- Optional_Navigation_Null_Coalesce_To_Clr_Type(Boolean) 
- Optional_navigation_type_compensation_works_with_all(Boolean) 
- Optional_navigation_type_compensation_works_with_array_initializers(Boolean) 
- Optional_navigation_type_compensation_works_with_binary_and_expression(Boolean) 
- Optional_navigation_type_compensation_works_with_binary_expression(Boolean) 
- Optional_navigation_type_compensation_works_with_conditional_expression(Boolean) 
- Optional_navigation_type_compensation_works_with_contains(Boolean) 
- Optional_navigation_type_compensation_works_with_DTOs(Boolean) 
- Optional_navigation_type_compensation_works_with_list_initializers(Boolean) 
- Optional_navigation_type_compensation_works_with_negated_predicate(Boolean) 
- Optional_navigation_type_compensation_works_with_orderby(Boolean) 
- Optional_navigation_type_compensation_works_with_predicate_negated_complex1(Boolean) 
- Optional_navigation_type_compensation_works_with_predicate_negated_complex2(Boolean) 
- Optional_navigation_type_compensation_works_with_predicate_negated(Boolean) 
- Optional_navigation_type_compensation_works_with_predicate(Boolean) 
- Optional_navigation_type_compensation_works_with_predicate2(Boolean) 
- Optional_navigation_type_compensation_works_with_projection_into_anonymous_type(Boolean) 
- Optional_navigation_type_compensation_works_with_projection(Boolean) 
- Optional_navigation_type_compensation_works_with_skip(Boolean) 
- Optional_navigation_type_compensation_works_with_take(Boolean) 
- Optional_navigation_with_collection_composite_key(Boolean) 
- Order_by_entity_qsre_composite_key(Boolean) 
- Order_by_entity_qsre_with_inheritance(Boolean) 
- Order_by_entity_qsre_with_other_orderbys(Boolean) 
- Order_by_entity_qsre(Boolean) 
- Order_by_is_properly_lifted_from_subquery_with_same_order_by_in_the_outer_query(Boolean) 
- Order_by_TimeOnly_FromTimeSpan(Boolean) 
- Orderby_added_for_client_side_GroupJoin_composite_dependent_to_principal_LOJ_when_incomplete_key_is_used(Boolean) 
- OrderBy_bool_coming_from_optional_navigation(Boolean) 
- OrderBy_Contains_empty_list(Boolean) 
- OrderBy_same_expression_containing_IsNull_correctly_deduplicates_the_ordering(Boolean) 
- OrderBy_StartsWith_with_null_parameter_as_argument(Boolean) 
- Outer_parameter_in_group_join_with_DefaultIfEmpty(Boolean) 
- Outer_parameter_in_join_key_inner_and_outer(Boolean) 
- Outer_parameter_in_join_key(Boolean) 
- Project_collection_navigation_nested_composite_key(Boolean) 
- Project_collection_navigation_nested_with_take_composite_key(Boolean) 
- Project_collection_navigation_with_inheritance1(Boolean) 
- Project_collection_navigation_with_inheritance2(Boolean) 
- Project_collection_navigation_with_inheritance3(Boolean) 
- Project_derivied_entity_with_convert_to_parent(Boolean) 
- Project_entity_and_collection_element(Boolean) 
- Project_equality_with_value_converted_property(Boolean) 
- Project_navigation_defined_on_base_from_entity_with_inheritance_using_soft_cast(Boolean) 
- Project_navigation_defined_on_derived_from_entity_with_inheritance_using_soft_cast(Boolean) 
- Project_one_value_type_converted_to_nullable_from_empty_collection(Boolean) 
- Project_one_value_type_from_empty_collection(Boolean) 
- Project_one_value_type_with_client_projection_from_empty_collection(Boolean) 
- Project_shadow_properties(Boolean) 
- Projecting_correlated_collection_followed_by_Distinct(Boolean) 
- Projecting_entity_as_well_as_complex_correlated_collection_followed_by_Distinct(Boolean) 
- Projecting_entity_as_well_as_correlated_collection_followed_by_Distinct(Boolean) 
- Projecting_entity_as_well_as_correlated_collection_of_scalars_followed_by_Distinct(Boolean) 
- Projecting_nullable_bool_in_conditional_works(Boolean) 
- Projecting_property_converted_to_nullable_and_use_it_in_order_by(Boolean) 
- Projecting_property_converted_to_nullable_into_element_init(Boolean) 
- Projecting_property_converted_to_nullable_into_member_access(Boolean) 
- Projecting_property_converted_to_nullable_into_member_assignment(Boolean) 
- Projecting_property_converted_to_nullable_into_new_array(Boolean) 
- Projecting_property_converted_to_nullable_into_unary(Boolean) 
- Projecting_property_converted_to_nullable_with_addition_and_final_projection(Boolean) 
- Projecting_property_converted_to_nullable_with_addition(Boolean) 
- Projecting_property_converted_to_nullable_with_comparison(Boolean) 
- Projecting_property_converted_to_nullable_with_conditional(Boolean) 
- Projecting_property_converted_to_nullable_with_function_call(Boolean) 
- Projecting_property_converted_to_nullable_with_function_call2(Boolean) 
- Projecting_required_string_column_compared_to_null_parameter(Boolean) 
- Projecting_some_properties_as_well_as_correlated_collection_followed_by_Distinct(Boolean) 
- Property_access_on_derived_entity_using_cast(Boolean) 
- Query_reusing_parameter_doesnt_declare_duplicate_parameter_complex(Boolean) 
- Query_reusing_parameter_doesnt_declare_duplicate_parameter(Boolean) 
- Query_reusing_parameter_with_inner_query_doesnt_declare_duplicate_parameter(Boolean) 
- Query_reusing_parameter_with_inner_query_expression_doesnt_declare_duplicate_parameter(Boolean) 
- Query_with_complex_let_containing_ordering_and_filter_projecting_firstOrDefault_element_of_let(Boolean) 
- Reference_include_chain_loads_correctly_when_middle_is_null(Boolean) 
- RewriteExpectedQueryExpression(Expression) 
- Select_as_operator(Boolean) 
- Select_coalesce_with_anonymous_types(Boolean) 
- Select_comparison_with_null(Boolean) 
- Select_conditional_with_anonymous_type_and_null_constant(Boolean) 
- Select_conditional_with_anonymous_types(Boolean) 
- Select_correlated_filtered_collection_returning_queryable_throws(Boolean) 
- Select_correlated_filtered_collection_with_composite_key(Boolean) 
- Select_correlated_filtered_collection_works_with_caching(Boolean) 
- Select_correlated_filtered_collection(Boolean) 
- Select_datetimeoffset_comparison_in_projection(Boolean) 
- Select_enum_has_flag(Boolean) 
- Select_inverted_boolean(Boolean) 
- Select_inverted_nullable_boolean(Boolean) 
- Select_length_of_string_property(Boolean) 
- Select_multiple_conditions(Boolean) 
- Select_navigation_with_concat_and_count(Boolean) 
- Select_nested_ternary_operations(Boolean) 
- Select_null_conditional_with_inheritance_negative(Boolean) 
- Select_null_conditional_with_inheritance(Boolean) 
- Select_null_parameter_is_not_null(Boolean) 
- Select_null_parameter(Boolean) 
- Select_null_propagation_negative1(Boolean) 
- Select_null_propagation_negative2(Boolean) 
- Select_null_propagation_negative3(Boolean) 
- Select_null_propagation_negative4(Boolean) 
- Select_null_propagation_negative5(Boolean) 
- Select_null_propagation_negative6(Boolean) 
- Select_null_propagation_negative7(Boolean) 
- Select_null_propagation_negative8(Boolean) 
- Select_null_propagation_negative9(Boolean) 
- Select_null_propagation_optimization7(Boolean) 
- Select_null_propagation_optimization8(Boolean) 
- Select_null_propagation_optimization9(Boolean) 
- Select_null_propagation_works_for_multiple_navigations_with_composite_keys(Boolean) 
- Select_null_propagation_works_for_navigations_with_composite_keys(Boolean) 
- Select_required_navigation_on_derived_type(Boolean) 
- Select_required_navigation_on_the_same_type_with_cast(Boolean) 
- Select_Singleton_Navigation_With_Member_Access(Boolean) 
- Select_StartsWith_with_null_parameter_as_argument(Boolean) 
- Select_subquery_boolean_empty_with_pushdown(Boolean) 
- Select_subquery_boolean_empty(Boolean) 
- Select_subquery_boolean_with_pushdown(Boolean) 
- Select_subquery_boolean(Boolean) 
- Select_subquery_distinct_firstordefault(Boolean) 
- Select_subquery_distinct_singleordefault_boolean_empty_with_pushdown(Boolean) 
- Select_subquery_distinct_singleordefault_boolean_empty1(Boolean) 
- Select_subquery_distinct_singleordefault_boolean_empty2(Boolean) 
- Select_subquery_distinct_singleordefault_boolean_with_pushdown(Boolean) 
- Select_subquery_distinct_singleordefault_boolean1(Boolean) 
- Select_subquery_distinct_singleordefault_boolean2(Boolean) 
- Select_subquery_int_with_inside_cast_and_coalesce(Boolean) 
- Select_subquery_int_with_outside_cast_and_coalesce(Boolean) 
- Select_subquery_int_with_pushdown_and_coalesce(Boolean) 
- Select_subquery_int_with_pushdown_and_coalesce2(Boolean) 
- Select_subquery_projecting_multiple_constants_inside_anonymous(Boolean) 
- Select_subquery_projecting_single_constant_bool(Boolean) 
- Select_subquery_projecting_single_constant_inside_anonymous(Boolean) 
- Select_subquery_projecting_single_constant_int(Boolean) 
- Select_subquery_projecting_single_constant_null_of_non_mapped_type(Boolean) 
- Select_subquery_projecting_single_constant_of_non_mapped_type(Boolean) 
- Select_subquery_projecting_single_constant_string(Boolean) 
- Select_ternary_operation_multiple_conditions_2(Boolean) 
- Select_ternary_operation_multiple_conditions(Boolean) 
- Select_ternary_operation_with_boolean(Boolean) 
- Select_ternary_operation_with_has_value_not_null(Boolean) 
- Select_ternary_operation_with_inverted_boolean(Boolean) 
- Select_Where_Navigation_Client(Boolean) 
- Select_Where_Navigation_Equals_Navigation(Boolean) 
- Select_Where_Navigation_Included(Boolean) 
- Select_Where_Navigation_Null_Reverse(Boolean) 
- Select_Where_Navigation_Null(Boolean) 
- Select_Where_Navigation_Scalar_Equals_Navigation_Scalar_Projected(Boolean) 
- Select_Where_Navigation_Scalar_Equals_Navigation_Scalar(Boolean) 
- Select_Where_Navigation(Boolean) 
- SelectMany_predicate_after_navigation_with_non_equality_comparison_DefaultIfEmpty_converted_to_left_join(Boolean) 
- SelectMany_predicate_with_non_equality_comparison_converted_to_inner_join(Boolean) 
- SelectMany_predicate_with_non_equality_comparison_DefaultIfEmpty_converted_to_left_join(Boolean) 
- SelectMany_predicate_with_non_equality_comparison_with_Take_doesnt_convert_to_join(Boolean) 
- SelectMany_Where_DefaultIfEmpty_with_navigation_in_the_collection_selector_not_equal(Boolean) 
- SelectMany_Where_DefaultIfEmpty_with_navigation_in_the_collection_selector_order_comparison(Boolean) 
- SelectMany_Where_DefaultIfEmpty_with_navigation_in_the_collection_selector(Boolean) 
- SelectMany_without_result_selector_and_non_equality_comparison_converted_to_join(Boolean) 
- Set_operator_with_navigation_in_projection_groupby_aggregate(Boolean) 
- Singleton_Navigation_With_Member_Access(Boolean) 
- Skip_with_orderby_followed_by_orderBy_is_pushed_down(Boolean) 
- Streaming_correlated_collection_issue_11403_returning_ordered_enumerable_throws(Boolean) 
- Streaming_correlated_collection_issue_11403(Boolean) 
- String_based_Include_navigation_on_derived_type(Boolean) 
- String_compare_with_null_conditional_argument(Boolean) 
- String_compare_with_null_conditional_argument2(Boolean) 
- String_concat_nullable_expressions_are_coalesced(Boolean) 
- String_concat_on_various_types(Boolean) 
- String_concat_with_null_conditional_argument(Boolean) 
- String_concat_with_null_conditional_argument2(Boolean) 
- Subquery_containing_join_gets_lifted_clashing_names(Boolean) 
- Subquery_containing_join_projecting_main_from_clause_gets_lifted(Boolean) 
- Subquery_containing_left_join_projecting_main_from_clause_gets_lifted(Boolean) 
- Subquery_containing_SelectMany_projecting_main_from_clause_gets_lifted(Boolean) 
- Subquery_created_by_include_gets_lifted_nested(Boolean) 
- Subquery_inside_Take_argument(Boolean) 
- Subquery_is_lifted_from_additional_from_clause(Boolean) 
- Subquery_is_lifted_from_main_from_clause_of_SelectMany(Boolean) 
- Subquery_projecting_non_nullable_scalar_contains_non_nullable_value_doesnt_need_null_expansion_negated(Boolean) 
- Subquery_projecting_non_nullable_scalar_contains_non_nullable_value_doesnt_need_null_expansion(Boolean) 
- Subquery_projecting_nullable_scalar_contains_nullable_value_needs_null_expansion_negated(Boolean) 
- Subquery_projecting_nullable_scalar_contains_nullable_value_needs_null_expansion(Boolean) 
- Subquery_with_result_operator_is_not_lifted(Boolean) 
- Sum_with_no_data_nullable_double(Boolean) 
- Sum_with_optional_navigation_is_translated_to_sql(Boolean) 
- Take_without_orderby_followed_by_orderBy_is_pushed_down1(Boolean) 
- Take_without_orderby_followed_by_orderBy_is_pushed_down2(Boolean) 
- Take_without_orderby_followed_by_orderBy_is_pushed_down3(Boolean) 
- ThenInclude_collection_on_derived_after_base_reference(Boolean) 
- ThenInclude_collection_on_derived_after_derived_collection(Boolean) 
- ThenInclude_collection_on_derived_after_derived_reference(Boolean) 
- ThenInclude_reference_on_derived_after_derived_collection(Boolean) 
- Time_of_day_datetimeoffset(Boolean) 
- TimeSpan_Hours(Boolean) 
- TimeSpan_Milliseconds(Boolean) 
- TimeSpan_Minutes(Boolean) 
- TimeSpan_Seconds(Boolean) 
- ToString_boolean_computed_nullable(Boolean) 
- ToString_boolean_property_non_nullable(Boolean) 
- ToString_boolean_property_nullable(Boolean) 
- ToString_enum_contains(Boolean) 
- ToString_enum_property_projection(Boolean) 
- ToString_guid_property_projection(Boolean) 
- ToString_nullable_enum_contains(Boolean) 
- ToString_nullable_enum_property_projection(Boolean) 
- ToString_string_property_projection(Boolean) 
- Trying_to_access_unmapped_property_in_projection(Boolean) 
- Trying_to_access_unmapped_property_inside_aggregate(Boolean) 
- Trying_to_access_unmapped_property_inside_join_key_selector(Boolean) 
- Trying_to_access_unmapped_property_inside_subquery(Boolean) 
- Trying_to_access_unmapped_property_throws_informative_error(Boolean) 
- Unicode_string_literals_is_used_for_non_unicode_column_with_concat(Boolean) 
- Union_with_collection_navigations(Boolean) 
- Unnecessary_include_doesnt_get_added_complex_when_projecting_EF_Property(Boolean) 
- Using_indexer_on_byte_array_and_string_in_projection(Boolean) 
- Where_any_subquery_without_collision(Boolean) 
- Where_bitwise_and_enum(Boolean) 
- Where_bitwise_and_integral(Boolean) 
- Where_bitwise_and_nullable_enum_with_constant(Boolean) 
- Where_bitwise_and_nullable_enum_with_non_nullable_parameter(Boolean) 
- Where_bitwise_and_nullable_enum_with_null_constant(Boolean) 
- Where_bitwise_and_nullable_enum_with_nullable_parameter(Boolean) 
- Where_bitwise_or_enum(Boolean) 
- Where_bool_column_and_Contains(Boolean) 
- Where_bool_column_or_Contains(Boolean) 
- Where_coalesce_with_anonymous_types(Boolean) 
- Where_compare_anonymous_types_with_uncorrelated_members(Boolean) 
- Where_compare_anonymous_types(Boolean) 
- Where_conditional_equality_1(Boolean) 
- Where_conditional_equality_2(Boolean) 
- Where_conditional_equality_3(Boolean) 
- Where_contains_on_navigation_with_composite_keys(Boolean) 
- Where_count_subquery_without_collision(Boolean) 
- Where_DateOnly_AddDays(Boolean) 
- Where_DateOnly_AddMonths(Boolean) 
- Where_DateOnly_AddYears(Boolean) 
- Where_DateOnly_Day(Boolean) 
- Where_DateOnly_DayOfWeek(Boolean) 
- Where_DateOnly_DayOfYear(Boolean) 
- Where_DateOnly_FromDateTime_compared_to_constant_and_parameter(Boolean) 
- Where_DateOnly_FromDateTime_compared_to_property(Boolean) 
- Where_DateOnly_Month(Boolean) 
- Where_DateOnly_Year(Boolean) 
- Where_datetimeoffset_date_component(Boolean) 
- Where_datetimeoffset_day_component(Boolean) 
- Where_datetimeoffset_dayofyear_component(Boolean) 
- Where_datetimeoffset_hour_component(Boolean) 
- Where_datetimeoffset_millisecond_component(Boolean) 
- Where_datetimeoffset_milliseconds_parameter_and_constant(Boolean) 
- Where_datetimeoffset_minute_component(Boolean) 
- Where_datetimeoffset_month_component(Boolean) 
- Where_datetimeoffset_now(Boolean) 
- Where_datetimeoffset_second_component(Boolean) 
- Where_datetimeoffset_utcnow(Boolean) 
- Where_datetimeoffset_year_component(Boolean) 
- Where_enum_has_flag_subquery_client_eval(Boolean) 
- Where_enum_has_flag_subquery_with_pushdown(Boolean) 
- Where_enum_has_flag_subquery(Boolean) 
- Where_enum_has_flag_with_non_nullable_parameter(Boolean) 
- Where_enum_has_flag(Boolean) 
- Where_enum(Boolean) 
- Where_equals_method_on_nullable_with_object_overload(Boolean) 
- Where_has_flag_with_nullable_parameter(Boolean) 
- Where_is_properly_lifted_from_subquery_created_by_include(Boolean) 
- Where_member_access_on_anonymous_type(Boolean) 
- Where_null_parameter_is_not_null(Boolean) 
- Where_nullable_enum_with_constant(Boolean) 
- Where_nullable_enum_with_non_nullable_parameter(Boolean) 
- Where_nullable_enum_with_null_constant(Boolean) 
- Where_nullable_enum_with_nullable_parameter(Boolean) 
- Where_required_navigation_on_derived_type(Boolean) 
- Where_subquery_boolean_with_pushdown(Boolean) 
- Where_subquery_boolean(Boolean) 
- Where_subquery_concat_firstordefault_boolean(Boolean) 
- Where_subquery_distinct_first_boolean(Boolean) 
- Where_subquery_distinct_firstordefault_boolean_with_pushdown(Boolean) 
- Where_subquery_distinct_firstordefault_boolean(Boolean) 
- Where_subquery_distinct_last_boolean(Boolean) 
- Where_subquery_distinct_lastordefault_boolean(Boolean) 
- Where_subquery_distinct_orderby_firstordefault_boolean_with_pushdown(Boolean) 
- Where_subquery_distinct_orderby_firstordefault_boolean(Boolean) 
- Where_subquery_distinct_singleordefault_boolean_with_pushdown(Boolean) 
- Where_subquery_distinct_singleordefault_boolean1(Boolean) 
- Where_subquery_distinct_singleordefault_boolean2(Boolean) 
- Where_subquery_equality_to_null_with_composite_key_should_match_nulls(Boolean) 
- Where_subquery_equality_to_null_with_composite_key(Boolean) 
- Where_subquery_equality_to_null_without_composite_key_should_match_null(Boolean) 
- Where_subquery_equality_to_null_without_composite_key(Boolean) 
- Where_subquery_join_firstordefault_boolean(Boolean) 
- Where_subquery_left_join_firstordefault_boolean(Boolean) 
- Where_subquery_union_firstordefault_boolean(Boolean) 
- Where_subquery_with_ElementAt_using_column_as_index(Boolean) 
- Where_subquery_with_ElementAtOrDefault_equality_to_null_with_composite_key(Boolean) 
- Where_TimeOnly_Add_TimeSpan(Boolean) 
- Where_TimeOnly_AddHours(Boolean) 
- Where_TimeOnly_AddMinutes(Boolean) 
- Where_TimeOnly_FromDateTime_compared_to_constant(Boolean) 
- Where_TimeOnly_FromDateTime_compared_to_parameter(Boolean) 
- Where_TimeOnly_FromDateTime_compared_to_property(Boolean) 
- Where_TimeOnly_FromTimeSpan_compared_to_parameter(Boolean) 
- Where_TimeOnly_FromTimeSpan_compared_to_property(Boolean) 
- Where_TimeOnly_Hour(Boolean) 
- Where_TimeOnly_IsBetween(Boolean) 
- Where_TimeOnly_Millisecond(Boolean) 
- Where_TimeOnly_Minute(Boolean) 
- Where_TimeOnly_Second(Boolean) 
- Where_TimeOnly_subtract_TimeOnly(Boolean) 
- Where_TimeSpan_Hours(Boolean) 
- Where_TimeSpan_Milliseconds(Boolean) 
- Where_TimeSpan_Minutes(Boolean) 
- Where_TimeSpan_Seconds(Boolean) 
- Where_with_enum_flags_parameter(Boolean) 
 
net10.0-windows7.0
    namespace Microsoft.EntityFrameworkCore.Query
{
    public abstract class GearsOfWarQueryTestBase<TFixture> : QueryTestBase<TFixture>
        where TFixture, new(), GearsOfWarQueryFixtureBase
    {
        [ConditionalTheory]
        [MemberData("IsAsyncData", new[] {  })]
        public virtual Task Contains_on_nullable_array_produces_correct_sql(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