RowNumberPagingTest RowNumberPagingTest Class

Syntax

Declaration

public class RowNumberPagingTest : QueryTestBase<NorthwindRowNumberPagingQuerySqlServerFixture>, IDisposablePublic Class RowNumberPagingTest
    Inherits QueryTestBase(Of NorthwindRowNumberPagingQuerySqlServerFixture)
    Implements IDisposable

Inheritance Hierarchy

Inherited Members

Local_array(),
Local_array(),
Query_composition_against_ienumerable_set(),
Query_composition_against_ienumerable_set(),
Entity_equality_self(),
Entity_equality_self(),
Entity_equality_local(),
Entity_equality_local(),
Entity_equality_local_inline(),
Entity_equality_local_inline(),
Entity_equality_null(),
Entity_equality_null(),
Entity_equality_not_null(),
Entity_equality_not_null(),
Null_conditional_simple(),
Null_conditional_simple(),
Null_conditional_deep(),
Null_conditional_deep(),
Queryable_simple(),
Queryable_simple(),
Queryable_simple_anonymous(),
Queryable_simple_anonymous(),
Queryable_simple_anonymous_projection_subquery(),
Queryable_simple_anonymous_projection_subquery(),
Queryable_simple_anonymous_subquery(),
Queryable_simple_anonymous_subquery(),
Queryable_reprojection(),
Queryable_reprojection(),
Queryable_nested_simple(),
Queryable_nested_simple(),
Take_simple(),
Take_simple(),
Take_simple_parameterized(),
Take_simple_parameterized(),
Take_simple_projection(),
Take_simple_projection(),
Take_subquery_projection(),
Take_subquery_projection(),
Distinct_Skip(),
Distinct_Skip(),
Distinct_Skip_Take(),
Distinct_Skip_Take(),
Skip_Distinct(),
Skip_Distinct(),
Skip_Take_Distinct(),
Skip_Take_Distinct(),
Take_Skip_Distinct_Caching(),
Take_Skip_Distinct_Caching(),
Take_Distinct(),
Take_Distinct(),
Distinct_Take(),
Distinct_Take(),
Distinct_Take_Count(),
Distinct_Take_Count(),
Take_Distinct_Count(),
Take_Distinct_Count(),
Take_Where_Distinct_Count(),
Take_Where_Distinct_Count(),
Any_simple(),
Any_simple(),
OrderBy_Take_Count(),
OrderBy_Take_Count(),
Take_OrderBy_Count(),
Take_OrderBy_Count(),
Any_predicate(),
Any_predicate(),
Any_nested_negated(),
Any_nested_negated(),
Any_nested_negated2(),
Any_nested_negated2(),
Any_nested_negated3(),
Any_nested_negated3(),
Any_nested(),
Any_nested(),
Any_nested2(),
Any_nested2(),
Any_nested3(),
Any_nested3(),
Any_with_multiple_conditions_still_uses_exists(),
Any_with_multiple_conditions_still_uses_exists(),
All_top_level(),
All_top_level(),
All_top_level_column(),
All_top_level_column(),
All_top_level_subquery(),
All_top_level_subquery(),
All_top_level_subquery_ef_property(),
All_top_level_subquery_ef_property(),
All_client(),
All_client(),
All_client_and_server_top_level(),
All_client_and_server_top_level(),
All_client_or_server_top_level(),
All_client_or_server_top_level(),
Select_into(),
Select_into(),
Projection_when_arithmetic_expression_precendence(),
Projection_when_arithmetic_expression_precendence(),
Projection_when_null_value(),
Projection_when_null_value(),
Take_with_single(),
Take_with_single(),
Take_with_single_select_many(),
Take_with_single_select_many(),
Cast_results_to_object(),
Cast_results_to_object(),
Where_simple(),
Where_simple(),
Where_simple_closure(),
Where_simple_closure(),
Where_simple_closure_constant(),
Where_simple_closure_constant(),
Where_simple_closure_via_query_cache(),
Where_simple_closure_via_query_cache(),
Where_method_call_nullable_type_closure_via_query_cache(),
Where_method_call_nullable_type_closure_via_query_cache(),
Where_method_call_nullable_type_reverse_closure_via_query_cache(),
Where_method_call_nullable_type_reverse_closure_via_query_cache(),
Where_method_call_closure_via_query_cache(),
Where_method_call_closure_via_query_cache(),
Where_field_access_closure_via_query_cache(),
Where_field_access_closure_via_query_cache(),
Where_property_access_closure_via_query_cache(),
Where_property_access_closure_via_query_cache(),
Where_static_field_access_closure_via_query_cache(),
Where_static_field_access_closure_via_query_cache(),
Where_static_property_access_closure_via_query_cache(),
Where_static_property_access_closure_via_query_cache(),
Where_nested_field_access_closure_via_query_cache(),
Where_nested_field_access_closure_via_query_cache(),
Where_nested_property_access_closure_via_query_cache(),
Where_nested_property_access_closure_via_query_cache(),
Where_nested_field_access_closure_via_query_cache_error_null(),
Where_nested_field_access_closure_via_query_cache_error_null(),
Where_nested_field_access_closure_via_query_cache_error_method_null(),
Where_nested_field_access_closure_via_query_cache_error_method_null(),
Where_new_instance_field_access_closure_via_query_cache(),
Where_new_instance_field_access_closure_via_query_cache(),
Where_simple_closure_via_query_cache_nullable_type(),
Where_simple_closure_via_query_cache_nullable_type(),
Where_simple_closure_via_query_cache_nullable_type_reverse(),
Where_simple_closure_via_query_cache_nullable_type_reverse(),
Where_subquery_closure_via_query_cache(),
Where_subquery_closure_via_query_cache(),
Project_to_object_array(),
Project_to_object_array(),
Project_to_int_array(),
Project_to_int_array(),
Where_simple_shadow(),
Where_simple_shadow(),
Where_simple_shadow_projection(),
Where_simple_shadow_projection(),
Where_simple_shadow_projection_mixed(),
Where_simple_shadow_projection_mixed(),
Where_simple_shadow_subquery(),
Where_simple_shadow_subquery(),
Where_shadow_subquery_FirstOrDefault(),
Where_shadow_subquery_FirstOrDefault(),
Where_client(),
Where_client(),
Where_subquery_correlated(),
Where_subquery_correlated(),
Where_subquery_correlated_client_eval(),
Where_subquery_correlated_client_eval(),
Where_client_and_server_top_level(),
Where_client_and_server_top_level(),
Where_client_or_server_top_level(),
Where_client_or_server_top_level(),
Where_client_and_server_non_top_level(),
Where_client_and_server_non_top_level(),
Where_client_deep_inside_predicate_and_server_top_level(),
Where_client_deep_inside_predicate_and_server_top_level(),
First_client_predicate(),
First_client_predicate(),
Where_equals_method_string(),
Where_equals_method_string(),
Where_equals_method_int(),
Where_equals_method_int(),
Where_equals_using_object_overload_on_mismatched_types(),
Where_equals_using_object_overload_on_mismatched_types(),
Where_equals_using_int_overload_on_mismatched_types(),
Where_equals_using_int_overload_on_mismatched_types(),
Where_equals_on_mismatched_types_nullable_int_long(),
Where_equals_on_mismatched_types_nullable_int_long(),
Where_equals_on_mismatched_types_int_nullable_int(),
Where_equals_on_mismatched_types_int_nullable_int(),
Where_equals_on_mismatched_types_nullable_long_nullable_int(),
Where_equals_on_mismatched_types_nullable_long_nullable_int(),
Where_equals_on_matched_nullable_int_types(),
Where_equals_on_matched_nullable_int_types(),
Where_equals_on_null_nullable_int_types(),
Where_equals_on_null_nullable_int_types(),
Where_comparison_nullable_type_not_null(),
Where_comparison_nullable_type_not_null(),
Where_comparison_nullable_type_null(),
Where_comparison_nullable_type_null(),
Where_string_length(),
Where_string_length(),
Where_datetime_now(),
Where_datetime_now(),
Where_datetime_utcnow(),
Where_datetime_utcnow(),
Where_datetime_date_component(),
Where_datetime_date_component(),
Where_datetime_year_component(),
Where_datetime_year_component(),
Where_datetime_month_component(),
Where_datetime_month_component(),
Where_datetime_dayOfYear_component(),
Where_datetime_dayOfYear_component(),
Where_datetime_day_component(),
Where_datetime_day_component(),
Where_datetime_hour_component(),
Where_datetime_hour_component(),
Where_datetime_minute_component(),
Where_datetime_minute_component(),
Where_datetime_second_component(),
Where_datetime_second_component(),
Where_datetime_millisecond_component(),
Where_datetime_millisecond_component(),
Where_simple_reversed(),
Where_simple_reversed(),
Where_is_null(),
Where_is_null(),
Where_null_is_null(),
Where_null_is_null(),
Where_constant_is_null(),
Where_constant_is_null(),
Where_is_not_null(),
Where_is_not_null(),
Where_null_is_not_null(),
Where_null_is_not_null(),
Where_constant_is_not_null(),
Where_constant_is_not_null(),
Where_identity_comparison(),
Where_identity_comparison(),
Where_select_many_or(),
Where_select_many_or(),
Where_select_many_or2(),
Where_select_many_or2(),
Where_select_many_or3(),
Where_select_many_or3(),
Where_select_many_or4(),
Where_select_many_or4(),
Where_select_many_or_with_parameter(),
Where_select_many_or_with_parameter(),
Where_in_optimization_multiple(),
Where_in_optimization_multiple(),
Where_not_in_optimization1(),
Where_not_in_optimization1(),
Where_not_in_optimization2(),
Where_not_in_optimization2(),
Where_not_in_optimization3(),
Where_not_in_optimization3(),
Where_not_in_optimization4(),
Where_not_in_optimization4(),
Where_select_many_and(),
Where_select_many_and(),
Where_primitive(),
Where_primitive(),
Where_primitive_tracked(),
Where_primitive_tracked(),
Where_primitive_tracked2(),
Where_primitive_tracked2(),
Where_subquery_anon(),
Where_subquery_anon(),
Where_subquery_expression(),
Where_subquery_expression(),
Where_subquery_expression_same_parametername(),
Where_subquery_expression_same_parametername(),
Where_bool_member(),
Where_bool_member(),
Where_bool_member_false(),
Where_bool_member_false(),
Where_bool_client_side_negated(),
Where_bool_client_side_negated(),
Where_bool_member_negated_twice(),
Where_bool_member_negated_twice(),
Where_bool_member_shadow(),
Where_bool_member_shadow(),
Where_bool_member_false_shadow(),
Where_bool_member_false_shadow(),
Where_bool_member_equals_constant(),
Where_bool_member_equals_constant(),
Where_bool_member_in_complex_predicate(),
Where_bool_member_in_complex_predicate(),
Where_bool_member_compared_to_binary_expression(),
Where_bool_member_compared_to_binary_expression(),
Where_not_bool_member_compared_to_not_bool_member(),
Where_not_bool_member_compared_to_not_bool_member(),
Where_negated_boolean_expression_compared_to_another_negated_boolean_expression(),
Where_negated_boolean_expression_compared_to_another_negated_boolean_expression(),
Where_not_bool_member_compared_to_binary_expression(),
Where_not_bool_member_compared_to_binary_expression(),
Where_bool_parameter(),
Where_bool_parameter(),
Where_bool_parameter_compared_to_binary_expression(),
Where_bool_parameter_compared_to_binary_expression(),
Where_bool_member_and_parameter_compared_to_binary_expression_nested(),
Where_bool_member_and_parameter_compared_to_binary_expression_nested(),
Where_de_morgan_or_optimizated(),
Where_de_morgan_or_optimizated(),
Where_de_morgan_and_optimizated(),
Where_de_morgan_and_optimizated(),
Where_complex_negated_expression_optimized(),
Where_complex_negated_expression_optimized(),
Where_short_member_comparison(),
Where_short_member_comparison(),
Where_comparison_to_nullable_bool(),
Where_comparison_to_nullable_bool(),
Where_true(),
Where_true(),
Where_false(),
Where_false(),
Where_bool_closure(),
Where_bool_closure(),
Where_poco_closure(),
Where_poco_closure(),
Where_default(),
Where_default(),
Where_expression_invoke(),
Where_expression_invoke(),
Where_concat_string_int_comparison1(),
Where_concat_string_int_comparison1(),
Where_concat_string_int_comparison2(),
Where_concat_string_int_comparison2(),
Where_concat_string_int_comparison3(),
Where_concat_string_int_comparison3(),
Where_ternary_boolean_condition(),
Where_ternary_boolean_condition(),
Where_ternary_boolean_condition_with_another_condition(),
Where_ternary_boolean_condition_with_another_condition(),
Where_ternary_boolean_condition_with_false_as_result(),
Where_ternary_boolean_condition_with_false_as_result(),
Select_bool_closure(),
Select_bool_closure(),
Where_compare_constructed_equal(),
Where_compare_constructed_equal(),
Where_compare_constructed_multi_value_equal(),
Where_compare_constructed_multi_value_equal(),
Where_compare_constructed_multi_value_not_equal(),
Where_compare_constructed_multi_value_not_equal(),
Where_compare_constructed(),
Where_compare_constructed(),
Where_compare_null(),
Where_compare_null(),
Where_projection(),
Where_projection(),
Where_Is_on_same_type(),
Where_Is_on_same_type(),
Select_scalar(),
Select_scalar(),
Select_anonymous_one(),
Select_anonymous_one(),
Select_anonymous_two(),
Select_anonymous_two(),
Select_anonymous_three(),
Select_anonymous_three(),
Select_anonymous_bool_constant_true(),
Select_anonymous_bool_constant_true(),
Select_anonymous_constant_in_expression(),
Select_anonymous_constant_in_expression(),
Select_anonymous_conditional_expression(),
Select_anonymous_conditional_expression(),
Select_customer_table(),
Select_customer_table(),
Select_customer_identity(),
Select_customer_identity(),
Select_anonymous_with_object(),
Select_anonymous_with_object(),
Select_anonymous_nested(),
Select_anonymous_nested(),
Select_anonymous_empty(),
Select_anonymous_empty(),
Select_anonymous_literal(),
Select_anonymous_literal(),
Select_constant_int(),
Select_constant_int(),
Select_constant_null_string(),
Select_constant_null_string(),
Select_local(),
Select_local(),
Select_scalar_primitive(),
Select_scalar_primitive(),
Select_scalar_primitive_after_take(),
Select_scalar_primitive_after_take(),
Select_project_filter(),
Select_project_filter(),
Select_project_filter2(),
Select_project_filter2(),
Select_nested_collection(),
Select_nested_collection(),
Select_correlated_subquery_projection(),
Select_correlated_subquery_projection(),
Select_correlated_subquery_filtered(),
Select_correlated_subquery_filtered(),
Select_correlated_subquery_ordered(),
Select_correlated_subquery_ordered(),
Select_nested_collection_in_anonymous_type(),
Select_nested_collection_in_anonymous_type(),
Select_subquery_recursive_trivial(),
Select_subquery_recursive_trivial(),
Where_subquery_on_bool(),
Where_subquery_on_bool(),
Where_subquery_on_collection(),
Where_subquery_on_collection(),
Where_query_composition(),
Where_query_composition(),
Where_query_composition_is_null(),
Where_query_composition_is_null(),
Where_query_composition_is_not_null(),
Where_query_composition_is_not_null(),
Where_query_composition_entity_equality_one_element_SingleOrDefault(),
Where_query_composition_entity_equality_one_element_SingleOrDefault(),
Where_query_composition_entity_equality_one_element_FirstOrDefault(),
Where_query_composition_entity_equality_one_element_FirstOrDefault(),
Where_query_composition_entity_equality_no_elements_SingleOrDefault(),
Where_query_composition_entity_equality_no_elements_SingleOrDefault(),
Where_query_composition_entity_equality_no_elements_Single(),
Where_query_composition_entity_equality_no_elements_Single(),
Where_query_composition_entity_equality_no_elements_FirstOrDefault(),
Where_query_composition_entity_equality_no_elements_FirstOrDefault(),
Where_query_composition_entity_equality_multiple_elements_SingleOrDefault(),
Where_query_composition_entity_equality_multiple_elements_SingleOrDefault(),
Where_query_composition_entity_equality_multiple_elements_FirstOrDefault(),
Where_query_composition_entity_equality_multiple_elements_FirstOrDefault(),
Where_query_composition2(),
Where_query_composition2(),
Where_query_composition3(),
Where_query_composition3(),
Where_query_composition4(),
Where_query_composition4(),
Where_query_composition5(),
Where_query_composition5(),
Where_query_composition6(),
Where_query_composition6(),
Where_subquery_recursive_trivial(),
Where_subquery_recursive_trivial(),
Select_nested_collection_deep(),
Select_nested_collection_deep(),
OrderBy_scalar_primitive(),
OrderBy_scalar_primitive(),
SelectMany_mixed(),
SelectMany_mixed(),
SelectMany_simple1(),
SelectMany_simple1(),
SelectMany_simple_subquery(),
SelectMany_simple_subquery(),
SelectMany_simple2(),
SelectMany_simple2(),
SelectMany_entity_deep(),
SelectMany_entity_deep(),
SelectMany_projection1(),
SelectMany_projection1(),
SelectMany_projection2(),
SelectMany_projection2(),
SelectMany_nested_simple(),
SelectMany_nested_simple(),
SelectMany_correlated_simple(),
SelectMany_correlated_simple(),
SelectMany_correlated_subquery_simple(),
SelectMany_correlated_subquery_simple(),
SelectMany_correlated_subquery_hard(),
SelectMany_correlated_subquery_hard(),
SelectMany_cartesian_product_with_ordering(),
SelectMany_cartesian_product_with_ordering(),
SelectMany_primitive(),
SelectMany_primitive(),
SelectMany_primitive_select_subquery(),
SelectMany_primitive_select_subquery(),
Join_customers_orders_projection(),
Join_customers_orders_projection(),
Join_customers_orders_entities(),
Join_customers_orders_entities(),
Join_select_many(),
Join_select_many(),
Client_Join_select_many(),
Client_Join_select_many(),
Join_customers_orders_select(),
Join_customers_orders_select(),
Join_customers_orders_with_subquery(),
Join_customers_orders_with_subquery(),
Join_customers_orders_with_subquery_with_take(),
Join_customers_orders_with_subquery_with_take(),
Join_customers_orders_with_subquery_anonymous_property_method(),
Join_customers_orders_with_subquery_anonymous_property_method(),
Join_customers_orders_with_subquery_anonymous_property_method_with_take(),
Join_customers_orders_with_subquery_anonymous_property_method_with_take(),
Join_customers_orders_with_subquery_predicate(),
Join_customers_orders_with_subquery_predicate(),
Join_customers_orders_with_subquery_predicate_with_take(),
Join_customers_orders_with_subquery_predicate_with_take(),
Join_composite_key(),
Join_composite_key(),
Join_client_new_expression(),
Join_client_new_expression(),
Join_local_collection_int_closure_is_cached_correctly(),
Join_local_collection_int_closure_is_cached_correctly(),
Join_local_string_closure_is_cached_correctly(),
Join_local_string_closure_is_cached_correctly(),
Join_local_bytes_closure_is_cached_correctly(),
Join_local_bytes_closure_is_cached_correctly(),
Join_Where_Count(),
Join_Where_Count(),
Multiple_joins_Where_Order_Any(),
Multiple_joins_Where_Order_Any(),
Join_OrderBy_Count(),
Join_OrderBy_Count(),
Where_join_select(),
Where_join_select(),
Where_orderby_join_select(),
Where_orderby_join_select(),
Where_join_orderby_join_select(),
Where_join_orderby_join_select(),
Where_select_many(),
Where_select_many(),
Where_orderby_select_many(),
Where_orderby_select_many(),
GroupJoin_customers_orders(),
GroupJoin_customers_orders(),
GroupJoin_customers_orders_count(),
GroupJoin_customers_orders_count(),
Default_if_empty_top_level(),
Default_if_empty_top_level(),
Default_if_empty_top_level_arg(),
Default_if_empty_top_level_arg(),
Default_if_empty_top_level_positive(),
Default_if_empty_top_level_positive(),
Default_if_empty_top_level_projection(),
Default_if_empty_top_level_projection(),
GroupJoin_customers_employees_shadow(),
GroupJoin_customers_employees_shadow(),
GroupJoin_customers_employees_subquery_shadow(),
GroupJoin_customers_employees_subquery_shadow(),
GroupJoin_customers_employees_subquery_shadow_take(),
GroupJoin_customers_employees_subquery_shadow_take(),
SelectMany_customer_orders(),
SelectMany_customer_orders(),
SelectMany_Count(),
SelectMany_Count(),
SelectMany_LongCount(),
SelectMany_LongCount(),
SelectMany_OrderBy_ThenBy_Any(),
SelectMany_OrderBy_ThenBy_Any(),
OrderBy(),
OrderBy(),
OrderBy_true(),
OrderBy_true(),
OrderBy_integer(),
OrderBy_integer(),
OrderBy_parameter(),
OrderBy_parameter(),
OrderBy_anon(),
OrderBy_anon(),
OrderBy_anon2(),
OrderBy_anon2(),
OrderBy_client_mixed(),
OrderBy_client_mixed(),
OrderBy_multiple_queries(),
OrderBy_multiple_queries(),
OrderBy_shadow(),
OrderBy_shadow(),
OrderBy_ThenBy_predicate(),
OrderBy_ThenBy_predicate(),
OrderBy_correlated_subquery_lol(),
OrderBy_correlated_subquery_lol(),
OrderBy_correlated_subquery_lol2(),
OrderBy_correlated_subquery_lol2(),
OrderBy_Select(),
OrderBy_Select(),
OrderBy_multiple(),
OrderBy_multiple(),
OrderBy_ThenBy(),
OrderBy_ThenBy(),
OrderByDescending(),
OrderByDescending(),
OrderByDescending_ThenBy(),
OrderByDescending_ThenBy(),
OrderByDescending_ThenByDescending(),
OrderByDescending_ThenByDescending(),
OrderBy_ThenBy_Any(),
OrderBy_ThenBy_Any(),
OrderBy_Join(),
OrderBy_Join(),
OrderBy_SelectMany(),
OrderBy_SelectMany(),
Let_any_subquery_anonymous(),
Let_any_subquery_anonymous(),
GroupBy_anonymous(),
GroupBy_anonymous(),
GroupBy_anonymous_with_where(),
GroupBy_anonymous_with_where(),
GroupBy_nested_order_by_enumerable(),
GroupBy_nested_order_by_enumerable(),
GroupBy_join_default_if_empty_anonymous(),
GroupBy_join_default_if_empty_anonymous(),
GroupBy_SelectMany(),
GroupBy_SelectMany(),
GroupBy_simple(),
GroupBy_simple(),
GroupBy_simple2(),
GroupBy_simple2(),
GroupBy_first(),
GroupBy_first(),
GroupBy_Sum(),
GroupBy_Sum(),
GroupBy_Count(),
GroupBy_Count(),
GroupBy_LongCount(),
GroupBy_LongCount(),
GroupBy_Shadow(),
GroupBy_Shadow(),
GroupBy_Shadow2(),
GroupBy_Shadow2(),
GroupBy_Shadow3(),
GroupBy_Shadow3(),
GroupBy_Sum_Min_Max_Avg(),
GroupBy_Sum_Min_Max_Avg(),
GroupBy_with_result_selector(),
GroupBy_with_result_selector(),
GroupBy_with_element_selector_sum(),
GroupBy_with_element_selector_sum(),
GroupBy_with_element_selector(),
GroupBy_with_element_selector(),
GroupBy_with_element_selector2(),
GroupBy_with_element_selector2(),
GroupBy_with_element_selector3(),
GroupBy_with_element_selector3(),
GroupBy_with_element_selector_sum_max(),
GroupBy_with_element_selector_sum_max(),
GroupBy_with_anonymous_element(),
GroupBy_with_anonymous_element(),
GroupBy_with_two_part_key(),
GroupBy_with_two_part_key(),
GroupBy_DateTimeOffset_Property(),
GroupBy_DateTimeOffset_Property(),
OrderBy_GroupBy(),
OrderBy_GroupBy(),
OrderBy_GroupBy_SelectMany(),
OrderBy_GroupBy_SelectMany(),
OrderBy_GroupBy_SelectMany_shadow(),
OrderBy_GroupBy_SelectMany_shadow(),
Select_GroupBy(),
Select_GroupBy(),
Select_GroupBy_SelectMany(),
Select_GroupBy_SelectMany(),
GroupBy_with_orderby(),
GroupBy_with_orderby(),
GroupBy_with_orderby_and_anonymous_projection(),
GroupBy_with_orderby_and_anonymous_projection(),
GroupBy_with_orderby_take_skip_distinct(),
GroupBy_with_orderby_take_skip_distinct(),
Select_All(),
Select_All(),
Select_GroupBy_All(),
Select_GroupBy_All(),
Sum_with_no_arg(),
Sum_with_no_arg(),
Sum_with_binary_expression(),
Sum_with_binary_expression(),
Sum_with_no_arg_empty(),
Sum_with_no_arg_empty(),
Sum_with_arg(),
Sum_with_arg(),
Sum_with_arg_expression(),
Sum_with_arg_expression(),
Sum_with_division_on_decimal(),
Sum_with_division_on_decimal(),
Sum_with_division_on_decimal_no_significant_digits(),
Sum_with_division_on_decimal_no_significant_digits(),
Min_with_no_arg(),
Min_with_no_arg(),
Min_with_arg(),
Min_with_arg(),
Max_with_no_arg(),
Max_with_no_arg(),
Max_with_arg(),
Max_with_arg(),
Count_with_no_predicate(),
Count_with_no_predicate(),
Count_with_predicate(),
Count_with_predicate(),
Count_with_order_by(),
Count_with_order_by(),
Where_OrderBy_Count(),
Where_OrderBy_Count(),
OrderBy_Where_Count(),
OrderBy_Where_Count(),
OrderBy_Count_with_predicate(),
OrderBy_Count_with_predicate(),
OrderBy_Where_Count_with_predicate(),
OrderBy_Where_Count_with_predicate(),
Where_OrderBy_Count_client_eval(),
Where_OrderBy_Count_client_eval(),
Where_OrderBy_Count_client_eval_mixed(),
Where_OrderBy_Count_client_eval_mixed(),
OrderBy_Where_Count_client_eval(),
OrderBy_Where_Count_client_eval(),
OrderBy_Where_Count_client_eval_mixed(),
OrderBy_Where_Count_client_eval_mixed(),
OrderBy_Count_with_predicate_client_eval(),
OrderBy_Count_with_predicate_client_eval(),
OrderBy_Count_with_predicate_client_eval_mixed(),
OrderBy_Count_with_predicate_client_eval_mixed(),
OrderBy_Where_Count_with_predicate_client_eval(),
OrderBy_Where_Count_with_predicate_client_eval(),
OrderBy_Where_Count_with_predicate_client_eval_mixed(),
OrderBy_Where_Count_with_predicate_client_eval_mixed(),
OrderBy_client_Take(),
OrderBy_client_Take(),
OrderBy_arithmetic(),
OrderBy_arithmetic(),
OrderBy_condition_comparison(),
OrderBy_condition_comparison(),
OrderBy_ternary_conditions(),
OrderBy_ternary_conditions(),
OrderBy_any(),
OrderBy_any(),
ClientEvalPredicateStateless(),
ClientEvalPredicateStateless(),
ClientEvalPredicate(Order),
ClientEvalPredicate(Order),
ClientEvalSelector(Order),
ClientEvalSelector(Order),
Distinct(),
Distinct(),
Distinct_Scalar(),
Distinct_Scalar(),
OrderBy_Distinct(),
OrderBy_Distinct(),
Distinct_OrderBy(),
Distinct_OrderBy(),
Distinct_OrderBy2(),
Distinct_OrderBy2(),
Distinct_OrderBy3(),
Distinct_OrderBy3(),
Distinct_GroupBy(),
Distinct_GroupBy(),
GroupBy_Distinct(),
GroupBy_Distinct(),
Distinct_Count(),
Distinct_Count(),
Select_Distinct_Count(),
Select_Distinct_Count(),
Select_Select_Distinct_Count(),
Select_Select_Distinct_Count(),
Single_Throws(),
Single_Throws(),
Single_Predicate(),
Single_Predicate(),
Where_Single(),
Where_Single(),
SingleOrDefault_Throws(),
SingleOrDefault_Throws(),
SingleOrDefault_Predicate(),
SingleOrDefault_Predicate(),
Where_SingleOrDefault(),
Where_SingleOrDefault(),
First(),
First(),
First_Predicate(),
First_Predicate(),
Where_First(),
Where_First(),
FirstOrDefault(),
FirstOrDefault(),
FirstOrDefault_Predicate(),
FirstOrDefault_Predicate(),
Where_FirstOrDefault(),
Where_FirstOrDefault(),
FirstOrDefault_inside_subquery_gets_server_evaluated(),
FirstOrDefault_inside_subquery_gets_server_evaluated(),
First_inside_subquery_gets_client_evaluated(),
First_inside_subquery_gets_client_evaluated(),
Last(),
Last(),
Last_when_no_order_by(),
Last_when_no_order_by(),
Last_Predicate(),
Last_Predicate(),
Where_Last(),
Where_Last(),
LastOrDefault(),
LastOrDefault(),
LastOrDefault_Predicate(),
LastOrDefault_Predicate(),
Where_LastOrDefault(),
Where_LastOrDefault(),
String_StartsWith_Literal(),
String_StartsWith_Literal(),
String_StartsWith_Identity(),
String_StartsWith_Identity(),
String_StartsWith_Column(),
String_StartsWith_Column(),
String_StartsWith_MethodCall(),
String_StartsWith_MethodCall(),
String_EndsWith_Literal(),
String_EndsWith_Literal(),
String_EndsWith_Identity(),
String_EndsWith_Identity(),
String_EndsWith_Column(),
String_EndsWith_Column(),
String_EndsWith_MethodCall(),
String_EndsWith_MethodCall(),
String_Contains_Identity(),
String_Contains_Identity(),
String_Contains_Column(),
String_Contains_Column(),
String_Compare_simple_zero(),
String_Compare_simple_zero(),
String_Compare_simple_one(),
String_Compare_simple_one(),
String_compare_with_parameter(),
String_compare_with_parameter(),
String_Compare_simple_client(),
String_Compare_simple_client(),
String_Compare_nested(),
String_Compare_nested(),
String_Compare_multi_predicate(),
String_Compare_multi_predicate(),
LocalMethod1(),
LocalMethod1(),
LocalMethod2(),
LocalMethod2(),
Where_math_abs1(),
Where_math_abs1(),
Where_math_abs2(),
Where_math_abs2(),
Where_math_abs3(),
Where_math_abs3(),
Where_math_abs_uncorrelated(),
Where_math_abs_uncorrelated(),
Where_math_ceiling1(),
Where_math_ceiling1(),
Where_math_ceiling2(),
Where_math_ceiling2(),
Where_math_floor(),
Where_math_floor(),
Where_math_power(),
Where_math_power(),
Where_math_round(),
Where_math_round(),
Where_math_truncate(),
Where_math_truncate(),
Where_guid_newguid(),
Where_guid_newguid(),
Where_string_to_upper(),
Where_string_to_upper(),
Where_string_to_lower(),
Where_string_to_lower(),
Where_functions_nested(),
Where_functions_nested(),
Convert_ToByte(),
Convert_ToByte(),
Convert_ToDecimal(),
Convert_ToDecimal(),
Convert_ToDouble(),
Convert_ToDouble(),
Convert_ToInt16(),
Convert_ToInt16(),
Convert_ToInt32(),
Convert_ToInt32(),
Convert_ToInt64(),
Convert_ToInt64(),
Convert_ToString(),
Convert_ToString(),
GroupJoin_simple(),
GroupJoin_simple(),
GroupJoin_tracking_groups(),
GroupJoin_tracking_groups(),
GroupJoin_tracking_groups2(),
GroupJoin_tracking_groups2(),
GroupJoin_simple2(),
GroupJoin_simple2(),
GroupJoin_simple3(),
GroupJoin_simple3(),
GroupJoin_simple_ordering(),
GroupJoin_simple_ordering(),
GroupJoin_simple_subquery(),
GroupJoin_simple_subquery(),
GroupJoin_projection(),
GroupJoin_projection(),
GroupJoin_outer_projection(),
GroupJoin_outer_projection(),
GroupJoin_outer_projection2(),
GroupJoin_outer_projection2(),
GroupJoin_outer_projection_reverse(),
GroupJoin_outer_projection_reverse(),
GroupJoin_outer_projection_reverse2(),
GroupJoin_outer_projection_reverse2(),
GroupJoin_subquery_projection_outer_mixed(),
GroupJoin_subquery_projection_outer_mixed(),
GroupJoin_DefaultIfEmpty(),
GroupJoin_DefaultIfEmpty(),
GroupJoin_DefaultIfEmpty_multiple(),
GroupJoin_DefaultIfEmpty_multiple(),
GroupJoin_DefaultIfEmpty2(),
GroupJoin_DefaultIfEmpty2(),
GroupJoin_DefaultIfEmpty3(),
GroupJoin_DefaultIfEmpty3(),
GroupJoin_Where(),
GroupJoin_Where(),
GroupJoin_Where_OrderBy(),
GroupJoin_Where_OrderBy(),
GroupJoin_DefaultIfEmpty_Where(),
GroupJoin_DefaultIfEmpty_Where(),
Join_GroupJoin_DefaultIfEmpty_Where(),
Join_GroupJoin_DefaultIfEmpty_Where(),
GroupJoin_DefaultIfEmpty_Project(),
GroupJoin_DefaultIfEmpty_Project(),
GroupJoin_with_different_outer_elements_with_same_key(),
GroupJoin_with_different_outer_elements_with_same_key(),
GroupJoin_with_different_outer_elements_with_same_key_with_predicate(),
GroupJoin_with_different_outer_elements_with_same_key_with_predicate(),
GroupJoin_with_different_outer_elements_with_same_key_projected_from_another_entity(),
GroupJoin_with_different_outer_elements_with_same_key_projected_from_another_entity(),
SelectMany_Joined(),
SelectMany_Joined(),
SelectMany_Joined_DefaultIfEmpty(),
SelectMany_Joined_DefaultIfEmpty(),
SelectMany_Joined_Take(),
SelectMany_Joined_Take(),
SelectMany_Joined_DefaultIfEmpty2(),
SelectMany_Joined_DefaultIfEmpty2(),
Select_many_cross_join_same_collection(),
Select_many_cross_join_same_collection(),
Join_same_collection_multiple(),
Join_same_collection_multiple(),
Join_same_collection_force_alias_uniquefication(),
Join_same_collection_force_alias_uniquefication(),
Contains_with_subquery(),
Contains_with_subquery(),
Contains_with_local_array_closure(),
Contains_with_local_array_closure(),
Contains_with_subquery_and_local_array_closure(),
Contains_with_subquery_and_local_array_closure(),
Contains_with_local_int_array_closure(),
Contains_with_local_int_array_closure(),
Contains_with_local_array_inline(),
Contains_with_local_array_inline(),
Contains_with_local_list_closure(),
Contains_with_local_list_closure(),
Contains_with_local_list_inline(),
Contains_with_local_list_inline(),
Contains_with_local_list_inline_closure_mix(),
Contains_with_local_list_inline_closure_mix(),
Contains_with_local_collection_false(),
Contains_with_local_collection_false(),
Contains_with_local_collection_complex_predicate_and(),
Contains_with_local_collection_complex_predicate_and(),
Contains_with_local_collection_complex_predicate_or(),
Contains_with_local_collection_complex_predicate_or(),
Contains_with_local_collection_complex_predicate_not_matching_ins1(),
Contains_with_local_collection_complex_predicate_not_matching_ins1(),
Contains_with_local_collection_complex_predicate_not_matching_ins2(),
Contains_with_local_collection_complex_predicate_not_matching_ins2(),
Contains_with_local_collection_sql_injection(),
Contains_with_local_collection_sql_injection(),
Contains_with_local_collection_empty_closure(),
Contains_with_local_collection_empty_closure(),
Contains_with_local_collection_empty_inline(),
Contains_with_local_collection_empty_inline(),
Contains_top_level(),
Contains_top_level(),
Substring_with_constant(),
Substring_with_constant(),
Substring_with_closure(),
Substring_with_closure(),
Substring_with_client_eval(),
Substring_with_client_eval(),
IsNullOrEmpty_in_predicate(),
IsNullOrEmpty_in_predicate(),
IsNullOrEmpty_in_projection(),
IsNullOrEmpty_in_projection(),
IsNullOrEmpty_negated_in_projection(),
IsNullOrEmpty_negated_in_projection(),
IsNullOrWhiteSpace_in_predicate(),
IsNullOrWhiteSpace_in_predicate(),
TrimStart_in_predicate(),
TrimStart_in_predicate(),
TrimStart_with_arguments_in_predicate(),
TrimStart_with_arguments_in_predicate(),
TrimEnd_in_predicate(),
TrimEnd_in_predicate(),
TrimEnd_with_arguments_in_predicate(),
TrimEnd_with_arguments_in_predicate(),
Trim_in_predicate(),
Trim_in_predicate(),
Trim_with_arguments_in_predicate(),
Trim_with_arguments_in_predicate(),
Where_chain(),
Where_chain(),
OfType_Select(),
OfType_Select(),
OfType_Select_OfType_Select(),
OfType_Select_OfType_Select(),
OrderBy_null_coalesce_operator(),
OrderBy_null_coalesce_operator(),
Select_null_coalesce_operator(),
Select_null_coalesce_operator(),
OrderBy_conditional_operator(),
OrderBy_conditional_operator(),
OrderBy_comparison_operator(),
OrderBy_comparison_operator(),
Projection_null_coalesce_operator(),
Projection_null_coalesce_operator(),
Filter_coalesce_operator(),
Filter_coalesce_operator(),
Select_take_null_coalesce_operator(),
Select_take_null_coalesce_operator(),
Select_take_skip_null_coalesce_operator2(),
Select_take_skip_null_coalesce_operator2(),
Select_take_skip_null_coalesce_operator3(),
Select_take_skip_null_coalesce_operator3(),
Select_Property_when_non_shadow(),
Select_Property_when_non_shadow(),
Where_Property_when_non_shadow(),
Where_Property_when_non_shadow(),
Select_Property_when_shadow(),
Select_Property_when_shadow(),
Where_Property_when_shadow(),
Where_Property_when_shadow(),
Select_Property_when_shaow_unconstrained_generic_method(),
Select_Property_when_shaow_unconstrained_generic_method(),
Where_Property_when_shaow_unconstrained_generic_method(),
Where_Property_when_shaow_unconstrained_generic_method(),
ShadowPropertySelect<TIn, TOut>(IQueryable<TIn>, Object),
ShadowPropertySelect(Of TIn, TOut)(IQueryable(Of TIn), Object),
ShadowPropertyWhere<T>(IQueryable<T>, Object, String),
ShadowPropertyWhere(Of T)(IQueryable(Of T), Object, String),
Where_Property_shadow_closure(),
Where_Property_shadow_closure(),
Selected_column_can_coalesce(),
Selected_column_can_coalesce(),
Can_cast_CreateQuery_result_to_IQueryable_T_bug_1730(),
Can_cast_CreateQuery_result_to_IQueryable_T_bug_1730(),
Can_execute_non_generic(),
Can_execute_non_generic(),
Select_Subquery_Single(),
Select_Subquery_Single(),
Select_Where_Subquery_Deep_Single(),
Select_Where_Subquery_Deep_Single(),
Select_Where_Subquery_Deep_First(),
Select_Where_Subquery_Deep_First(),
Select_Where_Subquery_Equality(),
Select_Where_Subquery_Equality(),
Throws_on_concurrent_query_list(),
Throws_on_concurrent_query_list(),
Throws_on_concurrent_query_first(),
Throws_on_concurrent_query_first(),
Does_not_change_ordering_of_projection_with_complex_projections(),
Does_not_change_ordering_of_projection_with_complex_projections(),
Concat_simple(),
Concat_simple(),
Concat_nested(),
Concat_nested(),
Concat_non_entity(),
Concat_non_entity(),
Except_simple(),
Except_simple(),
Except_nested(),
Except_nested(),
Except_non_entity(),
Except_non_entity(),
Intersect_simple(),
Intersect_simple(),
Intersect_nested(),
Intersect_nested(),
Intersect_non_entity(),
Intersect_non_entity(),
Union_simple(),
Union_simple(),
Union_nested(),
Union_nested(),
Union_non_entity(),
Union_non_entity(),
DateTime_parse_is_parameterized(),
DateTime_parse_is_parameterized(),
Random_next_is_not_funcletized_1(),
Random_next_is_not_funcletized_1(),
Random_next_is_not_funcletized_2(),
Random_next_is_not_funcletized_2(),
Random_next_is_not_funcletized_3(),
Random_next_is_not_funcletized_3(),
Random_next_is_not_funcletized_4(),
Random_next_is_not_funcletized_4(),
Random_next_is_not_funcletized_5(),
Random_next_is_not_funcletized_5(),
Random_next_is_not_funcletized_6(),
Random_next_is_not_funcletized_6(),
Environment_newline_is_funcletized(),
Environment_newline_is_funcletized(),
String_concat_with_navigation1(),
String_concat_with_navigation1(),
String_concat_with_navigation2(),
String_concat_with_navigation2(),
Bitwise_or_with_boolean_operators_in_predicate(),
Bitwise_or_with_boolean_operators_in_predicate(),
Bitwise_and_with_boolean_operators_in_predicate(),
Bitwise_and_with_boolean_operators_in_predicate(),
Bitwise_or_with_boolean_operators_in_projection(),
Bitwise_or_with_boolean_operators_in_projection(),
Bitwise_or_multiple_with_boolean_operators_in_projection(),
Bitwise_or_multiple_with_boolean_operators_in_projection(),
Bitwise_and_with_boolean_operators_in_projection(),
Bitwise_and_with_boolean_operators_in_projection(),
Bitwise_and_or_with_boolean_operators_in_projection(),
Bitwise_and_or_with_boolean_operators_in_projection(),
Handle_materialization_properly_when_more_than_two_query_sources_are_involved(),
Handle_materialization_properly_when_more_than_two_query_sources_are_involved(),
Parameter_extraction_short_circuits_1(),
Parameter_extraction_short_circuits_1(),
Parameter_extraction_short_circuits_2(),
Parameter_extraction_short_circuits_2(),
Parameter_extraction_short_circuits_3(),
Parameter_extraction_short_circuits_3(),
Parameter_extraction_can_throw_exception_from_user_code(),
Parameter_extraction_can_throw_exception_from_user_code(),
Subquery_member_pushdown_does_not_change_original_subquery_model(),
Subquery_member_pushdown_does_not_change_original_subquery_model(),
Select_expression_references_are_updated_correctly_with_subquery(),
Select_expression_references_are_updated_correctly_with_subquery(),
DefaultIfEmpty_without_group_join(),
DefaultIfEmpty_without_group_join(),
DefaultIfEmpty_in_subquery(),
DefaultIfEmpty_in_subquery(),
DefaultIfEmpty_in_subquery_nested(),
DefaultIfEmpty_in_subquery_nested(),
CreateContext(),
CreateContext(),
Fixture,
Fixture,
AssertQuery<TItem>(Func<IQueryable<TItem>, IQueryable<Object>>, Boolean, Int32, Action<IList<Object>, IList<Object>>),
AssertQuery(Of TItem)(Func(Of IQueryable(Of TItem), IQueryable(Of Object)), Boolean, Int32, Action(Of IList(Of Object), IList(Of Object))),
AssertQuery<TItem>(Func<IQueryable<TItem>, Object>, Boolean, Int32, Action<Object, Object>),
AssertQuery(Of TItem)(Func(Of IQueryable(Of TItem), Object), Boolean, Int32, Action(Of Object, Object)),
AssertQuery<TItem>(Func<IQueryable<TItem>, IQueryable<Object>>, Func<IQueryable<TItem>, IQueryable<Object>>, Boolean, Int32, Action<IList<Object>, IList<Object>>),
AssertQuery(Of TItem)(Func(Of IQueryable(Of TItem), IQueryable(Of Object)), Func(Of IQueryable(Of TItem), IQueryable(Of Object)), Boolean, Int32, Action(Of IList(Of Object), IList(Of Object))),
ClearLog()
ClearLog()

Constructors summary

Methods summary

Constructors

  • RowNumberPagingTest(NorthwindRowNumberPagingQuerySqlServerFixture, ITestOutputHelper)
    RowNumberPagingTest(NorthwindRowNumberPagingQuerySqlServerFixture, ITestOutputHelper)
    public RowNumberPagingTest(NorthwindRowNumberPagingQuerySqlServerFixture fixture, ITestOutputHelper testOutputHelper)Public Sub New(fixture As NorthwindRowNumberPagingQuerySqlServerFixture, testOutputHelper As ITestOutputHelper)

    Parameters

Methods

  • Dispose()
    Dispose()
    public void Dispose()Public Sub Dispose
  • Join_Customers_Orders_Orders_Skip_Take_Same_Properties()
    Join_Customers_Orders_Orders_Skip_Take_Same_Properties()
    public override void Join_Customers_Orders_Orders_Skip_Take_Same_Properties()Public Overrides Sub Join_Customers_Orders_Orders_Skip_Take_Same_Properties
  • Join_Customers_Orders_Projection_With_String_Concat_Skip_Take()
    Join_Customers_Orders_Projection_With_String_Concat_Skip_Take()
    public override void Join_Customers_Orders_Projection_With_String_Concat_Skip_Take()Public Overrides Sub Join_Customers_Orders_Projection_With_String_Concat_Skip_Take
  • Join_Customers_Orders_Skip_Take()
    Join_Customers_Orders_Skip_Take()
    public override void Join_Customers_Orders_Skip_Take()Public Overrides Sub Join_Customers_Orders_Skip_Take
  • Select_take_skip_null_coalesce_operator()
    Select_take_skip_null_coalesce_operator()
    public override void Select_take_skip_null_coalesce_operator()Public Overrides Sub Select_take_skip_null_coalesce_operator
  • Skip()
    Skip()
    public override void Skip()Public Overrides Sub Skip
  • Skip_no_orderby()
    Skip_no_orderby()
    public override void Skip_no_orderby()Public Overrides Sub Skip_no_orderby
  • Skip_Take()
    Skip_Take()
    public override void Skip_Take()Public Overrides Sub Skip_Take
  • String_Contains_Literal()
    String_Contains_Literal()
    public override void String_Contains_Literal()Public Overrides Sub String_Contains_Literal
  • String_Contains_MethodCall()
    String_Contains_MethodCall()
    public override void String_Contains_MethodCall()Public Overrides Sub String_Contains_MethodCall
  • Take_Skip()
    Take_Skip()
    public override void Take_Skip()Public Overrides Sub Take_Skip
  • Take_Skip_Distinct()
    Take_Skip_Distinct()
    public override void Take_Skip_Distinct()Public Overrides Sub Take_Skip_Distinct
  • Take_skip_null_coalesce_operator()
    Take_skip_null_coalesce_operator()
    public override void Take_skip_null_coalesce_operator()Public Overrides Sub Take_skip_null_coalesce_operator

Details

Assembly

Microsoft.EntityFrameworkCore.SqlServer.FunctionalTests.dll