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
|
// Copyright (c) Microsoft Open Technologies, Inc. All rights reserved. See License.txt in the project root for license information.
namespace PlanCompilerTests
{
using System.Data.Entity;
using System.Linq;
using AdvancedPatternsModel;
using Xunit;
/// <summary>
/// Tests for GroupBy statements in Linq queries.
/// </summary>
public class LinqGroupByTests : FunctionalTestBase
{
#region Infrastructure/setup
#endregion
#region Tests for GroupBy that trigger an aggregate pushdown
[Fact]
private void GroupBy_aggregate_pushdown_single_key()
{
using (var context = new AdvancedPatternsMasterContext())
{
var groupByQuery = from workOrder in context.WorkOrders
group new
{
workOrder.WorkOrderId,
workOrder.Details
} by workOrder.EmployeeId
into ordersByEmployeeGroup
select new
{
EmployeeId = ordersByEmployeeGroup.Key,
OrderCount = ordersByEmployeeGroup.Count(),
MaxOrderId = ordersByEmployeeGroup.Max(o => o.WorkOrderId)
};
var sql = groupByQuery.ToString();
Assert.True(sql != null && sql.ToUpper().Contains("GROUP BY"));
}
}
// Dev11 448362
[Fact]
private void GroupBy_aggregate_pushdown_translates_NewRecordOp()
{
using (var context = new AdvancedPatternsMasterContext())
{
var groupByNewQuery = from workOrder in context.WorkOrders
group new
{
workOrder.WorkOrderId,
workOrder.Details
} by new
{
workOrder.EmployeeId
}
into ordersByEmployeeGroup
select new
{
ordersByEmployeeGroup.Key.EmployeeId,
OrderCount = ordersByEmployeeGroup.Count(),
MaxOrderId = ordersByEmployeeGroup.Max(o => o.WorkOrderId)
};
var sql = groupByNewQuery.ToString();
Assert.True(sql != null && sql.ToUpper().Contains("GROUP BY"));
}
}
#endregion
}
}
|
