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
|
// Copyright (c) Microsoft Open Technologies, Inc. All rights reserved. See License.txt in the project root for license information.
namespace System.Data.Entity.Query
{
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using Xunit;
public class LeftOuterJoinEliminationContext : DbContext
{
public DbSet<Customer> Customers { get; set; }
public DbSet<Document> Documents { get; set; }
public DbSet<DocumentDetail> DocumentDetails { get; set; }
}
public class Customer
{
[Key]
public int? CustomerId { get; set; }
public int PersonId { get; set; }
}
public class Document
{
[Key]
public int? DocumentId { get; set; }
public int? CustomerId { get; set; }
[ForeignKey("CustomerId")]
public Customer Customer { get; set; }
}
public class DocumentDetail
{
[Key]
public int? DocumentDetailId { get; set; }
public int? DocumentId { get; set; }
[ForeignKey("DocumentId")]
public Document Document { get; set; }
}
public class JoinEliminationTests : FunctionalTestBase
{
[Fact]
public static void LeftOuterJoin_duplicates_are_eliminated()
{
const string expectedSql =
@"SELECT
[Extent1].[DocumentDetailId] AS [DocumentDetailId],
[Extent1].[DocumentId] AS [DocumentId]
FROM [dbo].[DocumentDetails] AS [Extent1]
LEFT OUTER JOIN [dbo].[Documents] AS [Extent2] ON [Extent1].[DocumentId] = [Extent2].[DocumentId]
LEFT OUTER JOIN [dbo].[Customers] AS [Extent3] ON [Extent2].[CustomerId] = [Extent3].[CustomerId]
WHERE [Extent3].[PersonId] IN (1,2)";
using (var context = new LeftOuterJoinEliminationContext())
{
var query = context.DocumentDetails.Where(x => x.Document.Customer.PersonId == 1 || x.Document.Customer.PersonId == 2);
QueryTestHelpers.VerifyQuery(query, expectedSql);
}
}
}
}
|
