NullSemanticsQuerySqlServerTest NullSemanticsQuerySqlServerTest Class

Syntax

Declaration

public class NullSemanticsQuerySqlServerTest : NullSemanticsQueryTestBase<SqlServerTestStore, NullSemanticsQuerySqlServerFixture>, IDisposablePublic Class NullSemanticsQuerySqlServerTest
    Inherits NullSemanticsQueryTestBase(Of SqlServerTestStore, NullSemanticsQuerySqlServerFixture)
    Implements IDisposable

Inheritance Hierarchy

Inherited Members

CreateContext(Boolean),
CreateContext(Boolean),
Fixture,
Fixture,
TestStore,
TestStore,
Dispose(),
Dispose(),
Compare_bool_with_bool_equal(),
Compare_bool_with_bool_equal(),
Compare_negated_bool_with_bool_equal(),
Compare_negated_bool_with_bool_equal(),
Compare_bool_with_negated_bool_equal(),
Compare_bool_with_negated_bool_equal(),
Compare_negated_bool_with_negated_bool_equal(),
Compare_negated_bool_with_negated_bool_equal(),
Compare_bool_with_bool_equal_negated(),
Compare_bool_with_bool_equal_negated(),
Compare_negated_bool_with_bool_equal_negated(),
Compare_negated_bool_with_bool_equal_negated(),
Compare_bool_with_negated_bool_equal_negated(),
Compare_bool_with_negated_bool_equal_negated(),
Compare_negated_bool_with_negated_bool_equal_negated(),
Compare_negated_bool_with_negated_bool_equal_negated(),
Compare_bool_with_bool_not_equal(),
Compare_bool_with_bool_not_equal(),
Compare_negated_bool_with_bool_not_equal(),
Compare_negated_bool_with_bool_not_equal(),
Compare_bool_with_negated_bool_not_equal(),
Compare_bool_with_negated_bool_not_equal(),
Compare_negated_bool_with_negated_bool_not_equal(),
Compare_negated_bool_with_negated_bool_not_equal(),
Compare_bool_with_bool_not_equal_negated(),
Compare_bool_with_bool_not_equal_negated(),
Compare_negated_bool_with_bool_not_equal_negated(),
Compare_negated_bool_with_bool_not_equal_negated(),
Compare_bool_with_negated_bool_not_equal_negated(),
Compare_bool_with_negated_bool_not_equal_negated(),
Compare_negated_bool_with_negated_bool_not_equal_negated(),
Compare_negated_bool_with_negated_bool_not_equal_negated(),
Compare_equals_method(),
Compare_equals_method(),
Compare_equals_method_negated(),
Compare_equals_method_negated(),
Compare_complex_equal_equal_equal(),
Compare_complex_equal_equal_equal(),
Compare_complex_equal_not_equal_equal(),
Compare_complex_equal_not_equal_equal(),
Compare_complex_not_equal_equal_equal(),
Compare_complex_not_equal_equal_equal(),
Compare_complex_not_equal_not_equal_equal(),
Compare_complex_not_equal_not_equal_equal(),
Compare_complex_not_equal_equal_not_equal(),
Compare_complex_not_equal_equal_not_equal(),
Compare_complex_not_equal_not_equal_not_equal(),
Compare_complex_not_equal_not_equal_not_equal(),
Compare_nullable_with_null_parameter_equal(),
Compare_nullable_with_null_parameter_equal(),
Compare_nullable_with_non_null_parameter_not_equal(),
Compare_nullable_with_non_null_parameter_not_equal(),
Join_uses_database_semantics(),
Join_uses_database_semantics(),
Contains_with_local_array_closure_with_null(),
Contains_with_local_array_closure_with_null(),
Contains_with_local_array_closure_with_multiple_nulls(),
Contains_with_local_array_closure_with_multiple_nulls(),
Contains_with_local_array_closure_false_with_null(),
Contains_with_local_array_closure_false_with_null(),
Where_multiple_ors_with_null(),
Where_multiple_ors_with_null(),
Where_multiple_ands_with_null(),
Where_multiple_ands_with_null(),
Where_multiple_ors_with_nullable_parameter(),
Where_multiple_ors_with_nullable_parameter(),
Where_multiple_ands_with_nullable_parameter_and_constant(),
Where_multiple_ands_with_nullable_parameter_and_constant(),
Where_multiple_ands_with_nullable_parameter_and_constant_not_optimized(),
Where_multiple_ands_with_nullable_parameter_and_constant_not_optimized(),
Where_coalesce(),
Where_coalesce(),
Where_equal_nullable_with_null_value_parameter(),
Where_equal_nullable_with_null_value_parameter(),
Where_not_equal_nullable_with_null_value_parameter(),
Where_not_equal_nullable_with_null_value_parameter(),
Where_equal_with_coalesce(),
Where_equal_with_coalesce(),
Where_not_equal_with_coalesce(),
Where_not_equal_with_coalesce(),
Where_equal_with_coalesce_both_sides(),
Where_equal_with_coalesce_both_sides(),
Where_not_equal_with_coalesce_both_sides(),
Where_not_equal_with_coalesce_both_sides(),
Where_equal_with_conditional(),
Where_equal_with_conditional(),
Where_not_equal_with_conditional(),
Where_not_equal_with_conditional(),
Where_equal_with_conditional_non_nullable(),
Where_equal_with_conditional_non_nullable(),
Where_conditional_search_condition_in_result(),
Where_conditional_search_condition_in_result(),
Where_nested_conditional_search_condition_in_result(),
Where_nested_conditional_search_condition_in_result(),
Where_equal_with_and_and_contains(),
Where_equal_with_and_and_contains(),
AssertQuery<TItem>(Func<IQueryable<TItem>, IQueryable<TItem>>, Boolean),
AssertQuery(Of TItem)(Func(Of IQueryable(Of TItem), IQueryable(Of TItem)), Boolean),
Where_equal_using_relational_null_semantics(),
Where_equal_using_relational_null_semantics(),
Where_nullable_bool(),
Where_nullable_bool(),
Where_nullable_bool_equal_with_constant(),
Where_nullable_bool_equal_with_constant(),
Where_nullable_bool_with_null_check(),
Where_nullable_bool_with_null_check(),
Where_equal_using_relational_null_semantics_with_parameter(),
Where_equal_using_relational_null_semantics_with_parameter(),
Where_equal_using_relational_null_semantics_complex_with_parameter(),
Where_equal_using_relational_null_semantics_complex_with_parameter(),
Where_not_equal_using_relational_null_semantics(),
Where_not_equal_using_relational_null_semantics(),
Where_not_equal_using_relational_null_semantics_with_parameter(),
Where_not_equal_using_relational_null_semantics_with_parameter(),
Where_not_equal_using_relational_null_semantics_complex_with_parameter(),
Where_not_equal_using_relational_null_semantics_complex_with_parameter(),
Where_comparison_null_constant_and_null_parameter(),
Where_comparison_null_constant_and_null_parameter(),
Where_comparison_null_constant_and_nonnull_parameter(),
Where_comparison_null_constant_and_nonnull_parameter(),
Where_comparison_nonnull_constant_and_null_parameter(),
Where_comparison_nonnull_constant_and_null_parameter(),
Where_comparison_null_semantics_optimization_works_with_complex_predicates(),
Where_comparison_null_semantics_optimization_works_with_complex_predicates(),
Switching_null_semantics_produces_different_cache_entry(),
Switching_null_semantics_produces_different_cache_entry(),
Switching_parameter_value_to_null_produces_different_cache_entry(),
Switching_parameter_value_to_null_produces_different_cache_entry(),
From_sql_composed_with_relational_null_comparison(),
From_sql_composed_with_relational_null_comparison(),
AssertQuery<TItem>(Func<IQueryable<TItem>, IQueryable<TItem>>, Func<IQueryable<TItem>, IQueryable<TItem>>, Boolean)
AssertQuery(Of TItem)(Func(Of IQueryable(Of TItem), IQueryable(Of TItem)), Func(Of IQueryable(Of TItem), IQueryable(Of TItem)), Boolean)

Constructors summary

Methods summary

Constructors

  • NullSemanticsQuerySqlServerTest(NullSemanticsQuerySqlServerFixture)
    NullSemanticsQuerySqlServerTest(NullSemanticsQuerySqlServerFixture)
    public NullSemanticsQuerySqlServerTest(NullSemanticsQuerySqlServerFixture fixture)Public Sub New(fixture As NullSemanticsQuerySqlServerFixture)

    Parameters

Methods

  • Compare_bool_with_bool_equal()
    Compare_bool_with_bool_equal()
    public override void Compare_bool_with_bool_equal()Public Overrides Sub Compare_bool_with_bool_equal
  • Compare_bool_with_bool_equal_negated()
    Compare_bool_with_bool_equal_negated()
    public override void Compare_bool_with_bool_equal_negated()Public Overrides Sub Compare_bool_with_bool_equal_negated
  • Compare_bool_with_bool_not_equal()
    Compare_bool_with_bool_not_equal()
    public override void Compare_bool_with_bool_not_equal()Public Overrides Sub Compare_bool_with_bool_not_equal
  • Compare_bool_with_bool_not_equal_negated()
    Compare_bool_with_bool_not_equal_negated()
    public override void Compare_bool_with_bool_not_equal_negated()Public Overrides Sub Compare_bool_with_bool_not_equal_negated
  • Compare_bool_with_negated_bool_equal()
    Compare_bool_with_negated_bool_equal()
    public override void Compare_bool_with_negated_bool_equal()Public Overrides Sub Compare_bool_with_negated_bool_equal
  • Compare_bool_with_negated_bool_equal_negated()
    Compare_bool_with_negated_bool_equal_negated()
    public override void Compare_bool_with_negated_bool_equal_negated()Public Overrides Sub Compare_bool_with_negated_bool_equal_negated
  • Compare_bool_with_negated_bool_not_equal()
    Compare_bool_with_negated_bool_not_equal()
    public override void Compare_bool_with_negated_bool_not_equal()Public Overrides Sub Compare_bool_with_negated_bool_not_equal
  • Compare_bool_with_negated_bool_not_equal_negated()
    Compare_bool_with_negated_bool_not_equal_negated()
    public override void Compare_bool_with_negated_bool_not_equal_negated()Public Overrides Sub Compare_bool_with_negated_bool_not_equal_negated
  • Compare_complex_equal_equal_equal()
    Compare_complex_equal_equal_equal()
    public override void Compare_complex_equal_equal_equal()Public Overrides Sub Compare_complex_equal_equal_equal
  • Compare_complex_equal_not_equal_equal()
    Compare_complex_equal_not_equal_equal()
    public override void Compare_complex_equal_not_equal_equal()Public Overrides Sub Compare_complex_equal_not_equal_equal
  • Compare_complex_not_equal_equal_equal()
    Compare_complex_not_equal_equal_equal()
    public override void Compare_complex_not_equal_equal_equal()Public Overrides Sub Compare_complex_not_equal_equal_equal
  • Compare_complex_not_equal_equal_not_equal()
    Compare_complex_not_equal_equal_not_equal()
    public override void Compare_complex_not_equal_equal_not_equal()Public Overrides Sub Compare_complex_not_equal_equal_not_equal
  • Compare_complex_not_equal_not_equal_equal()
    Compare_complex_not_equal_not_equal_equal()
    public override void Compare_complex_not_equal_not_equal_equal()Public Overrides Sub Compare_complex_not_equal_not_equal_equal
  • Compare_complex_not_equal_not_equal_not_equal()
    Compare_complex_not_equal_not_equal_not_equal()
    public override void Compare_complex_not_equal_not_equal_not_equal()Public Overrides Sub Compare_complex_not_equal_not_equal_not_equal
  • Compare_equals_method()
    Compare_equals_method()
    public override void Compare_equals_method()Public Overrides Sub Compare_equals_method
  • Compare_equals_method_negated()
    Compare_equals_method_negated()
    public override void Compare_equals_method_negated()Public Overrides Sub Compare_equals_method_negated
  • Compare_negated_bool_with_bool_equal()
    Compare_negated_bool_with_bool_equal()
    public override void Compare_negated_bool_with_bool_equal()Public Overrides Sub Compare_negated_bool_with_bool_equal
  • Compare_negated_bool_with_bool_equal_negated()
    Compare_negated_bool_with_bool_equal_negated()
    public override void Compare_negated_bool_with_bool_equal_negated()Public Overrides Sub Compare_negated_bool_with_bool_equal_negated
  • Compare_negated_bool_with_bool_not_equal()
    Compare_negated_bool_with_bool_not_equal()
    public override void Compare_negated_bool_with_bool_not_equal()Public Overrides Sub Compare_negated_bool_with_bool_not_equal
  • Compare_negated_bool_with_bool_not_equal_negated()
    Compare_negated_bool_with_bool_not_equal_negated()
    public override void Compare_negated_bool_with_bool_not_equal_negated()Public Overrides Sub Compare_negated_bool_with_bool_not_equal_negated
  • Compare_negated_bool_with_negated_bool_equal()
    Compare_negated_bool_with_negated_bool_equal()
    public override void Compare_negated_bool_with_negated_bool_equal()Public Overrides Sub Compare_negated_bool_with_negated_bool_equal
  • Compare_negated_bool_with_negated_bool_equal_negated()
    Compare_negated_bool_with_negated_bool_equal_negated()
    public override void Compare_negated_bool_with_negated_bool_equal_negated()Public Overrides Sub Compare_negated_bool_with_negated_bool_equal_negated
  • Compare_negated_bool_with_negated_bool_not_equal()
    Compare_negated_bool_with_negated_bool_not_equal()
    public override void Compare_negated_bool_with_negated_bool_not_equal()Public Overrides Sub Compare_negated_bool_with_negated_bool_not_equal
  • Compare_negated_bool_with_negated_bool_not_equal_negated()
    Compare_negated_bool_with_negated_bool_not_equal_negated()
    public override void Compare_negated_bool_with_negated_bool_not_equal_negated()Public Overrides Sub Compare_negated_bool_with_negated_bool_not_equal_negated
  • Compare_nullable_with_non_null_parameter_not_equal()
    Compare_nullable_with_non_null_parameter_not_equal()
    public override void Compare_nullable_with_non_null_parameter_not_equal()Public Overrides Sub Compare_nullable_with_non_null_parameter_not_equal
  • Compare_nullable_with_null_parameter_equal()
    Compare_nullable_with_null_parameter_equal()
    public override void Compare_nullable_with_null_parameter_equal()Public Overrides Sub Compare_nullable_with_null_parameter_equal
  • Contains_with_local_array_closure_false_with_null()
    Contains_with_local_array_closure_false_with_null()
    public override void Contains_with_local_array_closure_false_with_null()Public Overrides Sub Contains_with_local_array_closure_false_with_null
  • Contains_with_local_array_closure_with_multiple_nulls()
    Contains_with_local_array_closure_with_multiple_nulls()
    public override void Contains_with_local_array_closure_with_multiple_nulls()Public Overrides Sub Contains_with_local_array_closure_with_multiple_nulls
  • Contains_with_local_array_closure_with_null()
    Contains_with_local_array_closure_with_null()
    public override void Contains_with_local_array_closure_with_null()Public Overrides Sub Contains_with_local_array_closure_with_null
  • From_sql_composed_with_relational_null_comparison()
    From_sql_composed_with_relational_null_comparison()
    public override void From_sql_composed_with_relational_null_comparison()Public Overrides Sub From_sql_composed_with_relational_null_comparison
  • Join_uses_database_semantics()
    Join_uses_database_semantics()
    public override void Join_uses_database_semantics()Public Overrides Sub Join_uses_database_semantics
  • Switching_null_semantics_produces_different_cache_entry()
    Switching_null_semantics_produces_different_cache_entry()
    public override void Switching_null_semantics_produces_different_cache_entry()Public Overrides Sub Switching_null_semantics_produces_different_cache_entry
  • Switching_parameter_value_to_null_produces_different_cache_entry()
    Switching_parameter_value_to_null_produces_different_cache_entry()
    public override void Switching_parameter_value_to_null_produces_different_cache_entry()Public Overrides Sub Switching_parameter_value_to_null_produces_different_cache_entry
  • Where_coalesce()
    Where_coalesce()
    public override void Where_coalesce()Public Overrides Sub Where_coalesce
  • Where_comparison_nonnull_constant_and_null_parameter()
    Where_comparison_nonnull_constant_and_null_parameter()
    public override void Where_comparison_nonnull_constant_and_null_parameter()Public Overrides Sub Where_comparison_nonnull_constant_and_null_parameter
  • Where_comparison_null_constant_and_nonnull_parameter()
    Where_comparison_null_constant_and_nonnull_parameter()
    public override void Where_comparison_null_constant_and_nonnull_parameter()Public Overrides Sub Where_comparison_null_constant_and_nonnull_parameter
  • Where_comparison_null_constant_and_null_parameter()
    Where_comparison_null_constant_and_null_parameter()
    public override void Where_comparison_null_constant_and_null_parameter()Public Overrides Sub Where_comparison_null_constant_and_null_parameter
  • Where_comparison_null_semantics_optimization_works_with_complex_predicates()
    Where_comparison_null_semantics_optimization_works_with_complex_predicates()
    public override void Where_comparison_null_semantics_optimization_works_with_complex_predicates()Public Overrides Sub Where_comparison_null_semantics_optimization_works_with_complex_predicates
  • Where_conditional_search_condition_in_result()
    Where_conditional_search_condition_in_result()
    public override void Where_conditional_search_condition_in_result()Public Overrides Sub Where_conditional_search_condition_in_result
  • Where_equal_nullable_with_null_value_parameter()
    Where_equal_nullable_with_null_value_parameter()
    public override void Where_equal_nullable_with_null_value_parameter()Public Overrides Sub Where_equal_nullable_with_null_value_parameter
  • Where_equal_using_relational_null_semantics()
    Where_equal_using_relational_null_semantics()
    public override void Where_equal_using_relational_null_semantics()Public Overrides Sub Where_equal_using_relational_null_semantics
  • Where_equal_using_relational_null_semantics_complex_with_parameter()
    Where_equal_using_relational_null_semantics_complex_with_parameter()
    public override void Where_equal_using_relational_null_semantics_complex_with_parameter()Public Overrides Sub Where_equal_using_relational_null_semantics_complex_with_parameter
  • Where_equal_using_relational_null_semantics_with_parameter()
    Where_equal_using_relational_null_semantics_with_parameter()
    public override void Where_equal_using_relational_null_semantics_with_parameter()Public Overrides Sub Where_equal_using_relational_null_semantics_with_parameter
  • Where_equal_with_and_and_contains()
    Where_equal_with_and_and_contains()
    public override void Where_equal_with_and_and_contains()Public Overrides Sub Where_equal_with_and_and_contains
  • Where_equal_with_coalesce()
    Where_equal_with_coalesce()
    public override void Where_equal_with_coalesce()Public Overrides Sub Where_equal_with_coalesce
  • Where_equal_with_coalesce_both_sides()
    Where_equal_with_coalesce_both_sides()
    public override void Where_equal_with_coalesce_both_sides()Public Overrides Sub Where_equal_with_coalesce_both_sides
  • Where_equal_with_conditional()
    Where_equal_with_conditional()
    public override void Where_equal_with_conditional()Public Overrides Sub Where_equal_with_conditional
  • Where_equal_with_conditional_non_nullable()
    Where_equal_with_conditional_non_nullable()
    public override void Where_equal_with_conditional_non_nullable()Public Overrides Sub Where_equal_with_conditional_non_nullable
  • Where_multiple_ands_with_null()
    Where_multiple_ands_with_null()
    public override void Where_multiple_ands_with_null()Public Overrides Sub Where_multiple_ands_with_null
  • Where_multiple_ands_with_nullable_parameter_and_constant()
    Where_multiple_ands_with_nullable_parameter_and_constant()
    public override void Where_multiple_ands_with_nullable_parameter_and_constant()Public Overrides Sub Where_multiple_ands_with_nullable_parameter_and_constant
  • Where_multiple_ands_with_nullable_parameter_and_constant_not_optimized()
    Where_multiple_ands_with_nullable_parameter_and_constant_not_optimized()
    public override void Where_multiple_ands_with_nullable_parameter_and_constant_not_optimized()Public Overrides Sub Where_multiple_ands_with_nullable_parameter_and_constant_not_optimized
  • Where_multiple_ors_with_null()
    Where_multiple_ors_with_null()
    public override void Where_multiple_ors_with_null()Public Overrides Sub Where_multiple_ors_with_null
  • Where_multiple_ors_with_nullable_parameter()
    Where_multiple_ors_with_nullable_parameter()
    public override void Where_multiple_ors_with_nullable_parameter()Public Overrides Sub Where_multiple_ors_with_nullable_parameter
  • Where_nested_conditional_search_condition_in_result()
    Where_nested_conditional_search_condition_in_result()
    public override void Where_nested_conditional_search_condition_in_result()Public Overrides Sub Where_nested_conditional_search_condition_in_result
  • Where_not_equal_nullable_with_null_value_parameter()
    Where_not_equal_nullable_with_null_value_parameter()
    public override void Where_not_equal_nullable_with_null_value_parameter()Public Overrides Sub Where_not_equal_nullable_with_null_value_parameter
  • Where_not_equal_using_relational_null_semantics()
    Where_not_equal_using_relational_null_semantics()
    public override void Where_not_equal_using_relational_null_semantics()Public Overrides Sub Where_not_equal_using_relational_null_semantics
  • Where_not_equal_using_relational_null_semantics_complex_with_parameter()
    Where_not_equal_using_relational_null_semantics_complex_with_parameter()
    public override void Where_not_equal_using_relational_null_semantics_complex_with_parameter()Public Overrides Sub Where_not_equal_using_relational_null_semantics_complex_with_parameter
  • Where_not_equal_using_relational_null_semantics_with_parameter()
    Where_not_equal_using_relational_null_semantics_with_parameter()
    public override void Where_not_equal_using_relational_null_semantics_with_parameter()Public Overrides Sub Where_not_equal_using_relational_null_semantics_with_parameter
  • Where_not_equal_with_coalesce()
    Where_not_equal_with_coalesce()
    public override void Where_not_equal_with_coalesce()Public Overrides Sub Where_not_equal_with_coalesce
  • Where_not_equal_with_coalesce_both_sides()
    Where_not_equal_with_coalesce_both_sides()
    public override void Where_not_equal_with_coalesce_both_sides()Public Overrides Sub Where_not_equal_with_coalesce_both_sides
  • Where_not_equal_with_conditional()
    Where_not_equal_with_conditional()
    public override void Where_not_equal_with_conditional()Public Overrides Sub Where_not_equal_with_conditional
  • Where_nullable_bool()
    Where_nullable_bool()
    public override void Where_nullable_bool()Public Overrides Sub Where_nullable_bool
  • Where_nullable_bool_equal_with_constant()
    Where_nullable_bool_equal_with_constant()
    public override void Where_nullable_bool_equal_with_constant()Public Overrides Sub Where_nullable_bool_equal_with_constant
  • Where_nullable_bool_with_null_check()
    Where_nullable_bool_with_null_check()
    public override void Where_nullable_bool_with_null_check()Public Overrides Sub Where_nullable_bool_with_null_check

Details

Assembly

Microsoft.EntityFrameworkCore.SqlServer.FunctionalTests.dll