-
Notifications
You must be signed in to change notification settings - Fork 3.1k
/
RelationalNorthwindDbFunctionsQueryTestBase.cs
107 lines (91 loc) · 4.04 KB
/
RelationalNorthwindDbFunctionsQueryTestBase.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
// Licensed to the .NET Foundation under one or more agreements.
// The .NET Foundation licenses this file to you under the MIT license.
using Microsoft.EntityFrameworkCore.TestModels.Northwind;
namespace Microsoft.EntityFrameworkCore.Query;
public abstract class NorthwindDbFunctionsQueryRelationalTestBase<TFixture> : NorthwindDbFunctionsQueryTestBase<TFixture>
where TFixture : NorthwindQueryRelationalFixture<NoopModelCustomizer>, new()
{
protected NorthwindDbFunctionsQueryRelationalTestBase(TFixture fixture)
: base(fixture)
{
}
protected virtual bool CanExecuteQueryString
=> false;
protected override QueryAsserter CreateQueryAsserter(TFixture fixture)
=> new RelationalQueryAsserter(
fixture, RewriteExpectedQueryExpression, RewriteServerQueryExpression, canExecuteQueryString: CanExecuteQueryString);
[ConditionalTheory]
[MemberData(nameof(IsAsyncData))]
public virtual Task Collate_case_insensitive(bool async)
=> AssertCount(
async,
ss => ss.Set<Customer>(),
ss => ss.Set<Customer>(),
c => EF.Functions.Collate(c.ContactName, CaseInsensitiveCollation) == "maria anders",
c => c.ContactName.Equals("maria anders", StringComparison.OrdinalIgnoreCase));
[ConditionalTheory]
[MemberData(nameof(IsAsyncData))]
public virtual Task Collate_case_sensitive(bool async)
=> AssertCount(
async,
ss => ss.Set<Customer>(),
ss => ss.Set<Customer>(),
c => EF.Functions.Collate(c.ContactName, CaseSensitiveCollation) == "maria anders",
c => c.ContactName.Equals("maria anders", StringComparison.Ordinal));
[ConditionalTheory]
[MemberData(nameof(IsAsyncData))]
public virtual Task Collate_case_sensitive_constant(bool async)
=> AssertCount(
async,
ss => ss.Set<Customer>(),
ss => ss.Set<Customer>(),
c => c.ContactName == EF.Functions.Collate("maria anders", CaseSensitiveCollation),
c => c.ContactName.Equals("maria anders", StringComparison.Ordinal));
[ConditionalTheory]
[MemberData(nameof(IsAsyncData))]
public virtual Task Least(bool async)
=> AssertQuery(
async,
ss => ss.Set<OrderDetail>().Where(od => EF.Functions.Least(od.OrderID, 10251) == 10251),
ss => ss.Set<OrderDetail>().Where(od => Math.Min(od.OrderID, 10251) == 10251));
[ConditionalTheory]
[MemberData(nameof(IsAsyncData))]
public virtual Task Greatest(bool async)
=> AssertQuery(
async,
ss => ss.Set<OrderDetail>().Where(od => EF.Functions.Greatest(od.OrderID, 10251) == 10251),
ss => ss.Set<OrderDetail>().Where(od => Math.Max(od.OrderID, 10251) == 10251));
[ConditionalTheory]
[MemberData(nameof(IsAsyncData))]
public virtual async Task Least_with_parameter_array_is_not_supported(bool async)
{
var arr = new[] { 1, 2 };
await AssertTranslationFailed(
() =>
AssertQuery(
async,
ss => ss.Set<OrderDetail>().Where(od => EF.Functions.Least(arr) == 10251)));
}
[ConditionalTheory]
[MemberData(nameof(IsAsyncData))]
public virtual async Task Greatest_with_parameter_array_is_not_supported(bool async)
{
var arr = new[] { 1, 2 };
await AssertTranslationFailed(
() =>
AssertQuery(
async,
ss => ss.Set<OrderDetail>().Where(od => EF.Functions.Greatest(arr) == 10251)));
}
[ConditionalTheory]
[MemberData(nameof(IsAsyncData))]
public virtual Task NullIf(bool async)
=> AssertCount(
async,
ss => ss.Set<Customer>(),
ss => ss.Set<Customer>(),
c => EF.Functions.NullIf(c.ContactName, "maria anders") == null,
c => c.ContactName == null);
protected abstract string CaseInsensitiveCollation { get; }
protected abstract string CaseSensitiveCollation { get; }
}