forked from nhibernate/nhibernate-core
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathSubqueries.cs
194 lines (158 loc) · 5.98 KB
/
Subqueries.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
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
using System;
namespace NHibernate.Expression
{
/// <summary>
/// Factory class for AbstractCriterion instances that represent
/// involving subqueries.
/// <c>Expression</c>
/// <c>Projection</c>
/// <c>AbstractCriterion</c>
/// </summary>
public class Subqueries
{
public static AbstractCriterion Exists(DetachedCriteria dc)
{
return new ExistsSubqueryExpression("exists", dc);
}
public static AbstractCriterion NotExists(DetachedCriteria dc)
{
return new ExistsSubqueryExpression("not exists", dc);
}
public static AbstractCriterion PropertyEqAll(String propertyName, DetachedCriteria dc)
{
return new PropertySubqueryExpression(propertyName, "=", "all", dc);
}
public static AbstractCriterion PropertyIn(String propertyName, DetachedCriteria dc)
{
return new PropertySubqueryExpression(propertyName, "in", null, dc);
}
public static AbstractCriterion PropertyNotIn(String propertyName, DetachedCriteria dc)
{
return new PropertySubqueryExpression(propertyName, "not in", null, dc);
}
public static AbstractCriterion PropertyEq(String propertyName, DetachedCriteria dc)
{
return new PropertySubqueryExpression(propertyName, "=", null, dc);
}
public static AbstractCriterion PropertyNe(String propertyName, DetachedCriteria dc)
{
return new PropertySubqueryExpression(propertyName, "<>", null, dc);
}
public static AbstractCriterion PropertyGt(String propertyName, DetachedCriteria dc)
{
return new PropertySubqueryExpression(propertyName, ">", null, dc);
}
public static AbstractCriterion PropertyLt(String propertyName, DetachedCriteria dc)
{
return new PropertySubqueryExpression(propertyName, "<", null, dc);
}
public static AbstractCriterion PropertyGe(String propertyName, DetachedCriteria dc)
{
return new PropertySubqueryExpression(propertyName, ">=", null, dc);
}
public static AbstractCriterion PropertyLe(String propertyName, DetachedCriteria dc)
{
return new PropertySubqueryExpression(propertyName, "<=", null, dc);
}
public static AbstractCriterion PropertyGtAll(String propertyName, DetachedCriteria dc)
{
return new PropertySubqueryExpression(propertyName, ">", "all", dc);
}
public static AbstractCriterion PropertyLtAll(String propertyName, DetachedCriteria dc)
{
return new PropertySubqueryExpression(propertyName, "<", "all", dc);
}
public static AbstractCriterion PropertyGeAll(String propertyName, DetachedCriteria dc)
{
return new PropertySubqueryExpression(propertyName, ">=", "all", dc);
}
public static AbstractCriterion PropertyLeAll(String propertyName, DetachedCriteria dc)
{
return new PropertySubqueryExpression(propertyName, "<=", "all", dc);
}
public static AbstractCriterion PropertyGtSome(String propertyName, DetachedCriteria dc)
{
return new PropertySubqueryExpression(propertyName, ">", "some", dc);
}
public static AbstractCriterion PropertyLtSome(String propertyName, DetachedCriteria dc)
{
return new PropertySubqueryExpression(propertyName, "<", "some", dc);
}
public static AbstractCriterion PropertyGeSome(String propertyName, DetachedCriteria dc)
{
return new PropertySubqueryExpression(propertyName, ">=", "some", dc);
}
public static AbstractCriterion PropertyLeSome(String propertyName, DetachedCriteria dc)
{
return new PropertySubqueryExpression(propertyName, "<=", "some", dc);
}
public static AbstractCriterion EqAll(Object value, DetachedCriteria dc)
{
return new SimpleSubqueryExpression(value, "=", "all", dc);
}
public static AbstractCriterion In(Object value, DetachedCriteria dc)
{
return new SimpleSubqueryExpression(value, "in", null, dc);
}
public static AbstractCriterion NotIn(Object value, DetachedCriteria dc)
{
return new SimpleSubqueryExpression(value, "not in", null, dc);
}
public static AbstractCriterion Eq(Object value, DetachedCriteria dc)
{
return new SimpleSubqueryExpression(value, "=", null, dc);
}
public static AbstractCriterion Gt(Object value, DetachedCriteria dc)
{
return new SimpleSubqueryExpression(value, ">", null, dc);
}
public static AbstractCriterion Lt(Object value, DetachedCriteria dc)
{
return new SimpleSubqueryExpression(value, "<", null, dc);
}
public static AbstractCriterion Ge(Object value, DetachedCriteria dc)
{
return new SimpleSubqueryExpression(value, ">=", null, dc);
}
public static AbstractCriterion Le(Object value, DetachedCriteria dc)
{
return new SimpleSubqueryExpression(value, "<=", null, dc);
}
public static AbstractCriterion Ne(Object value, DetachedCriteria dc)
{
return new SimpleSubqueryExpression(value, "<>", null, dc);
}
public static AbstractCriterion GtAll(Object value, DetachedCriteria dc)
{
return new SimpleSubqueryExpression(value, ">", "all", dc);
}
public static AbstractCriterion LtAll(Object value, DetachedCriteria dc)
{
return new SimpleSubqueryExpression(value, "<", "all", dc);
}
public static AbstractCriterion GeAll(Object value, DetachedCriteria dc)
{
return new SimpleSubqueryExpression(value, ">=", "all", dc);
}
public static AbstractCriterion LeAll(Object value, DetachedCriteria dc)
{
return new SimpleSubqueryExpression(value, "<=", "all", dc);
}
public static AbstractCriterion GtSome(Object value, DetachedCriteria dc)
{
return new SimpleSubqueryExpression(value, ">", "some", dc);
}
public static AbstractCriterion LtSome(Object value, DetachedCriteria dc)
{
return new SimpleSubqueryExpression(value, "<", "some", dc);
}
public static AbstractCriterion GeSome(Object value, DetachedCriteria dc)
{
return new SimpleSubqueryExpression(value, ">=", "some", dc);
}
public static AbstractCriterion LeSome(Object value, DetachedCriteria dc)
{
return new SimpleSubqueryExpression(value, "<=", "some", dc);
}
}
}