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
|
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.Data.Linq.Mapping;
using System.Linq;
using System.Reflection;
using System.Diagnostics;
using System.Collections.Specialized;
using System.Collections;
using System.Globalization;
namespace System.Web.DynamicData.ModelProviders {
internal sealed class DLinqAssociationProvider : AssociationProvider {
public DLinqAssociationProvider(DLinqColumnProvider column) {
FromColumn = column;
MetaAssociation association = column.Member.Association;
SetOtherEndOfAssociation(association);
SetDirection(association);
Debug.Assert(Direction != AssociationDirection.ManyToMany, "Many to Many is not supported by Linq to SQL");
SetAssociationKeyInfo(association);
}
private void SetAssociationKeyInfo(MetaAssociation association) {
DLinqColumnProvider column = (DLinqColumnProvider)FromColumn;
List<string> foreignKeyNames = new List<string>();
int count = column.Member.Association.ThisKey.Count;
for (int i = 0; i < count; i++) {
MetaDataMember thisKeyMetaDataMember = column.Member.Association.ThisKey[i];
MetaDataMember otherKeyMetaDataMember = column.Member.Association.OtherKey[i];
DLinqColumnProvider thisEntityMemberComponent = FindColumn(column.Table, thisKeyMetaDataMember.Name);
if (ShouldRemoveThisAssociation(association)) {
column.ShouldRemove = true;
return;
}
foreignKeyNames.Add(thisEntityMemberComponent.Name);
if (thisEntityMemberComponent.IsPrimaryKey) {
IsPrimaryKeyInThisTable = true;
}
if (association.IsForeignKey) {
thisEntityMemberComponent.IsForeignKeyComponent = true;
}
}
ForeignKeyNames = new ReadOnlyCollection<string>(foreignKeyNames);
}
private bool ShouldRemoveThisAssociation(MetaAssociation association) {
if (Direction == AssociationDirection.ManyToOne && !association.OtherKeyIsPrimaryKey) {
return true;
}
if (Direction == AssociationDirection.OneToMany && !association.ThisKeyIsPrimaryKey) {
return true;
}
if (Direction == AssociationDirection.OneToOne) {
if (!association.IsForeignKey && !association.ThisKeyIsPrimaryKey) {
return true;
}
if (association.IsForeignKey && !association.OtherKeyIsPrimaryKey) {
return true;
}
}
return false;
}
private void SetOtherEndOfAssociation(MetaAssociation association) {
DLinqTableProvider entityMemberParentEntity = (DLinqTableProvider)FromColumn.Table;
DLinqDataModelProvider parentEntityDataContext = (DLinqDataModelProvider)entityMemberParentEntity.DataModel;
if (association.OtherMember != null) {
ToColumn = parentEntityDataContext.ColumnLookup[(PropertyInfo)association.OtherMember.Member];
} else {
ToTable = ((DLinqDataModelProvider)FromColumn.Table.DataModel).DLinqTables.Single(tp => tp.EntityType == association.OtherType.Type);
}
}
private static DLinqColumnProvider FindColumn(TableProvider table, String columnName) {
//
return (DLinqColumnProvider)table.Columns.First(member => member.Name.Equals(columnName));
}
private void SetDirection(MetaAssociation association) {
if (association.IsMany) {
Direction = AssociationDirection.OneToMany;
} else if (association.OtherMember == null || association.OtherMember.Association.IsMany) {
// there might not be the other member if this is a one-sided association
Direction = AssociationDirection.ManyToOne;
} else {
Direction = AssociationDirection.OneToOne;
}
}
public override string GetSortExpression(ColumnProvider sortColumn) {
return GetSortExpression(sortColumn, "{0}.{1}");
}
}
}
|
