Mercurial > pub > bltoolkit

comparison Source/Data/Linq/Expressions.cs @ 0:f990fcb411a9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Копия текущей версии из github
author cin
date Thu, 27 Mar 2014 21:46:09 +0400
parents
children
comparison
equal deleted inserted replaced
-1:000000000000 0:f990fcb411a9
1 using System;
2 using System.Collections.Generic;
3 using System.Data.Linq;
4 using System.Linq.Expressions;
5 using System.Reflection;
6 using System.Text;
7
8 #region ReSharper disables
9 // ReSharper disable RedundantTypeArgumentsOfMethod
10 // ReSharper disable RedundantCast
11 // ReSharper disable PossibleInvalidOperationException
12 // ReSharper disable CSharpWarnings::CS0693
13 // ReSharper disable RedundantToStringCall
14 #endregion
15
16 namespace BLToolkit.Data.Linq
17 {
18 using B = Boolean;
19 using C = Char;
20 using S = String;
21 using I = Int32;
22 using O = Object;
23 using D = DateTime;
24 using T = TimeSpan;
25 using F = Double;
26 using M = Decimal;
27
28 public static class Expressions
29 {
30 #region MapMember
31
32 public static void MapMember(MemberInfo memberInfo, LambdaExpression expression)
33 {
34 MapMember("", memberInfo, expression);
35 }
36
37 public static void MapMember(string providerName, MemberInfo memberInfo, LambdaExpression expression)
38 {
39 Dictionary<MemberInfo,LambdaExpression> dic;
40
41 if (!_members.TryGetValue(providerName, out dic))
42 _members.Add(providerName, dic = new Dictionary<MemberInfo,LambdaExpression>());
43
44 dic[memberInfo] = expression;
45 }
46
47 public static void MapMember(Expression<Func<object>> memberInfo, LambdaExpression expression)
48 {
49 MapMember("", M(memberInfo), expression);
50 }
51
52 public static void MapMember(string providerName, Expression<Func<object>> memberInfo, LambdaExpression expression)
53 {
54 MapMember(providerName, M(memberInfo), expression);
55 }
56
57 public static void MapMember<T>(Expression<Func<T,object>> memberInfo, LambdaExpression expression)
58 {
59 MapMember("", M(memberInfo), expression);
60 }
61
62 public static void MapMember<T>(string providerName, Expression<Func<T,object>> memberInfo, LambdaExpression expression)
63 {
64 MapMember(providerName, M(memberInfo), expression);
65 }
66
67 public static void MapMember<TR> (string providerName, Expression<Func<TR>> memberInfo, Expression<Func<TR>> expression) { MapMember(providerName, ReflectionHelper.MemeberInfo(memberInfo), expression); }
68 public static void MapMember<TR> ( Expression<Func<TR>> memberInfo, Expression<Func<TR>> expression) { MapMember("", ReflectionHelper.MemeberInfo(memberInfo), expression); }
69 public static void MapMember<T1,TR> (string providerName, Expression<Func<T1,TR>> memberInfo, Expression<Func<T1,TR>> expression) { MapMember(providerName, ReflectionHelper.MemeberInfo(memberInfo), expression); }
70 public static void MapMember<T1,TR> ( Expression<Func<T1,TR>> memberInfo, Expression<Func<T1,TR>> expression) { MapMember("", ReflectionHelper.MemeberInfo(memberInfo), expression); }
71 public static void MapMember<T1,T2,TR> (string providerName, Expression<Func<T1,T2,TR>> memberInfo, Expression<Func<T1,T2,TR>> expression) { MapMember(providerName, ReflectionHelper.MemeberInfo(memberInfo), expression); }
72 public static void MapMember<T1,T2,TR> ( Expression<Func<T1,T2,TR>> memberInfo, Expression<Func<T1,T2,TR>> expression) { MapMember("", ReflectionHelper.MemeberInfo(memberInfo), expression); }
73 public static void MapMember<T1,T2,T3,TR> (string providerName, Expression<Func<T1,T2,T3,TR>> memberInfo, Expression<Func<T1,T2,T3,TR>> expression) { MapMember(providerName, ReflectionHelper.MemeberInfo(memberInfo), expression); }
74 public static void MapMember<T1,T2,T3,TR> ( Expression<Func<T1,T2,T3,TR>> memberInfo, Expression<Func<T1,T2,T3,TR>> expression) { MapMember("", ReflectionHelper.MemeberInfo(memberInfo), expression); }
75 public static void MapMember<T1,T2,T3,T4,TR> (string providerName, Expression<Func<T1,T2,T3,T4,TR>> memberInfo, Expression<Func<T1,T2,T3,T4,TR>> expression) { MapMember(providerName, ReflectionHelper.MemeberInfo(memberInfo), expression); }
76 public static void MapMember<T1,T2,T3,T4,TR> ( Expression<Func<T1,T2,T3,T4,TR>> memberInfo, Expression<Func<T1,T2,T3,T4,TR>> expression) { MapMember("", ReflectionHelper.MemeberInfo(memberInfo), expression); }
77 public static void MapMember<T1,T2,T3,T4,T5,TR>(string providerName, Expression<Func<T1,T2,T3,T4,T5,TR>> memberInfo, Expression<Func<T1,T2,T3,T4,T5,TR>> expression) { MapMember(providerName, ReflectionHelper.MemeberInfo(memberInfo), expression); }
78 public static void MapMember<T1,T2,T3,T4,T5,TR>( Expression<Func<T1,T2,T3,T4,T5,TR>> memberInfo, Expression<Func<T1,T2,T3,T4,T5,TR>> expression) { MapMember("", ReflectionHelper.MemeberInfo(memberInfo), expression); }
79
80 #endregion
81
82 #region Public Members
83
84 public static LambdaExpression ConvertMember(string providerName, MemberInfo mi)
85 {
86 Dictionary<MemberInfo,LambdaExpression> dic;
87 LambdaExpression expr;
88
89 if (Members.TryGetValue(providerName, out dic))
90 if (dic.TryGetValue(mi, out expr))
91 return expr;
92
93 if (!Members[""].TryGetValue(mi, out expr))
94 {
95 if (mi is MethodInfo && mi.Name == "CompareString" && mi.DeclaringType.FullName == "Microsoft.VisualBasic.CompilerServices.Operators")
96 {
97 lock (_members)
98 {
99 if (!Members[""].TryGetValue(mi, out expr))
100 {
101 expr = L<S,S,B,I>((s1,s2,b) => b ? string.CompareOrdinal(s1.ToUpper(), s2.ToUpper()) : string.CompareOrdinal(s1, s2));
102
103 _members[""].Add(mi, expr);
104 }
105 }
106 }
107 }
108
109 return expr;
110 }
111
112 #endregion
113
114 #region Function Mapping
115
116 #region Helpers
117
118 static MemberInfo M<T>(Expression<Func<T,object>> func)
119 {
120 return ReflectionHelper.MemeberInfo(func);
121 }
122
123 static MemberInfo M(Expression<Func<object>> func)
124 {
125 return ReflectionHelper.MemeberInfo(func);
126 }
127
128 static LambdaExpression L<TR> (Expression<Func<TR>> func) { return func; }
129 static LambdaExpression L<T1,TR> (Expression<Func<T1,TR>> func) { return func; }
130 static LambdaExpression L<T1,T2,TR> (Expression<Func<T1,T2,TR>> func) { return func; }
131 static LambdaExpression L<T1,T2,T3,TR> (Expression<Func<T1,T2,T3,TR>> func) { return func; }
132 static LambdaExpression L<T1,T2,T3,T4,TR> (Expression<Func<T1,T2,T3,T4,TR>> func) { return func; }
133 static LambdaExpression L<T1,T2,T3,T4,T5,TR> (Expression<Func<T1,T2,T3,T4,T5,TR>> func) { return func; }
134 static LambdaExpression L<T1,T2,T3,T4,T5,T6,TR> (Expression<Func<T1,T2,T3,T4,T5,T6,TR>> func) { return func; }
135
136 #endregion
137
138 static public Dictionary<string,Dictionary<MemberInfo,LambdaExpression>> Members { get { return _members; } }
139 static readonly Dictionary<string,Dictionary<MemberInfo,LambdaExpression>> _members = new Dictionary<string,Dictionary<MemberInfo,LambdaExpression>>
140 {
141 { "", new Dictionary<MemberInfo,LambdaExpression> {
142
143 #region String
144
145 { M(() => "".Length ), L<S,I> ( obj => Sql.Length(obj).Value) },
146 { M(() => "".Substring (0) ), L<S,I,S> ((obj,p0) => Sql.Substring(obj, p0 + 1, obj.Length - p0)) },
147 { M(() => "".Substring (0,0) ), L<S,I,I,S> ((obj,p0,p1) => Sql.Substring(obj, p0 + 1, p1)) },
148 { M(() => "".ContainsExactly("") ), L<S,S,I> ((obj,p0) => p0.Length == 0 ? 0 : (Sql.ContainsExactly(p0, obj) .Value) - 1) },
149 { M(() => "".IndexOf ("") ), L<S,S,I> ((obj,p0) => p0.Length == 0 ? 0 : (Sql.CharIndex(p0, obj) .Value) - 1) },
150 { M(() => "".IndexOf ("",0) ), L<S,S,I,I> ((obj,p0,p1) => p0.Length == 0 && obj.Length > p1 ? p1 : (Sql.CharIndex(p0, obj, p1 + 1).Value) - 1) },
151 { M(() => "".IndexOf ("",0,0) ), L<S,S,I,I,I>((obj,p0,p1,p2) => p0.Length == 0 && obj.Length > p1 ? p1 : (Sql.CharIndex(p0, Sql.Left(obj, p2), p1) .Value) - 1) },
152 { M(() => "".IndexOf (' ') ), L<S,C,I> ((obj,p0) => (Sql.CharIndex(p0, obj) .Value) - 1) },
153 { M(() => "".IndexOf (' ',0) ), L<S,C,I,I> ((obj,p0,p1) => (Sql.CharIndex(p0, obj, p1 + 1).Value) - 1) },
154 { M(() => "".IndexOf (' ',0,0) ), L<S,C,I,I,I>((obj,p0,p1,p2) => (Sql.CharIndex(p0, Sql.Left(obj, p2), p1) ?? 0) - 1) },
155 { M(() => "".LastIndexOf("") ), L<S,S,I> ((obj,p0) => p0.Length == 0 ? obj.Length - 1 : (Sql.CharIndex(p0, obj) .Value) == 0 ? -1 : obj.Length - (Sql.CharIndex(Sql.Reverse(p0), Sql.Reverse(obj)) .Value) - p0.Length + 1) },
156 { M(() => "".LastIndexOf("",0) ), L<S,S,I,I> ((obj,p0,p1) => p0.Length == 0 ? p1 : (Sql.CharIndex(p0, obj, p1 + 1).Value) == 0 ? -1 : obj.Length - (Sql.CharIndex(Sql.Reverse(p0), Sql.Reverse(obj.Substring(p1, obj.Length - p1))).Value) - p0.Length + 1) },
157 { M(() => "".LastIndexOf("",0,0) ), L<S,S,I,I,I>((obj,p0,p1,p2) => p0.Length == 0 ? p1 : (Sql.CharIndex(p0, Sql.Left(obj, p1 + p2), p1 + 1).Value) == 0 ? -1 : p1 + p2 - (Sql.CharIndex(Sql.Reverse(p0), Sql.Reverse(obj.Substring(p1, p2))) .Value) - p0.Length + 1) },
158 { M(() => "".LastIndexOf(' ') ), L<S,C,I> ((obj,p0) => (Sql.CharIndex(p0, obj) .Value) == 0 ? -1 : obj.Length - (Sql.CharIndex(p0, Sql.Reverse(obj)) .Value)) },
159 { M(() => "".LastIndexOf(' ',0) ), L<S,C,I,I> ((obj,p0,p1) => (Sql.CharIndex(p0, obj, p1 + 1) .Value) == 0 ? -1 : obj.Length - (Sql.CharIndex(p0, Sql.Reverse(obj.Substring(p1, obj.Length - p1))).Value)) },
160 { M(() => "".LastIndexOf(' ',0,0) ), L<S,C,I,I,I>((obj,p0,p1,p2) => (Sql.CharIndex(p0, Sql.Left(obj, p1 + p2), p1 + 1).Value) == 0 ? -1 : p1 + p2 - (Sql.CharIndex(p0, Sql.Reverse(obj.Substring(p1, p2))) .Value)) },
161 { M(() => "".Insert (0,"") ), L<S,I,S,S> ((obj,p0,p1) => obj.Length == p0 ? obj + p1 : Sql.Stuff(obj, p0 + 1, 0, p1)) },
162 { M(() => "".Remove (0) ), L<S,I,S> ((obj,p0) => Sql.Left (obj, p0)) },
163 { M(() => "".Remove (0,0) ), L<S,I,I,S> ((obj,p0,p1) => Sql.Stuff (obj, p0 + 1, p1, "")) },
164 { M(() => "".PadLeft (0) ), L<S,I,S> ((obj,p0) => Sql.PadLeft (obj, p0, ' ')) },
165 { M(() => "".PadLeft (0,' ') ), L<S,I,C,S> ((obj,p0,p1) => Sql.PadLeft (obj, p0, p1)) },
166 { M(() => "".PadRight (0) ), L<S,I,S> ((obj,p0) => Sql.PadRight (obj, p0, ' ')) },
167 { M(() => "".PadRight (0,' ') ), L<S,I,C,S> ((obj,p0,p1) => Sql.PadRight (obj, p0, p1)) },
168 { M(() => "".Replace ("","") ), L<S,S,S,S> ((obj,p0,p1) => Sql.Replace (obj, p0, p1)) },
169 { M(() => "".Replace (' ',' ') ), L<S,C,C,S> ((obj,p0,p1) => Sql.Replace (obj, p0, p1)) },
170 { M(() => "".Trim () ), L<S,S> ( obj => Sql.Trim (obj)) },
171 { M(() => "".TrimEnd () ), L<S,C[],S> ((obj,ch) => TrimRight(obj, ch)) },
172 { M(() => "".TrimStart () ), L<S,C[],S> ((obj,ch) => TrimLeft (obj, ch)) },
173 { M(() => "".ToLower () ), L<S,S> ( obj => Sql.Lower(obj)) },
174 { M(() => "".ToUpper () ), L<S,S> ( obj => Sql.Upper(obj)) },
175 { M(() => "".CompareTo ("") ), L<S,S,I> ((obj,p0) => ConvertToCaseCompareTo(obj, p0).Value ) },
176 { M(() => "".CompareTo (1) ), L<S,O,I> ((obj,p0) => ConvertToCaseCompareTo(obj, p0.ToString()).Value ) },
177
178 { M(() => string.IsNullOrEmpty ("") ), L<S,B> ( p0 => p0 == null || p0.Length == 0) },
179 { M(() => string.CompareOrdinal("","")), L<S,S,I> ((s1,s2) => s1.CompareTo(s2)) },
180 { M(() => string.CompareOrdinal("",0,"",0,0)), L<S,I,S,I,I,I> ((s1,i1,s2,i2,l) => s1.Substring(i1, l).CompareTo(s2.Substring(i2, l))) },
181 { M(() => string.Compare ("","")), L<S,S,I> ((s1,s2) => s1.CompareTo(s2)) },
182 { M(() => string.Compare ("",0,"",0,0)), L<S,I,S,I,I,I> ((s1,i1,s2,i2,l) => s1.Substring(i1,l).CompareTo(s2.Substring(i2,l))) },
183 #if !SILVERLIGHT
184 { M(() => string.Compare ("","",true)), L<S,S,B,I> ((s1,s2,b) => b ? s1.ToLower().CompareTo(s2.ToLower()) : s1.CompareTo(s2)) },
185 { M(() => string.Compare ("",0,"",0,0,true)), L<S,I,S,I,I,B,I>((s1,i1,s2,i2,l,b) => b ? s1.Substring(i1,l).ToLower().CompareTo(s2.Substring(i2, l).ToLower()) : s1.Substring(i1, l).CompareTo(s2.Substring(i2, l))) },
186 #endif
187
188 { M(() => AltStuff("",0,0,"")), L<S,I?,I?,S,S>((p0,p1,p2,p3) => Sql.Left(p0, p1 - 1) + p3 + Sql.Right(p0, p0.Length - (p1 + p2 - 1))) },
189
190 #endregion
191
192 #region Binary
193
194 { M(() => ((Binary)null).Length ), L<Binary,I>(obj => Sql.Length(obj).Value) },
195
196 #endregion
197
198 #region DateTime
199
200 { M(() => Sql.GetDate() ), L<D> (() => Sql.CurrentTimestamp2 ) },
201 { M(() => DateTime.Now ), L<D> (() => Sql.CurrentTimestamp2 ) },
202
203 { M(() => DateTime.Now.Year ), L<D,I> (obj => Sql.DatePart(Sql.DateParts.Year, obj).Value ) },
204 { M(() => DateTime.Now.Month ), L<D,I> (obj => Sql.DatePart(Sql.DateParts.Month, obj).Value ) },
205 { M(() => DateTime.Now.DayOfYear ), L<D,I> (obj => Sql.DatePart(Sql.DateParts.DayOfYear, obj).Value ) },
206 { M(() => DateTime.Now.Day ), L<D,I> (obj => Sql.DatePart(Sql.DateParts.Day, obj).Value ) },
207 { M(() => DateTime.Now.DayOfWeek ), L<D,I> (obj => Sql.DatePart(Sql.DateParts.WeekDay, obj).Value - 1 ) },
208 { M(() => DateTime.Now.Hour ), L<D,I> (obj => Sql.DatePart(Sql.DateParts.Hour, obj).Value ) },
209 { M(() => DateTime.Now.Minute ), L<D,I> (obj => Sql.DatePart(Sql.DateParts.Minute, obj).Value ) },
210 { M(() => DateTime.Now.Second ), L<D,I> (obj => Sql.DatePart(Sql.DateParts.Second, obj).Value ) },
211 { M(() => DateTime.Now.Millisecond ), L<D,I> (obj => Sql.DatePart(Sql.DateParts.Millisecond, obj).Value ) },
212 { M(() => DateTime.Now.Date ), L<D,D> (obj => Sql.Convert2(Sql.Date, obj) ) },
213 { M(() => DateTime.Now.TimeOfDay ), L<D,T> (obj => Sql.DateToTime(Sql.Convert2(Sql.Time, obj)).Value ) },
214 { M(() => DateTime.Now.AddYears (0)), L<D,I,D> ((obj,p0) => Sql.DateAdd(Sql.DateParts.Year, p0, obj).Value ) },
215 { M(() => DateTime.Now.AddMonths (0)), L<D,I,D> ((obj,p0) => Sql.DateAdd(Sql.DateParts.Month, p0, obj).Value ) },
216 { M(() => DateTime.Now.AddDays (0)), L<D,F,D> ((obj,p0) => Sql.DateAdd(Sql.DateParts.Day, p0, obj).Value ) },
217 { M(() => DateTime.Now.AddHours (0)), L<D,F,D> ((obj,p0) => Sql.DateAdd(Sql.DateParts.Hour, p0, obj).Value ) },
218 { M(() => DateTime.Now.AddMinutes (0)), L<D,F,D> ((obj,p0) => Sql.DateAdd(Sql.DateParts.Minute, p0, obj).Value ) },
219 { M(() => DateTime.Now.AddSeconds (0)), L<D,F,D> ((obj,p0) => Sql.DateAdd(Sql.DateParts.Second, p0, obj).Value ) },
220 { M(() => DateTime.Now.AddMilliseconds(0)), L<D,F,D> ((obj,p0) => Sql.DateAdd(Sql.DateParts.Millisecond, p0, obj).Value ) },
221 { M(() => new DateTime(0, 0, 0) ), L<I,I,I,D>((y,m,d) => Sql.MakeDateTime(y, m, d).Value ) },
222
223 { M(() => Sql.MakeDateTime(0, 0, 0) ), L<I?,I?,I?,D?> ((y,m,d) => Sql.Convert(Sql.Date, y.ToString() + "-" + m.ToString() + "-" + d.ToString())) },
224 { M(() => new DateTime (0, 0, 0, 0, 0, 0) ), L<I,I,I,I,I,I,D> ((y,m,d,h,mm,s) => Sql.MakeDateTime(y, m, d, h, mm, s).Value ) },
225 { M(() => Sql.MakeDateTime(0, 0, 0, 0, 0, 0) ), L<I?,I?,I?,I?,I?,I?,D?>((y,m,d,h,mm,s) => Sql.Convert(Sql.DateTime2,
226 y.ToString() + "-" + m.ToString() + "-" + d.ToString() + " " +
227 h.ToString() + ":" + mm.ToString() + ":" + s.ToString())) },
228
229 #endregion
230
231 #region Parse
232
233 { M(() => Boolean. Parse("")), L<String,Boolean> (p0 => Sql.ConvertTo<Boolean>. From(p0) ) },
234 { M(() => Byte. Parse("")), L<String,Byte> (p0 => Sql.ConvertTo<Byte>. From(p0) ) },
235 #if !SILVERLIGHT
236 { M(() => Char. Parse("")), L<String,Char> (p0 => Sql.ConvertTo<Char>. From(p0) ) },
237 #endif
238 { M(() => DateTime.Parse("")), L<String,DateTime>(p0 => Sql.ConvertTo<DateTime>.From(p0) ) },
239 { M(() => Decimal. Parse("")), L<String,Decimal> (p0 => Sql.ConvertTo<Decimal>. From(p0) ) },
240 { M(() => Double. Parse("")), L<String,Double> (p0 => Sql.ConvertTo<Double>. From(p0) ) },
241 { M(() => Int16. Parse("")), L<String,Int16> (p0 => Sql.ConvertTo<Int16>. From(p0) ) },
242 { M(() => Int32. Parse("")), L<String,Int32> (p0 => Sql.ConvertTo<Int32>. From(p0) ) },
243 { M(() => Int64. Parse("")), L<String,Int64> (p0 => Sql.ConvertTo<Int64>. From(p0) ) },
244 { M(() => SByte. Parse("")), L<String,SByte> (p0 => Sql.ConvertTo<SByte>. From(p0) ) },
245 { M(() => Single. Parse("")), L<String,Single> (p0 => Sql.ConvertTo<Single>. From(p0) ) },
246 { M(() => UInt16. Parse("")), L<String,UInt16> (p0 => Sql.ConvertTo<UInt16>. From(p0) ) },
247 { M(() => UInt32. Parse("")), L<String,UInt32> (p0 => Sql.ConvertTo<UInt32>. From(p0) ) },
248 { M(() => UInt64. Parse("")), L<String,UInt64> (p0 => Sql.ConvertTo<UInt64>. From(p0) ) },
249
250 #endregion
251
252 #region ToString
253
254 { M(() => ((Boolean)true).ToString()), L<Boolean, String>(p0 => Sql.ConvertTo<string>.From(p0) ) },
255 { M(() => ((Byte) 0) .ToString()), L<Byte, String>(p0 => Sql.ConvertTo<string>.From(p0) ) },
256 { M(() => ((Char) '0') .ToString()), L<Char, String>(p0 => Sql.ConvertTo<string>.From(p0) ) },
257 { M(() => ((Decimal) 0) .ToString()), L<Decimal, String>(p0 => Sql.ConvertTo<string>.From(p0) ) },
258 { M(() => ((Double) 0) .ToString()), L<Double, String>(p0 => Sql.ConvertTo<string>.From(p0) ) },
259 { M(() => ((Int16) 0) .ToString()), L<Int16, String>(p0 => Sql.ConvertTo<string>.From(p0) ) },
260 { M(() => ((Int32) 0) .ToString()), L<Int32, String>(p0 => Sql.ConvertTo<string>.From(p0) ) },
261 { M(() => ((Int64) 0) .ToString()), L<Int64, String>(p0 => Sql.ConvertTo<string>.From(p0) ) },
262 { M(() => ((SByte) 0) .ToString()), L<SByte, String>(p0 => Sql.ConvertTo<string>.From(p0) ) },
263 { M(() => ((Single) 0) .ToString()), L<Single, String>(p0 => Sql.ConvertTo<string>.From(p0) ) },
264 { M(() => ((String) "0") .ToString()), L<String, String>(p0 => p0 ) },
265 { M(() => ((UInt16) 0) .ToString()), L<UInt16, String>(p0 => Sql.ConvertTo<string>.From(p0) ) },
266 { M(() => ((UInt32) 0) .ToString()), L<UInt32, String>(p0 => Sql.ConvertTo<string>.From(p0) ) },
267 { M(() => ((UInt64) 0) .ToString()), L<UInt64, String>(p0 => Sql.ConvertTo<string>.From(p0) ) },
268
269 #endregion
270
271 #region Convert
272
273 #region ToBoolean
274
275 { M(() => Convert.ToBoolean((Boolean)true)), L<Boolean, Boolean>(p0 => Sql.ConvertTo<Boolean>.From(p0) ) },
276 { M(() => Convert.ToBoolean((Byte) 0) ), L<Byte, Boolean>(p0 => Sql.ConvertTo<Boolean>.From(p0) ) },
277 { M(() => Convert.ToBoolean((Char) '0') ), L<Char, Boolean>(p0 => Sql.ConvertTo<Boolean>.From(p0) ) },
278 #if !SILVERLIGHT
279 { M(() => Convert.ToBoolean(DateTime.Now) ), L<DateTime,Boolean>(p0 => Sql.ConvertTo<Boolean>.From(p0) ) },
280 #endif
281 { M(() => Convert.ToBoolean((Decimal) 0) ), L<Decimal, Boolean>(p0 => Sql.ConvertTo<Boolean>.From(p0) ) },
282 { M(() => Convert.ToBoolean((Double) 0) ), L<Double, Boolean>(p0 => Sql.ConvertTo<Boolean>.From(p0) ) },
283 { M(() => Convert.ToBoolean((Int16) 0) ), L<Int16, Boolean>(p0 => Sql.ConvertTo<Boolean>.From(p0) ) },
284 { M(() => Convert.ToBoolean((Int32) 0) ), L<Int32, Boolean>(p0 => Sql.ConvertTo<Boolean>.From(p0) ) },
285 { M(() => Convert.ToBoolean((Int64) 0) ), L<Int64, Boolean>(p0 => Sql.ConvertTo<Boolean>.From(p0) ) },
286 { M(() => Convert.ToBoolean((Object) 0) ), L<Object, Boolean>(p0 => Sql.ConvertTo<Boolean>.From(p0) ) },
287 { M(() => Convert.ToBoolean((SByte) 0) ), L<SByte, Boolean>(p0 => Sql.ConvertTo<Boolean>.From(p0) ) },
288 { M(() => Convert.ToBoolean((Single) 0) ), L<Single, Boolean>(p0 => Sql.ConvertTo<Boolean>.From(p0) ) },
289 { M(() => Convert.ToBoolean((String) "0") ), L<String, Boolean>(p0 => Sql.ConvertTo<Boolean>.From(p0) ) },
290 { M(() => Convert.ToBoolean((UInt16) 0) ), L<UInt16, Boolean>(p0 => Sql.ConvertTo<Boolean>.From(p0) ) },
291 { M(() => Convert.ToBoolean((UInt32) 0) ), L<UInt32, Boolean>(p0 => Sql.ConvertTo<Boolean>.From(p0) ) },
292 { M(() => Convert.ToBoolean((UInt64) 0) ), L<UInt64, Boolean>(p0 => Sql.ConvertTo<Boolean>.From(p0) ) },
293
294 #endregion
295
296 #region ToByte
297
298 { M(() => Convert.ToByte((Boolean)true)), L<Boolean, Byte>(p0 => Sql.ConvertTo<Byte>.From(p0) ) },
299 { M(() => Convert.ToByte((Byte) 0) ), L<Byte, Byte>(p0 => Sql.ConvertTo<Byte>.From(p0) ) },
300 { M(() => Convert.ToByte((Char) '0') ), L<Char, Byte>(p0 => Sql.ConvertTo<Byte>.From(p0) ) },
301 #if !SILVERLIGHT
302 { M(() => Convert.ToByte(DateTime.Now) ), L<DateTime,Byte>(p0 => Sql.ConvertTo<Byte>.From(p0) ) },
303 #endif
304 { M(() => Convert.ToByte((Decimal) 0) ), L<Decimal, Byte>(p0 => Sql.ConvertTo<Byte>.From(Sql.RoundToEven(p0)) ) },
305 { M(() => Convert.ToByte((Double) 0) ), L<Double, Byte>(p0 => Sql.ConvertTo<Byte>.From(Sql.RoundToEven(p0)) ) },
306 { M(() => Convert.ToByte((Int16) 0) ), L<Int16, Byte>(p0 => Sql.ConvertTo<Byte>.From(p0) ) },
307 { M(() => Convert.ToByte((Int32) 0) ), L<Int32, Byte>(p0 => Sql.ConvertTo<Byte>.From(p0) ) },
308 { M(() => Convert.ToByte((Int64) 0) ), L<Int64, Byte>(p0 => Sql.ConvertTo<Byte>.From(p0) ) },
309 { M(() => Convert.ToByte((Object) 0) ), L<Object, Byte>(p0 => Sql.ConvertTo<Byte>.From(p0) ) },
310 { M(() => Convert.ToByte((SByte) 0) ), L<SByte, Byte>(p0 => Sql.ConvertTo<Byte>.From(p0) ) },
311 { M(() => Convert.ToByte((Single) 0) ), L<Single, Byte>(p0 => Sql.ConvertTo<Byte>.From(Sql.RoundToEven(p0)) ) },
312 { M(() => Convert.ToByte((String) "0") ), L<String, Byte>(p0 => Sql.ConvertTo<Byte>.From(p0) ) },
313 { M(() => Convert.ToByte((UInt16) 0) ), L<UInt16, Byte>(p0 => Sql.ConvertTo<Byte>.From(p0) ) },
314 { M(() => Convert.ToByte((UInt32) 0) ), L<UInt32, Byte>(p0 => Sql.ConvertTo<Byte>.From(p0) ) },
315 { M(() => Convert.ToByte((UInt64) 0) ), L<UInt64, Byte>(p0 => Sql.ConvertTo<Byte>.From(p0) ) },
316
317 #endregion
318
319 #region ToChar
320
321 #if !SILVERLIGHT
322 { M(() => Convert.ToChar((Boolean)true)), L<Boolean, Char>(p0 => Sql.ConvertTo<Char>.From(p0) ) },
323 #endif
324 { M(() => Convert.ToChar((Byte) 0) ), L<Byte, Char>(p0 => Sql.ConvertTo<Char>.From(p0) ) },
325 { M(() => Convert.ToChar((Char) '0') ), L<Char, Char>(p0 => p0 ) },
326 #if !SILVERLIGHT
327 { M(() => Convert.ToChar(DateTime.Now) ), L<DateTime,Char>(p0 => Sql.ConvertTo<Char>.From(p0) ) },
328 #endif
329 { M(() => Convert.ToChar((Decimal) 0) ), L<Decimal, Char>(p0 => Sql.ConvertTo<Char>.From(Sql.RoundToEven(p0)) ) },
330 { M(() => Convert.ToChar((Double) 0) ), L<Double, Char>(p0 => Sql.ConvertTo<Char>.From(Sql.RoundToEven(p0)) ) },
331 { M(() => Convert.ToChar((Int16) 0) ), L<Int16, Char>(p0 => Sql.ConvertTo<Char>.From(p0) ) },
332 { M(() => Convert.ToChar((Int32) 0) ), L<Int32, Char>(p0 => Sql.ConvertTo<Char>.From(p0) ) },
333 { M(() => Convert.ToChar((Int64) 0) ), L<Int64, Char>(p0 => Sql.ConvertTo<Char>.From(p0) ) },
334 { M(() => Convert.ToChar((Object) 0) ), L<Object, Char>(p0 => Sql.ConvertTo<Char>.From(p0) ) },
335 { M(() => Convert.ToChar((SByte) 0) ), L<SByte, Char>(p0 => Sql.ConvertTo<Char>.From(p0) ) },
336 { M(() => Convert.ToChar((Single) 0) ), L<Single, Char>(p0 => Sql.ConvertTo<Char>.From(Sql.RoundToEven(p0)) ) },
337 { M(() => Convert.ToChar((String) "0") ), L<String, Char>(p0 => Sql.ConvertTo<Char>.From(p0) ) },
338 { M(() => Convert.ToChar((UInt16) 0) ), L<UInt16, Char>(p0 => Sql.ConvertTo<Char>.From(p0) ) },
339 { M(() => Convert.ToChar((UInt32) 0) ), L<UInt32, Char>(p0 => Sql.ConvertTo<Char>.From(p0) ) },
340 { M(() => Convert.ToChar((UInt64) 0) ), L<UInt64, Char>(p0 => Sql.ConvertTo<Char>.From(p0) ) },
341
342 #endregion
343
344 #region ToDateTime
345
346 { M(() => Convert.ToDateTime((Object) 0) ), L<Object, DateTime>(p0 => Sql.ConvertTo<DateTime>.From(p0) ) },
347 { M(() => Convert.ToDateTime((String) "0") ), L<String, DateTime>(p0 => Sql.ConvertTo<DateTime>.From(p0) ) },
348 #if !SILVERLIGHT
349 { M(() => Convert.ToDateTime((Boolean)true)), L<Boolean, DateTime>(p0 => Sql.ConvertTo<DateTime>.From(p0) ) },
350 { M(() => Convert.ToDateTime((Byte) 0) ), L<Byte, DateTime>(p0 => Sql.ConvertTo<DateTime>.From(p0) ) },
351 { M(() => Convert.ToDateTime((Char) '0') ), L<Char, DateTime>(p0 => Sql.ConvertTo<DateTime>.From(p0) ) },
352 { M(() => Convert.ToDateTime(DateTime.Now) ), L<DateTime,DateTime>(p0 => p0 ) },
353 { M(() => Convert.ToDateTime((Decimal) 0) ), L<Decimal, DateTime>(p0 => Sql.ConvertTo<DateTime>.From(p0) ) },
354 { M(() => Convert.ToDateTime((Double) 0) ), L<Double, DateTime>(p0 => Sql.ConvertTo<DateTime>.From(p0) ) },
355 { M(() => Convert.ToDateTime((Int16) 0) ), L<Int16, DateTime>(p0 => Sql.ConvertTo<DateTime>.From(p0) ) },
356 { M(() => Convert.ToDateTime((Int32) 0) ), L<Int32, DateTime>(p0 => Sql.ConvertTo<DateTime>.From(p0) ) },
357 { M(() => Convert.ToDateTime((Int64) 0) ), L<Int64, DateTime>(p0 => Sql.ConvertTo<DateTime>.From(p0) ) },
358 { M(() => Convert.ToDateTime((SByte) 0) ), L<SByte, DateTime>(p0 => Sql.ConvertTo<DateTime>.From(p0) ) },
359 { M(() => Convert.ToDateTime((Single) 0) ), L<Single, DateTime>(p0 => Sql.ConvertTo<DateTime>.From(p0) ) },
360 { M(() => Convert.ToDateTime((UInt16) 0) ), L<UInt16, DateTime>(p0 => Sql.ConvertTo<DateTime>.From(p0) ) },
361 { M(() => Convert.ToDateTime((UInt32) 0) ), L<UInt32, DateTime>(p0 => Sql.ConvertTo<DateTime>.From(p0) ) },
362 { M(() => Convert.ToDateTime((UInt64) 0) ), L<UInt64, DateTime>(p0 => Sql.ConvertTo<DateTime>.From(p0) ) },
363 #endif
364
365 #endregion
366
367 #region ToDecimal
368
369 { M(() => Convert.ToDecimal((Boolean)true)), L<Boolean, Decimal>(p0 => Sql.ConvertTo<Decimal>.From(p0) ) },
370 { M(() => Convert.ToDecimal((Byte) 0) ), L<Byte, Decimal>(p0 => Sql.ConvertTo<Decimal>.From(p0) ) },
371 { M(() => Convert.ToDecimal((Char) '0') ), L<Char, Decimal>(p0 => Sql.ConvertTo<Decimal>.From(p0) ) },
372 { M(() => Convert.ToDecimal(DateTime.Now) ), L<DateTime,Decimal>(p0 => Sql.ConvertTo<Decimal>.From(p0) ) },
373 { M(() => Convert.ToDecimal((Decimal) 0) ), L<Decimal, Decimal>(p0 => Sql.ConvertTo<Decimal>.From(p0) ) },
374 { M(() => Convert.ToDecimal((Double) 0) ), L<Double, Decimal>(p0 => Sql.ConvertTo<Decimal>.From(p0) ) },
375 { M(() => Convert.ToDecimal((Int16) 0) ), L<Int16, Decimal>(p0 => Sql.ConvertTo<Decimal>.From(p0) ) },
376 { M(() => Convert.ToDecimal((Int32) 0) ), L<Int32, Decimal>(p0 => Sql.ConvertTo<Decimal>.From(p0) ) },
377 { M(() => Convert.ToDecimal((Int64) 0) ), L<Int64, Decimal>(p0 => Sql.ConvertTo<Decimal>.From(p0) ) },
378 { M(() => Convert.ToDecimal((Object) 0) ), L<Object, Decimal>(p0 => Sql.ConvertTo<Decimal>.From(p0) ) },
379 { M(() => Convert.ToDecimal((SByte) 0) ), L<SByte, Decimal>(p0 => Sql.ConvertTo<Decimal>.From(p0) ) },
380 { M(() => Convert.ToDecimal((Single) 0) ), L<Single, Decimal>(p0 => Sql.ConvertTo<Decimal>.From(p0) ) },
381 { M(() => Convert.ToDecimal((String) "0") ), L<String, Decimal>(p0 => Sql.ConvertTo<Decimal>.From(p0) ) },
382 { M(() => Convert.ToDecimal((UInt16) 0) ), L<UInt16, Decimal>(p0 => Sql.ConvertTo<Decimal>.From(p0) ) },
383 { M(() => Convert.ToDecimal((UInt32) 0) ), L<UInt32, Decimal>(p0 => Sql.ConvertTo<Decimal>.From(p0) ) },
384 { M(() => Convert.ToDecimal((UInt64) 0) ), L<UInt64, Decimal>(p0 => Sql.ConvertTo<Decimal>.From(p0) ) },
385
386 #endregion
387
388 #region ToDouble
389
390 { M(() => Convert.ToDouble((Boolean)true)), L<Boolean, Double>(p0 => Sql.ConvertTo<Double>.From(p0) ) },
391 { M(() => Convert.ToDouble((Byte) 0) ), L<Byte, Double>(p0 => Sql.ConvertTo<Double>.From(p0) ) },
392 { M(() => Convert.ToDouble((Char) '0') ), L<Char, Double>(p0 => Sql.ConvertTo<Double>.From(p0) ) },
393 #if !SILVERLIGHT
394 { M(() => Convert.ToDouble(DateTime.Now) ), L<DateTime,Double>(p0 => Sql.ConvertTo<Double>.From(p0) ) },
395 #endif
396 { M(() => Convert.ToDouble((Decimal) 0) ), L<Decimal, Double>(p0 => Sql.ConvertTo<Double>.From(p0) ) },
397 { M(() => Convert.ToDouble((Double) 0) ), L<Double, Double>(p0 => Sql.ConvertTo<Double>.From(p0) ) },
398 { M(() => Convert.ToDouble((Int16) 0) ), L<Int16, Double>(p0 => Sql.ConvertTo<Double>.From(p0) ) },
399 { M(() => Convert.ToDouble((Int32) 0) ), L<Int32, Double>(p0 => Sql.ConvertTo<Double>.From(p0) ) },
400 { M(() => Convert.ToDouble((Int64) 0) ), L<Int64, Double>(p0 => Sql.ConvertTo<Double>.From(p0) ) },
401 { M(() => Convert.ToDouble((Object) 0) ), L<Object, Double>(p0 => Sql.ConvertTo<Double>.From(p0) ) },
402 { M(() => Convert.ToDouble((SByte) 0) ), L<SByte, Double>(p0 => Sql.ConvertTo<Double>.From(p0) ) },
403 { M(() => Convert.ToDouble((Single) 0) ), L<Single, Double>(p0 => Sql.ConvertTo<Double>.From(p0) ) },
404 { M(() => Convert.ToDouble((String) "0") ), L<String, Double>(p0 => Sql.ConvertTo<Double>.From(p0) ) },
405 { M(() => Convert.ToDouble((UInt16) 0) ), L<UInt16, Double>(p0 => Sql.ConvertTo<Double>.From(p0) ) },
406 { M(() => Convert.ToDouble((UInt32) 0) ), L<UInt32, Double>(p0 => Sql.ConvertTo<Double>.From(p0) ) },
407 { M(() => Convert.ToDouble((UInt64) 0) ), L<UInt64, Double>(p0 => Sql.ConvertTo<Double>.From(p0) ) },
408
409 #endregion
410
411 #region ToInt64
412
413 { M(() => Convert.ToInt64((Boolean)true)), L<Boolean, Int64>(p0 => Sql.ConvertTo<Int64>.From(p0) ) },
414 { M(() => Convert.ToInt64((Byte) 0) ), L<Byte, Int64>(p0 => Sql.ConvertTo<Int64>.From(p0) ) },
415 { M(() => Convert.ToInt64((Char) '0') ), L<Char, Int64>(p0 => Sql.ConvertTo<Int64>.From(p0) ) },
416 #if !SILVERLIGHT
417 { M(() => Convert.ToInt64(DateTime.Now) ), L<DateTime,Int64>(p0 => Sql.ConvertTo<Int64>.From(p0) ) },
418 #endif
419 { M(() => Convert.ToInt64((Decimal) 0) ), L<Decimal, Int64>(p0 => Sql.ConvertTo<Int64>.From(Sql.RoundToEven(p0)) ) },
420 { M(() => Convert.ToInt64((Double) 0) ), L<Double, Int64>(p0 => Sql.ConvertTo<Int64>.From(Sql.RoundToEven(p0)) ) },
421 { M(() => Convert.ToInt64((Int16) 0) ), L<Int16, Int64>(p0 => Sql.ConvertTo<Int64>.From(p0) ) },
422 { M(() => Convert.ToInt64((Int32) 0) ), L<Int32, Int64>(p0 => Sql.ConvertTo<Int64>.From(p0) ) },
423 { M(() => Convert.ToInt64((Int64) 0) ), L<Int64, Int64>(p0 => Sql.ConvertTo<Int64>.From(p0) ) },
424 { M(() => Convert.ToInt64((Object) 0) ), L<Object, Int64>(p0 => Sql.ConvertTo<Int64>.From(p0) ) },
425 { M(() => Convert.ToInt64((SByte) 0) ), L<SByte, Int64>(p0 => Sql.ConvertTo<Int64>.From(p0) ) },
426 { M(() => Convert.ToInt64((Single) 0) ), L<Single, Int64>(p0 => Sql.ConvertTo<Int64>.From(Sql.RoundToEven(p0)) ) },
427 { M(() => Convert.ToInt64((String) "0") ), L<String, Int64>(p0 => Sql.ConvertTo<Int64>.From(p0) ) },
428 { M(() => Convert.ToInt64((UInt16) 0) ), L<UInt16, Int64>(p0 => Sql.ConvertTo<Int64>.From(p0) ) },
429 { M(() => Convert.ToInt64((UInt32) 0) ), L<UInt32, Int64>(p0 => Sql.ConvertTo<Int64>.From(p0) ) },
430 { M(() => Convert.ToInt64((UInt64) 0) ), L<UInt64, Int64>(p0 => Sql.ConvertTo<Int64>.From(p0) ) },
431
432 #endregion
433
434 #region ToInt32
435
436 { M(() => Convert.ToInt32((Boolean)true)), L<Boolean, Int32>(p0 => Sql.ConvertTo<Int32>.From(p0) ) },
437 { M(() => Convert.ToInt32((Byte) 0) ), L<Byte, Int32>(p0 => Sql.ConvertTo<Int32>.From(p0) ) },
438 { M(() => Convert.ToInt32((Char) '0') ), L<Char, Int32>(p0 => Sql.ConvertTo<Int32>.From(p0) ) },
439 #if !SILVERLIGHT
440 { M(() => Convert.ToInt32(DateTime.Now) ), L<DateTime,Int32>(p0 => Sql.ConvertTo<Int32>.From(p0) ) },
441 #endif
442 { M(() => Convert.ToInt32((Decimal) 0) ), L<Decimal, Int32>(p0 => Sql.ConvertTo<Int32>.From(Sql.RoundToEven(p0)) ) },
443 { M(() => Convert.ToInt32((Double) 0) ), L<Double, Int32>(p0 => Sql.ConvertTo<Int32>.From(Sql.RoundToEven(p0)) ) },
444 { M(() => Convert.ToInt32((Int16) 0) ), L<Int16, Int32>(p0 => Sql.ConvertTo<Int32>.From(p0) ) },
445 { M(() => Convert.ToInt32((Int32) 0) ), L<Int32, Int32>(p0 => Sql.ConvertTo<Int32>.From(p0) ) },
446 { M(() => Convert.ToInt32((Int64) 0) ), L<Int64, Int32>(p0 => Sql.ConvertTo<Int32>.From(p0) ) },
447 { M(() => Convert.ToInt32((Object) 0) ), L<Object, Int32>(p0 => Sql.ConvertTo<Int32>.From(p0) ) },
448 { M(() => Convert.ToInt32((SByte) 0) ), L<SByte, Int32>(p0 => Sql.ConvertTo<Int32>.From(p0) ) },
449 { M(() => Convert.ToInt32((Single) 0) ), L<Single, Int32>(p0 => Sql.ConvertTo<Int32>.From(Sql.RoundToEven(p0)) ) },
450 { M(() => Convert.ToInt32((String) "0") ), L<String, Int32>(p0 => Sql.ConvertTo<Int32>.From(p0) ) },
451 { M(() => Convert.ToInt32((UInt16) 0) ), L<UInt16, Int32>(p0 => Sql.ConvertTo<Int32>.From(p0) ) },
452 { M(() => Convert.ToInt32((UInt32) 0) ), L<UInt32, Int32>(p0 => Sql.ConvertTo<Int32>.From(p0) ) },
453 { M(() => Convert.ToInt32((UInt64) 0) ), L<UInt64, Int32>(p0 => Sql.ConvertTo<Int32>.From(p0) ) },
454
455 #endregion
456
457 #region ToInt16
458
459 { M(() => Convert.ToInt16((Boolean)true)), L<Boolean, Int16>(p0 => Sql.ConvertTo<Int16>.From(p0) ) },
460 { M(() => Convert.ToInt16((Byte) 0) ), L<Byte, Int16>(p0 => Sql.ConvertTo<Int16>.From(p0) ) },
461 { M(() => Convert.ToInt16((Char) '0') ), L<Char, Int16>(p0 => Sql.ConvertTo<Int16>.From(p0) ) },
462 #if !SILVERLIGHT
463 { M(() => Convert.ToInt16(DateTime.Now) ), L<DateTime,Int16>(p0 => Sql.ConvertTo<Int16>.From(p0) ) },
464 #endif
465 { M(() => Convert.ToInt16((Decimal) 0) ), L<Decimal, Int16>(p0 => Sql.ConvertTo<Int16>.From(Sql.RoundToEven(p0)) ) },
466 { M(() => Convert.ToInt16((Double) 0) ), L<Double, Int16>(p0 => Sql.ConvertTo<Int16>.From(Sql.RoundToEven(p0)) ) },
467 { M(() => Convert.ToInt16((Int16) 0) ), L<Int16, Int16>(p0 => Sql.ConvertTo<Int16>.From(p0) ) },
468 { M(() => Convert.ToInt16((Int32) 0) ), L<Int32, Int16>(p0 => Sql.ConvertTo<Int16>.From(p0) ) },
469 { M(() => Convert.ToInt16((Int64) 0) ), L<Int64, Int16>(p0 => Sql.ConvertTo<Int16>.From(p0) ) },
470 { M(() => Convert.ToInt16((Object) 0) ), L<Object, Int16>(p0 => Sql.ConvertTo<Int16>.From(p0) ) },
471 { M(() => Convert.ToInt16((SByte) 0) ), L<SByte, Int16>(p0 => Sql.ConvertTo<Int16>.From(p0) ) },
472 { M(() => Convert.ToInt16((Single) 0) ), L<Single, Int16>(p0 => Sql.ConvertTo<Int16>.From(Sql.RoundToEven(p0)) ) },
473 { M(() => Convert.ToInt16((String) "0") ), L<String, Int16>(p0 => Sql.ConvertTo<Int16>.From(p0) ) },
474 { M(() => Convert.ToInt16((UInt16) 0) ), L<UInt16, Int16>(p0 => Sql.ConvertTo<Int16>.From(p0) ) },
475 { M(() => Convert.ToInt16((UInt32) 0) ), L<UInt32, Int16>(p0 => Sql.ConvertTo<Int16>.From(p0) ) },
476 { M(() => Convert.ToInt16((UInt64) 0) ), L<UInt64, Int16>(p0 => Sql.ConvertTo<Int16>.From(p0) ) },
477
478 #endregion
479
480 #region ToSByte
481
482 { M(() => Convert.ToSByte((Boolean)true)), L<Boolean, SByte>(p0 => Sql.ConvertTo<SByte>.From(p0) ) },
483 { M(() => Convert.ToSByte((Byte) 0) ), L<Byte, SByte>(p0 => Sql.ConvertTo<SByte>.From(p0) ) },
484 { M(() => Convert.ToSByte((Char) '0') ), L<Char, SByte>(p0 => Sql.ConvertTo<SByte>.From(p0) ) },
485 #if !SILVERLIGHT
486 { M(() => Convert.ToSByte(DateTime.Now) ), L<DateTime,SByte>(p0 => Sql.ConvertTo<SByte>.From(p0) ) },
487 #endif
488 { M(() => Convert.ToSByte((Decimal) 0) ), L<Decimal, SByte>(p0 => Sql.ConvertTo<SByte>.From(Sql.RoundToEven(p0)) ) },
489 { M(() => Convert.ToSByte((Double) 0) ), L<Double, SByte>(p0 => Sql.ConvertTo<SByte>.From(Sql.RoundToEven(p0)) ) },
490 { M(() => Convert.ToSByte((Int16) 0) ), L<Int16, SByte>(p0 => Sql.ConvertTo<SByte>.From(p0) ) },
491 { M(() => Convert.ToSByte((Int32) 0) ), L<Int32, SByte>(p0 => Sql.ConvertTo<SByte>.From(p0) ) },
492 { M(() => Convert.ToSByte((Int64) 0) ), L<Int64, SByte>(p0 => Sql.ConvertTo<SByte>.From(p0) ) },
493 { M(() => Convert.ToSByte((Object) 0) ), L<Object, SByte>(p0 => Sql.ConvertTo<SByte>.From(p0) ) },
494 { M(() => Convert.ToSByte((SByte) 0) ), L<SByte, SByte>(p0 => Sql.ConvertTo<SByte>.From(p0) ) },
495 { M(() => Convert.ToSByte((Single) 0) ), L<Single, SByte>(p0 => Sql.ConvertTo<SByte>.From(Sql.RoundToEven(p0)) ) },
496 { M(() => Convert.ToSByte((String) "0") ), L<String, SByte>(p0 => Sql.ConvertTo<SByte>.From(p0) ) },
497 { M(() => Convert.ToSByte((UInt16) 0) ), L<UInt16, SByte>(p0 => Sql.ConvertTo<SByte>.From(p0) ) },
498 { M(() => Convert.ToSByte((UInt32) 0) ), L<UInt32, SByte>(p0 => Sql.ConvertTo<SByte>.From(p0) ) },
499 { M(() => Convert.ToSByte((UInt64) 0) ), L<UInt64, SByte>(p0 => Sql.ConvertTo<SByte>.From(p0) ) },
500
501 #endregion
502
503 #region ToSingle
504
505 { M(() => Convert.ToSingle((Boolean)true)), L<Boolean, Single>(p0 => Sql.ConvertTo<Single>.From(p0) ) },
506 { M(() => Convert.ToSingle((Byte) 0) ), L<Byte, Single>(p0 => Sql.ConvertTo<Single>.From(p0) ) },
507 { M(() => Convert.ToSingle((Char) '0') ), L<Char, Single>(p0 => Sql.ConvertTo<Single>.From(p0) ) },
508 #if !SILVERLIGHT
509 { M(() => Convert.ToSingle(DateTime.Now) ), L<DateTime,Single>(p0 => Sql.ConvertTo<Single>.From(p0) ) },
510 #endif
511 { M(() => Convert.ToSingle((Decimal) 0) ), L<Decimal, Single>(p0 => Sql.ConvertTo<Single>.From(p0) ) },
512 { M(() => Convert.ToSingle((Double) 0) ), L<Double, Single>(p0 => Sql.ConvertTo<Single>.From(p0) ) },
513 { M(() => Convert.ToSingle((Int16) 0) ), L<Int16, Single>(p0 => Sql.ConvertTo<Single>.From(p0) ) },
514 { M(() => Convert.ToSingle((Int32) 0) ), L<Int32, Single>(p0 => Sql.ConvertTo<Single>.From(p0) ) },
515 { M(() => Convert.ToSingle((Int64) 0) ), L<Int64, Single>(p0 => Sql.ConvertTo<Single>.From(p0) ) },
516 { M(() => Convert.ToSingle((Object) 0) ), L<Object, Single>(p0 => Sql.ConvertTo<Single>.From(p0) ) },
517 { M(() => Convert.ToSingle((SByte) 0) ), L<SByte, Single>(p0 => Sql.ConvertTo<Single>.From(p0) ) },
518 { M(() => Convert.ToSingle((Single) 0) ), L<Single, Single>(p0 => Sql.ConvertTo<Single>.From(p0) ) },
519 { M(() => Convert.ToSingle((String) "0") ), L<String, Single>(p0 => Sql.ConvertTo<Single>.From(p0) ) },
520 { M(() => Convert.ToSingle((UInt16) 0) ), L<UInt16, Single>(p0 => Sql.ConvertTo<Single>.From(p0) ) },
521 { M(() => Convert.ToSingle((UInt32) 0) ), L<UInt32, Single>(p0 => Sql.ConvertTo<Single>.From(p0) ) },
522 { M(() => Convert.ToSingle((UInt64) 0) ), L<UInt64, Single>(p0 => Sql.ConvertTo<Single>.From(p0) ) },
523
524 #endregion
525
526 #region ToString
527
528 { M(() => Convert.ToString((Boolean)true)), L<Boolean, String>(p0 => Sql.ConvertTo<String>.From(p0) ) },
529 { M(() => Convert.ToString((Byte) 0) ), L<Byte, String>(p0 => Sql.ConvertTo<String>.From(p0) ) },
530 { M(() => Convert.ToString((Char) '0') ), L<Char, String>(p0 => Sql.ConvertTo<String>.From(p0) ) },
531 { M(() => Convert.ToString(DateTime.Now) ), L<DateTime,String>(p0 => Sql.ConvertTo<String>.From(p0) ) },
532 { M(() => Convert.ToString((Decimal) 0) ), L<Decimal, String>(p0 => Sql.ConvertTo<String>.From(p0) ) },
533 { M(() => Convert.ToString((Double) 0) ), L<Double, String>(p0 => Sql.ConvertTo<String>.From(p0) ) },
534 { M(() => Convert.ToString((Int16) 0) ), L<Int16, String>(p0 => Sql.ConvertTo<String>.From(p0) ) },
535 { M(() => Convert.ToString((Int32) 0) ), L<Int32, String>(p0 => Sql.ConvertTo<String>.From(p0) ) },
536 { M(() => Convert.ToString((Int64) 0) ), L<Int64, String>(p0 => Sql.ConvertTo<String>.From(p0) ) },
537 { M(() => Convert.ToString((Object) 0) ), L<Object, String>(p0 => Sql.ConvertTo<String>.From(p0) ) },
538 { M(() => Convert.ToString((SByte) 0) ), L<SByte, String>(p0 => Sql.ConvertTo<String>.From(p0) ) },
539 { M(() => Convert.ToString((Single) 0) ), L<Single, String>(p0 => Sql.ConvertTo<String>.From(p0) ) },
540 #if !SILVERLIGHT
541 { M(() => Convert.ToString((String) "0") ), L<String, String>(p0 => p0 ) },
542 #endif
543 { M(() => Convert.ToString((UInt16) 0) ), L<UInt16, String>(p0 => Sql.ConvertTo<String>.From(p0) ) },
544 { M(() => Convert.ToString((UInt32) 0) ), L<UInt32, String>(p0 => Sql.ConvertTo<String>.From(p0) ) },
545 { M(() => Convert.ToString((UInt64) 0) ), L<UInt64, String>(p0 => Sql.ConvertTo<String>.From(p0) ) },
546
547 #endregion
548
549 #region ToInt16
550
551 { M(() => Convert.ToUInt16((Boolean)true)), L<Boolean, UInt16>(p0 => Sql.ConvertTo<UInt16>.From(p0) ) },
552 { M(() => Convert.ToUInt16((Byte) 0) ), L<Byte, UInt16>(p0 => Sql.ConvertTo<UInt16>.From(p0) ) },
553 { M(() => Convert.ToUInt16((Char) '0') ), L<Char, UInt16>(p0 => Sql.ConvertTo<UInt16>.From(p0) ) },
554 #if !SILVERLIGHT
555 { M(() => Convert.ToUInt16(DateTime.Now) ), L<DateTime,UInt16>(p0 => Sql.ConvertTo<UInt16>.From(p0) ) },
556 #endif
557 { M(() => Convert.ToUInt16((Decimal) 0) ), L<Decimal, UInt16>(p0 => Sql.ConvertTo<UInt16>.From(Sql.RoundToEven(p0)) ) },
558 { M(() => Convert.ToUInt16((Double) 0) ), L<Double, UInt16>(p0 => Sql.ConvertTo<UInt16>.From(Sql.RoundToEven(p0)) ) },
559 { M(() => Convert.ToUInt16((Int16) 0) ), L<Int16, UInt16>(p0 => Sql.ConvertTo<UInt16>.From(p0) ) },
560 { M(() => Convert.ToUInt16((Int32) 0) ), L<Int32, UInt16>(p0 => Sql.ConvertTo<UInt16>.From(p0) ) },
561 { M(() => Convert.ToUInt16((Int64) 0) ), L<Int64, UInt16>(p0 => Sql.ConvertTo<UInt16>.From(p0) ) },
562 { M(() => Convert.ToUInt16((Object) 0) ), L<Object, UInt16>(p0 => Sql.ConvertTo<UInt16>.From(p0) ) },
563 { M(() => Convert.ToUInt16((SByte) 0) ), L<SByte, UInt16>(p0 => Sql.ConvertTo<UInt16>.From(p0) ) },
564 { M(() => Convert.ToUInt16((Single) 0) ), L<Single, UInt16>(p0 => Sql.ConvertTo<UInt16>.From(Sql.RoundToEven(p0)) ) },
565 { M(() => Convert.ToUInt16((String) "0") ), L<String, UInt16>(p0 => Sql.ConvertTo<UInt16>.From(p0) ) },
566 { M(() => Convert.ToUInt16((UInt16) 0) ), L<UInt16, UInt16>(p0 => Sql.ConvertTo<UInt16>.From(p0) ) },
567 { M(() => Convert.ToUInt16((UInt32) 0) ), L<UInt32, UInt16>(p0 => Sql.ConvertTo<UInt16>.From(p0) ) },
568 { M(() => Convert.ToUInt16((UInt64) 0) ), L<UInt64, UInt16>(p0 => Sql.ConvertTo<UInt16>.From(p0) ) },
569
570 #endregion
571
572 #region ToInt32
573
574 { M(() => Convert.ToUInt32((Boolean)true)), L<Boolean, UInt32>(p0 => Sql.ConvertTo<UInt32>.From(p0) ) },
575 { M(() => Convert.ToUInt32((Byte) 0) ), L<Byte, UInt32>(p0 => Sql.ConvertTo<UInt32>.From(p0) ) },
576 { M(() => Convert.ToUInt32((Char) '0') ), L<Char, UInt32>(p0 => Sql.ConvertTo<UInt32>.From(p0) ) },
577 #if !SILVERLIGHT
578 { M(() => Convert.ToUInt32(DateTime.Now) ), L<DateTime,UInt32>(p0 => Sql.ConvertTo<UInt32>.From(p0) ) },
579 #endif
580 { M(() => Convert.ToUInt32((Decimal) 0) ), L<Decimal, UInt32>(p0 => Sql.ConvertTo<UInt32>.From(Sql.RoundToEven(p0)) ) },
581 { M(() => Convert.ToUInt32((Double) 0) ), L<Double, UInt32>(p0 => Sql.ConvertTo<UInt32>.From(Sql.RoundToEven(p0)) ) },
582 { M(() => Convert.ToUInt32((Int16) 0) ), L<Int16, UInt32>(p0 => Sql.ConvertTo<UInt32>.From(p0) ) },
583 { M(() => Convert.ToUInt32((Int32) 0) ), L<Int32, UInt32>(p0 => Sql.ConvertTo<UInt32>.From(p0) ) },
584 { M(() => Convert.ToUInt32((Int64) 0) ), L<Int64, UInt32>(p0 => Sql.ConvertTo<UInt32>.From(p0) ) },
585 { M(() => Convert.ToUInt32((Object) 0) ), L<Object, UInt32>(p0 => Sql.ConvertTo<UInt32>.From(p0) ) },
586 { M(() => Convert.ToUInt32((SByte) 0) ), L<SByte, UInt32>(p0 => Sql.ConvertTo<UInt32>.From(p0) ) },
587 { M(() => Convert.ToUInt32((Single) 0) ), L<Single, UInt32>(p0 => Sql.ConvertTo<UInt32>.From(Sql.RoundToEven(p0)) ) },
588 { M(() => Convert.ToUInt32((String) "0") ), L<String, UInt32>(p0 => Sql.ConvertTo<UInt32>.From(p0) ) },
589 { M(() => Convert.ToUInt32((UInt16) 0) ), L<UInt16, UInt32>(p0 => Sql.ConvertTo<UInt32>.From(p0) ) },
590 { M(() => Convert.ToUInt32((UInt32) 0) ), L<UInt32, UInt32>(p0 => Sql.ConvertTo<UInt32>.From(p0) ) },
591 { M(() => Convert.ToUInt32((UInt64) 0) ), L<UInt64, UInt32>(p0 => Sql.ConvertTo<UInt32>.From(p0) ) },
592
593 #endregion
594
595 #region ToUInt64
596
597 { M(() => Convert.ToUInt64((Boolean)true)), L<Boolean, UInt64>(p0 => Sql.ConvertTo<UInt64>.From(p0) ) },
598 { M(() => Convert.ToUInt64((Byte) 0) ), L<Byte, UInt64>(p0 => Sql.ConvertTo<UInt64>.From(p0) ) },
599 { M(() => Convert.ToUInt64((Char) '0') ), L<Char, UInt64>(p0 => Sql.ConvertTo<UInt64>.From(p0) ) },
600 #if !SILVERLIGHT
601 { M(() => Convert.ToUInt64(DateTime.Now) ), L<DateTime,UInt64>(p0 => Sql.ConvertTo<UInt64>.From(p0) ) },
602 #endif
603 { M(() => Convert.ToUInt64((Decimal) 0) ), L<Decimal, UInt64>(p0 => Sql.ConvertTo<UInt64>.From(Sql.RoundToEven(p0)) ) },
604 { M(() => Convert.ToUInt64((Double) 0) ), L<Double, UInt64>(p0 => Sql.ConvertTo<UInt64>.From(Sql.RoundToEven(p0)) ) },
605 { M(() => Convert.ToUInt64((Int16) 0) ), L<Int16, UInt64>(p0 => Sql.ConvertTo<UInt64>.From(p0) ) },
606 { M(() => Convert.ToUInt64((Int32) 0) ), L<Int32, UInt64>(p0 => Sql.ConvertTo<UInt64>.From(p0) ) },
607 { M(() => Convert.ToUInt64((Int64) 0) ), L<Int64, UInt64>(p0 => Sql.ConvertTo<UInt64>.From(p0) ) },
608 { M(() => Convert.ToUInt64((Object) 0) ), L<Object, UInt64>(p0 => Sql.ConvertTo<UInt64>.From(p0) ) },
609 { M(() => Convert.ToUInt64((SByte) 0) ), L<SByte, UInt64>(p0 => Sql.ConvertTo<UInt64>.From(p0) ) },
610 { M(() => Convert.ToUInt64((Single) 0) ), L<Single, UInt64>(p0 => Sql.ConvertTo<UInt64>.From(Sql.RoundToEven(p0)) ) },
611 { M(() => Convert.ToUInt64((String) "0") ), L<String, UInt64>(p0 => Sql.ConvertTo<UInt64>.From(p0) ) },
612 { M(() => Convert.ToUInt64((UInt16) 0) ), L<UInt16, UInt64>(p0 => Sql.ConvertTo<UInt64>.From(p0) ) },
613 { M(() => Convert.ToUInt64((UInt32) 0) ), L<UInt32, UInt64>(p0 => Sql.ConvertTo<UInt64>.From(p0) ) },
614 { M(() => Convert.ToUInt64((UInt64) 0) ), L<UInt64, UInt64>(p0 => Sql.ConvertTo<UInt64>.From(p0) ) },
615
616 #endregion
617
618 #endregion
619
620 #region Math
621
622 { M(() => Math.Abs ((Decimal)0)), L<Decimal,Decimal>(p => Sql.Abs(p).Value ) },
623 { M(() => Math.Abs ((Double) 0)), L<Double, Double> (p => Sql.Abs(p).Value ) },
624 { M(() => Math.Abs ((Int16) 0)), L<Int16, Int16> (p => Sql.Abs(p).Value ) },
625 { M(() => Math.Abs ((Int32) 0)), L<Int32, Int32> (p => Sql.Abs(p).Value ) },
626 { M(() => Math.Abs ((Int64) 0)), L<Int64, Int64> (p => Sql.Abs(p).Value ) },
627 { M(() => Math.Abs ((SByte) 0)), L<SByte, SByte> (p => Sql.Abs(p).Value ) },
628 { M(() => Math.Abs ((Single) 0)), L<Single, Single> (p => Sql.Abs(p).Value ) },
629
630 { M(() => Math.Acos (0) ), L<F,F> ( p => Sql.Acos (p) .Value ) },
631 { M(() => Math.Asin (0) ), L<F,F> ( p => Sql.Asin (p) .Value ) },
632 { M(() => Math.Atan (0) ), L<F,F> ( p => Sql.Atan (p) .Value ) },
633 { M(() => Math.Atan2 (0,0) ), L<F,F,F>((x,y) => Sql.Atan2 (x, y).Value ) },
634 #if !SILVERLIGHT
635 { M(() => Math.Ceiling((M)0)), L<M,M> ( p => Sql.Ceiling(p) .Value ) },
636 #endif
637 { M(() => Math.Ceiling((F)0)), L<F,F> ( p => Sql.Ceiling(p) .Value ) },
638 { M(() => Math.Cos (0) ), L<F,F> ( p => Sql.Cos (p) .Value ) },
639 { M(() => Math.Cosh (0) ), L<F,F> ( p => Sql.Cosh (p) .Value ) },
640 { M(() => Math.Exp (0) ), L<F,F> ( p => Sql.Exp (p) .Value ) },
641 #if !SILVERLIGHT
642 { M(() => Math.Floor ((M)0)), L<M,M> ( p => Sql.Floor (p) .Value ) },
643 #endif
644 { M(() => Math.Floor ((F)0)), L<F,F> ( p => Sql.Floor (p) .Value ) },
645 { M(() => Math.Log (0) ), L<F,F> ( p => Sql.Log (p) .Value ) },
646 { M(() => Math.Log (0,0) ), L<F,F,F>((m,n) => Sql.Log (n, m).Value ) },
647 { M(() => Math.Log10 (0) ), L<F,F> ( p => Sql.Log10 (p) .Value ) },
648
649 { M(() => Math.Max((Byte) 0, (Byte) 0)), L<Byte, Byte, Byte> ((v1,v2) => v1 > v2 ? v1 : v2) },
650 { M(() => Math.Max((Decimal)0, (Decimal)0)), L<Decimal,Decimal,Decimal>((v1,v2) => v1 > v2 ? v1 : v2) },
651 { M(() => Math.Max((Double) 0, (Double) 0)), L<Double, Double, Double> ((v1,v2) => v1 > v2 ? v1 : v2) },
652 { M(() => Math.Max((Int16) 0, (Int16) 0)), L<Int16, Int16, Int16> ((v1,v2) => v1 > v2 ? v1 : v2) },
653 { M(() => Math.Max((Int32) 0, (Int32) 0)), L<Int32, Int32, Int32> ((v1,v2) => v1 > v2 ? v1 : v2) },
654 { M(() => Math.Max((Int64) 0, (Int64) 0)), L<Int64, Int64, Int64> ((v1,v2) => v1 > v2 ? v1 : v2) },
655 { M(() => Math.Max((SByte) 0, (SByte) 0)), L<SByte, SByte, SByte> ((v1,v2) => v1 > v2 ? v1 : v2) },
656 { M(() => Math.Max((Single) 0, (Single) 0)), L<Single, Single, Single> ((v1,v2) => v1 > v2 ? v1 : v2) },
657 { M(() => Math.Max((UInt16) 0, (UInt16) 0)), L<UInt16, UInt16, UInt16> ((v1,v2) => v1 > v2 ? v1 : v2) },
658 { M(() => Math.Max((UInt32) 0, (UInt32) 0)), L<UInt32, UInt32, UInt32> ((v1,v2) => v1 > v2 ? v1 : v2) },
659 { M(() => Math.Max((UInt64) 0, (UInt64) 0)), L<UInt64, UInt64, UInt64> ((v1,v2) => v1 > v2 ? v1 : v2) },
660
661 { M(() => Math.Min((Byte) 0, (Byte) 0)), L<Byte, Byte, Byte> ((v1,v2) => v1 < v2 ? v1 : v2) },
662 { M(() => Math.Min((Decimal)0, (Decimal)0)), L<Decimal,Decimal,Decimal>((v1,v2) => v1 < v2 ? v1 : v2) },
663 { M(() => Math.Min((Double) 0, (Double) 0)), L<Double, Double, Double> ((v1,v2) => v1 < v2 ? v1 : v2) },
664 { M(() => Math.Min((Int16) 0, (Int16) 0)), L<Int16, Int16, Int16> ((v1,v2) => v1 < v2 ? v1 : v2) },
665 { M(() => Math.Min((Int32) 0, (Int32) 0)), L<Int32, Int32, Int32> ((v1,v2) => v1 < v2 ? v1 : v2) },
666 { M(() => Math.Min((Int64) 0, (Int64) 0)), L<Int64, Int64, Int64> ((v1,v2) => v1 < v2 ? v1 : v2) },
667 { M(() => Math.Min((SByte) 0, (SByte) 0)), L<SByte, SByte, SByte> ((v1,v2) => v1 < v2 ? v1 : v2) },
668 { M(() => Math.Min((Single) 0, (Single) 0)), L<Single, Single, Single> ((v1,v2) => v1 < v2 ? v1 : v2) },
669 { M(() => Math.Min((UInt16) 0, (UInt16) 0)), L<UInt16, UInt16, UInt16> ((v1,v2) => v1 < v2 ? v1 : v2) },
670 { M(() => Math.Min((UInt32) 0, (UInt32) 0)), L<UInt32, UInt32, UInt32> ((v1,v2) => v1 < v2 ? v1 : v2) },
671 { M(() => Math.Min((UInt64) 0, (UInt64) 0)), L<UInt64, UInt64, UInt64> ((v1,v2) => v1 < v2 ? v1 : v2) },
672
673 { M(() => Math.Pow (0,0)), L<F,F,F>((x,y) => Sql.Power(x, y).Value ) },
674
675 { M(() => Sql.Round (0m) ), L<M?,M?> ( d => Sql.Round(d, 0)) },
676 { M(() => Sql.Round (0.0) ), L<F?,F?> ( d => Sql.Round(d, 0)) },
677
678 { M(() => Sql.RoundToEven(0m) ), L<M?,M?> ( d => d - Sql.Floor(d) == 0.5m && Sql.Floor(d) % 2 == 0? Sql.Floor(d) : Sql.Round(d)) },
679 { M(() => Sql.RoundToEven(0.0) ), L<F?,F?> ( d => d - Sql.Floor(d) == 0.5 && Sql.Floor(d) % 2 == 0? Sql.Floor(d) : Sql.Round(d)) },
680
681 { M(() => Sql.RoundToEven(0m, 0)), L<M?,I?,M?>((d,n) => d * 2 == Sql.Round(d * 2, n) && d != Sql.Round(d, n) ? Sql.Round(d / 2, n) * 2 : Sql.Round(d, n)) },
682 { M(() => Sql.RoundToEven(0.0,0)), L<F?,I?,F?>((d,n) => d * 2 == Sql.Round(d * 2, n) && d != Sql.Round(d, n) ? Sql.Round(d / 2, n) * 2 : Sql.Round(d, n)) },
683
684 { M(() => Math.Round (0m) ), L<M,M> ( d => Sql.RoundToEven(d).Value ) },
685 { M(() => Math.Round (0.0) ), L<F,F> ( d => Sql.RoundToEven(d).Value ) },
686
687 { M(() => Math.Round (0m, 0)), L<M,I,M> ((d,n) => Sql.RoundToEven(d, n).Value ) },
688 { M(() => Math.Round (0.0,0)), L<F,I,F> ((d,n) => Sql.RoundToEven(d, n).Value ) },
689
690 #if !SILVERLIGHT
691 { M(() => Math.Round (0m, MidpointRounding.ToEven)), L<M, MidpointRounding,M>((d, p) => p == MidpointRounding.ToEven ? Sql.RoundToEven(d). Value : Sql.Round(d). Value ) },
692 { M(() => Math.Round (0.0, MidpointRounding.ToEven)), L<F, MidpointRounding,F>((d, p) => p == MidpointRounding.ToEven ? Sql.RoundToEven(d). Value : Sql.Round(d). Value ) },
693
694 { M(() => Math.Round (0m, 0, MidpointRounding.ToEven)), L<M,I,MidpointRounding,M>((d,n,p) => p == MidpointRounding.ToEven ? Sql.RoundToEven(d,n).Value : Sql.Round(d,n).Value ) },
695 { M(() => Math.Round (0.0,0, MidpointRounding.ToEven)), L<F,I,MidpointRounding,F>((d,n,p) => p == MidpointRounding.ToEven ? Sql.RoundToEven(d,n).Value : Sql.Round(d,n).Value ) },
696 #endif
697
698 { M(() => Math.Sign ((Decimal)0)), L<Decimal,I>(p => Sql.Sign(p).Value ) },
699 { M(() => Math.Sign ((Double) 0)), L<Double, I>(p => Sql.Sign(p).Value ) },
700 { M(() => Math.Sign ((Int16) 0)), L<Int16, I>(p => Sql.Sign(p).Value ) },
701 { M(() => Math.Sign ((Int32) 0)), L<Int32, I>(p => Sql.Sign(p).Value ) },
702 { M(() => Math.Sign ((Int64) 0)), L<Int64, I>(p => Sql.Sign(p).Value ) },
703 { M(() => Math.Sign ((SByte) 0)), L<SByte, I>(p => Sql.Sign(p).Value ) },
704 { M(() => Math.Sign ((Single) 0)), L<Single, I>(p => Sql.Sign(p).Value ) },
705
706 { M(() => Math.Sin (0)), L<F,F>( p => Sql.Sin (p).Value ) },
707 { M(() => Math.Sinh (0)), L<F,F>( p => Sql.Sinh(p).Value ) },
708 { M(() => Math.Sqrt (0)), L<F,F>( p => Sql.Sqrt(p).Value ) },
709 { M(() => Math.Tan (0)), L<F,F>( p => Sql.Tan (p).Value ) },
710 { M(() => Math.Tanh (0)), L<F,F>( p => Sql.Tanh(p).Value ) },
711
712 #if !SILVERLIGHT
713 { M(() => Math.Truncate(0m)), L<M,M>( p => Sql.Truncate(p).Value ) },
714 { M(() => Math.Truncate(0.0)), L<F,F>( p => Sql.Truncate(p).Value ) },
715 #endif
716
717 #endregion
718
719 #region Visual Basic Compiler Services
720
721 //#if !SILVERLIGHT
722 // { M(() => Operators.CompareString("","",false)), L<S,S,B,I>((s1,s2,b) => b ? string.CompareOrdinal(s1.ToUpper(), s2.ToUpper()) : string.CompareOrdinal(s1, s2)) },
723 //#endif
724
725 #endregion
726
727 }},
728
729 #region MsSql2012
730
731 { "MsSql2012", new Dictionary<MemberInfo,LambdaExpression> {
732 { M(() => Sql.PadRight("",0,' ')), L<S,I?,C,S> ((p0,p1,p2) => p0.Length > p1 ? p0 : p0 + Replicate(p2, p1 - p0.Length)) },
733 { M(() => Sql.PadLeft ("",0,' ')), L<S,I?,C,S> ((p0,p1,p2) => p0.Length > p1 ? p0 : Replicate(p2, p1 - p0.Length) + p0) },
734 { M(() => Sql.Trim ("") ), L<S,S> ( p0 => Sql.TrimLeft(Sql.TrimRight(p0))) },
735 { M(() => Sql.MakeDateTime(0,0,0)), L<I?,I?,I?,D?>((y,m,d) => DateAdd(Sql.DateParts.Month, (y.Value - 1900) * 12 + m.Value - 1, d.Value - 1)) },
736
737 { M(() => Sql.Cosh(0) ), L<F?,F?> ( v => (Sql.Exp(v) + Sql.Exp(-v)) / 2) },
738 { M(() => Sql.Log(0m, 0)), L<M?,M?,M?>((m,n) => Sql.Log(n) / Sql.Log(m)) },
739 { M(() => Sql.Log(0.0,0)), L<F?,F?,F?>((m,n) => Sql.Log(n) / Sql.Log(m)) },
740 { M(() => Sql.Sinh(0) ), L<F?,F?> ( v => (Sql.Exp(v) - Sql.Exp(-v)) / 2) },
741 { M(() => Sql.Tanh(0) ), L<F?,F?> ( v => (Sql.Exp(v) - Sql.Exp(-v)) / (Sql.Exp(v) + Sql.Exp(-v))) },
742 }},
743
744 #endregion
745
746 #region MsSql2008
747
748 { "MsSql2008", new Dictionary<MemberInfo,LambdaExpression> {
749 { M(() => Sql.PadRight("",0,' ')), L<S,I?,C,S> ((p0,p1,p2) => p0.Length > p1 ? p0 : p0 + Replicate(p2, p1 - p0.Length)) },
750 { M(() => Sql.PadLeft ("",0,' ')), L<S,I?,C,S> ((p0,p1,p2) => p0.Length > p1 ? p0 : Replicate(p2, p1 - p0.Length) + p0) },
751 { M(() => Sql.Trim ("") ), L<S,S> ( p0 => Sql.TrimLeft(Sql.TrimRight(p0))) },
752 { M(() => Sql.MakeDateTime(0,0,0)), L<I?,I?,I?,D?>((y,m,d) => DateAdd(Sql.DateParts.Month, (y.Value - 1900) * 12 + m.Value - 1, d.Value - 1)) },
753
754 { M(() => Sql.Cosh(0) ), L<F?,F?> ( v => (Sql.Exp(v) + Sql.Exp(-v)) / 2) },
755 { M(() => Sql.Log(0m, 0)), L<M?,M?,M?>((m,n) => Sql.Log(n) / Sql.Log(m)) },
756 { M(() => Sql.Log(0.0,0)), L<F?,F?,F?>((m,n) => Sql.Log(n) / Sql.Log(m)) },
757 { M(() => Sql.Sinh(0) ), L<F?,F?> ( v => (Sql.Exp(v) - Sql.Exp(-v)) / 2) },
758 { M(() => Sql.Tanh(0) ), L<F?,F?> ( v => (Sql.Exp(v) - Sql.Exp(-v)) / (Sql.Exp(v) + Sql.Exp(-v))) },
759 }},
760
761 #endregion
762
763 #region MsSql2000
764
765 { "MsSql2000", new Dictionary<MemberInfo,LambdaExpression> {
766 { M(() => Sql.PadRight("",0,' ')), L<S,I?,C,S> ((p0,p1,p2) => p0.Length > p1 ? p0 : p0 + Replicate(p2, p1 - p0.Length)) },
767 { M(() => Sql.PadLeft ("",0,' ')), L<S,I?,C,S> ((p0,p1,p2) => p0.Length > p1 ? p0 : Replicate(p2, p1 - p0.Length) + p0) },
768 { M(() => Sql.Trim ("") ), L<S,S> ( p0 => Sql.TrimLeft(Sql.TrimRight(p0))) },
769 { M(() => Sql.MakeDateTime(0,0,0)), L<I?,I?,I?,D?>((y,m,d) => DateAdd(Sql.DateParts.Month, (y.Value - 1900) * 12 + m.Value - 1, d.Value - 1)) },
770 { M(() => Sql.MakeDateTime(0, 0, 0, 0, 0, 0) ), L<I?,I?,I?,I?,I?,I?,D?>((y,m,d,h,mm,s) => Sql.Convert(Sql.DateTime2,
771 y.ToString() + "-" + m.ToString() + "-" + d.ToString() + " " +
772 h.ToString() + ":" + mm.ToString() + ":" + s.ToString(), 120)) },
773 { M(() => Sql.Cosh(0) ), L<F?,F?> ( v => (Sql.Exp(v) + Sql.Exp(-v)) / 2) },
774 { M(() => Sql.Log(0m, 0)), L<M?,M?,M?>((m,n) => Sql.Log(n) / Sql.Log(m)) },
775 { M(() => Sql.Log(0.0,0)), L<F?,F?,F?>((m,n) => Sql.Log(n) / Sql.Log(m)) },
776 { M(() => Sql.Sinh(0) ), L<F?,F?> ( v => (Sql.Exp(v) - Sql.Exp(-v)) / 2) },
777 { M(() => Sql.Tanh(0) ), L<F?,F?> ( v => (Sql.Exp(v) - Sql.Exp(-v)) / (Sql.Exp(v) + Sql.Exp(-v))) },
778
779 { M(() => DateTime.Parse("")), L<String,DateTime>(p0 => Sql.ConvertTo<DateTime>.From(p0) ) },
780 { M(() => Sql.RoundToEven(0m) ), L<M?,M?>(d => d - Sql.Floor(d) == 0.5m && (long)Sql.Floor(d) % 2 == 0? Sql.Floor(d) : Sql.Round(d)) },
781 { M(() => Sql.RoundToEven(0.0)), L<F?,F?>(d => d - Sql.Floor(d) == 0.5 && (long)Sql.Floor(d) % 2 == 0? Sql.Floor(d) : Sql.Round(d)) },
782
783 }},
784
785 #endregion
786
787 #region MsSql2005
788
789 { "MsSql2005", new Dictionary<MemberInfo,LambdaExpression> {
790 { M(() => Sql.PadRight("",0,' ')), L<S,I?,C,S> ((p0,p1,p2) => p0.Length > p1 ? p0 : p0 + Replicate(p2, p1 - p0.Length)) },
791 { M(() => Sql.PadLeft ("",0,' ')), L<S,I?,C,S> ((p0,p1,p2) => p0.Length > p1 ? p0 : Replicate(p2, p1 - p0.Length) + p0) },
792 { M(() => Sql.Trim ("") ), L<S,S> ( p0 => Sql.TrimLeft(Sql.TrimRight(p0))) },
793 { M(() => Sql.MakeDateTime(0,0,0)), L<I?,I?,I?,D?>((y,m,d) => DateAdd(Sql.DateParts.Month, (y.Value - 1900) * 12 + m.Value - 1, d.Value - 1)) },
794 { M(() => Sql.MakeDateTime(0, 0, 0, 0, 0, 0) ), L<I?,I?,I?,I?,I?,I?,D?>((y,m,d,h,mm,s) => Sql.Convert(Sql.DateTime2,
795 y.ToString() + "-" + m.ToString() + "-" + d.ToString() + " " +
796 h.ToString() + ":" + mm.ToString() + ":" + s.ToString(), 120)) },
797 { M(() => Sql.Cosh(0) ), L<F?,F?> ( v => (Sql.Exp(v) + Sql.Exp(-v)) / 2) },
798 { M(() => Sql.Log(0m, 0)), L<M?,M?,M?>((m,n) => Sql.Log(n) / Sql.Log(m)) },
799 { M(() => Sql.Log(0.0,0)), L<F?,F?,F?>((m,n) => Sql.Log(n) / Sql.Log(m)) },
800 { M(() => Sql.Sinh(0) ), L<F?,F?> ( v => (Sql.Exp(v) - Sql.Exp(-v)) / 2) },
801 { M(() => Sql.Tanh(0) ), L<F?,F?> ( v => (Sql.Exp(v) - Sql.Exp(-v)) / (Sql.Exp(v) + Sql.Exp(-v))) },
802
803 { M(() => DateTime.Parse("")), L<String,DateTime>(p0 => Sql.ConvertTo<DateTime>.From(p0) ) },
804 }},
805
806 #endregion
807
808 #region SqlCe
809
810 { "SqlCe", new Dictionary<MemberInfo,LambdaExpression> {
811 { M(() => Sql.Left ("",0) ), L<S,I?,S> ((p0,p1) => Sql.Substring(p0, 1, p1)) },
812 { M(() => Sql.Right ("",0) ), L<S,I?,S> ((p0,p1) => Sql.Substring(p0, p0.Length - p1 + 1, p1)) },
813 { M(() => Sql.PadRight("",0,' ')), L<S,I?,C?,S>((p0,p1,p2) => p0.Length > p1 ? p0 : p0 + Replicate(p2, p1 - p0.Length)) },
814 { M(() => Sql.PadLeft ("",0,' ')), L<S,I?,C?,S>((p0,p1,p2) => p0.Length > p1 ? p0 : Replicate(p2, p1 - p0.Length) + p0) },
815 { M(() => Sql.Trim ("") ), L<S,S> ( p0 => Sql.TrimLeft(Sql.TrimRight(p0))) },
816
817 { M(() => Sql.Cosh(0) ), L<F?,F?> ( v => (Sql.Exp(v) + Sql.Exp(-v)) / 2) },
818 { M(() => Sql.Log (0m, 0)), L<M?,M?,M?>((m,n) => Sql.Log(n) / Sql.Log(m)) },
819 { M(() => Sql.Log (0.0,0)), L<F?,F?,F?>((m,n) => Sql.Log(n) / Sql.Log(m)) },
820 { M(() => Sql.Sinh(0) ), L<F?,F?> ( v => (Sql.Exp(v) - Sql.Exp(-v)) / 2) },
821 { M(() => Sql.Tanh(0) ), L<F?,F?> ( v => (Sql.Exp(v) - Sql.Exp(-v)) / (Sql.Exp(v) + Sql.Exp(-v))) },
822 }},
823
824 #endregion
825
826 #region DB2
827
828 { "DB2", new Dictionary<MemberInfo,LambdaExpression> {
829 { M(() => Sql.Space (0) ), L<I?,S> ( p0 => Sql.Convert(Sql.VarChar(1000), Replicate(" ", p0))) },
830 { M(() => Sql.Stuff ("",0,0,"")), L<S,I?,I?,S,S>((p0,p1,p2,p3) => AltStuff(p0, p1, p2, p3)) },
831 { M(() => Sql.PadRight("",0,' ') ), L<S,I?,C?,S> ((p0,p1,p2) => p0.Length > p1 ? p0 : p0 + VarChar(Replicate(p2, p1 - p0.Length), 1000)) },
832 { M(() => Sql.PadLeft ("",0,' ') ), L<S,I?,C?,S> ((p0,p1,p2) => p0.Length > p1 ? p0 : VarChar(Replicate(p2, p1 - p0.Length), 1000) + p0) },
833
834 { M(() => Sql.ConvertTo<String>.From((Decimal)0)), L<Decimal,S>(p => Sql.TrimLeft(Sql.Convert<string,Decimal>(p), '0')) },
835 { M(() => Sql.ConvertTo<String>.From(Guid.Empty)), L<Guid, S>(p => Sql.Lower(
836 Sql.Substring(Hex(p), 7, 2) + Sql.Substring(Hex(p), 5, 2) + Sql.Substring(Hex(p), 3, 2) + Sql.Substring(Hex(p), 1, 2) + "-" +
837 Sql.Substring(Hex(p), 11, 2) + Sql.Substring(Hex(p), 9, 2) + "-" +
838 Sql.Substring(Hex(p), 15, 2) + Sql.Substring(Hex(p), 13, 2) + "-" +
839 Sql.Substring(Hex(p), 17, 4) + "-" +
840 Sql.Substring(Hex(p), 21, 12))) },
841
842 { M(() => Sql.Log(0m, 0)), L<M?,M?,M?>((m,n) => Sql.Log(n) / Sql.Log(m)) },
843 { M(() => Sql.Log(0.0,0)), L<F?,F?,F?>((m,n) => Sql.Log(n) / Sql.Log(m)) },
844 }},
845
846 #endregion
847
848 #region Informix
849
850 { "Informix", new Dictionary<MemberInfo,LambdaExpression> {
851 { M(() => Sql.Left ("",0) ), L<S,I?,S> ((p0,p1) => Sql.Substring(p0, 1, p1)) },
852 { M(() => Sql.Right("",0) ), L<S,I?,S> ((p0,p1) => Sql.Substring(p0, p0.Length - p1 + 1, p1)) },
853 { M(() => Sql.Stuff("",0,0,"")), L<S,I?,I?,S,S>((p0,p1,p2,p3) => AltStuff (p0, p1, p2, p3)) },
854 { M(() => Sql.Space(0) ), L<I?,S> ( p0 => Sql.PadRight (" ", p0, ' ')) },
855
856 { M(() => Sql.MakeDateTime(0,0,0)), L<I?,I?,I?,D?>((y,m,d) => Mdy(m, d, y)) },
857
858 { M(() => Sql.Cot (0) ), L<F?,F?> ( v => Sql.Cos(v) / Sql.Sin(v) ) },
859 { M(() => Sql.Cosh(0) ), L<F?,F?> ( v => (Sql.Exp(v) + Sql.Exp(-v)) / 2 ) },
860
861 { M(() => Sql.Degrees((Decimal?)0)), L<Decimal?,Decimal?>( v => (Decimal?)(v.Value * (180 / (Decimal)Math.PI))) },
862 { M(() => Sql.Degrees((Double?) 0)), L<Double?, Double?> ( v => (Double?) (v.Value * (180 / Math.PI))) },
863 { M(() => Sql.Degrees((Int16?) 0)), L<Int16?, Int16?> ( v => (Int16?) (v.Value * (180 / Math.PI))) },
864 { M(() => Sql.Degrees((Int32?) 0)), L<Int32?, Int32?> ( v => (Int32?) (v.Value * (180 / Math.PI))) },
865 { M(() => Sql.Degrees((Int64?) 0)), L<Int64?, Int64?> ( v => (Int64?) (v.Value * (180 / Math.PI))) },
866 { M(() => Sql.Degrees((SByte?) 0)), L<SByte?, SByte?> ( v => (SByte?) (v.Value * (180 / Math.PI))) },
867 { M(() => Sql.Degrees((Single?) 0)), L<Single?, Single?> ( v => (Single?) (v.Value * (180 / Math.PI))) },
868
869 { M(() => Sql.Log(0m, 0)), L<M?,M?,M?>((m,n) => Sql.Log(n) / Sql.Log(m)) },
870 { M(() => Sql.Log(0.0,0)), L<F?,F?,F?>((m,n) => Sql.Log(n) / Sql.Log(m)) },
871
872 { M(() => Sql.Sign((Decimal?)0)), L<Decimal?,I?>(p => p > 0 ? 1 : p < 0 ? -1 : 0 ) },
873 { M(() => Sql.Sign((Double?) 0)), L<Double?, I?>(p => p > 0 ? 1 : p < 0 ? -1 : 0 ) },
874 { M(() => Sql.Sign((Int16?) 0)), L<Int16?, I?>(p => p > 0 ? 1 : p < 0 ? -1 : 0 ) },
875 { M(() => Sql.Sign((Int32?) 0)), L<Int32?, I?>(p => p > 0 ? 1 : p < 0 ? -1 : 0 ) },
876 { M(() => Sql.Sign((Int64?) 0)), L<Int64?, I?>(p => p > 0 ? 1 : p < 0 ? -1 : 0 ) },
877 { M(() => Sql.Sign((SByte?) 0)), L<SByte?, I?>(p => p > 0 ? 1 : p < 0 ? -1 : 0 ) },
878 { M(() => Sql.Sign((Single?) 0)), L<Single?, I?>(p => p > 0 ? 1 : p < 0 ? -1 : 0 ) },
879
880 { M(() => Sql.Sinh(0)), L<F?,F?>( v => (Sql.Exp(v) - Sql.Exp(-v)) / 2) },
881 { M(() => Sql.Tanh(0)), L<F?,F?>( v => (Sql.Exp(v) - Sql.Exp(-v)) / (Sql.Exp(v) +Sql.Exp(-v))) },
882 }},
883
884 #endregion
885
886 #region Oracle
887
888 { "Oracle", new Dictionary<MemberInfo,LambdaExpression> {
889 { M(() => Sql.Left ("",0) ), L<S,I?,S> ((p0,p1) => Sql.Substring(p0, 1, p1)) },
890 { M(() => Sql.Right("",0) ), L<S,I?,S> ((p0,p1) => Sql.Substring(p0, p0.Length - p1 + 1, p1)) },
891 { M(() => Sql.Stuff("",0,0,"")), L<S,I?,I?,S,S>((p0,p1,p2,p3) => AltStuff(p0, p1, p2, p3)) },
892 { M(() => Sql.Space(0) ), L<I?,S> ( p0 => Sql.PadRight(" ", p0, ' ')) },
893
894 { M(() => Sql.ConvertTo<String>.From(Guid.Empty)), L<Guid,S>(p => Sql.Lower(
895 Sql.Substring(Sql.Convert2(Sql.Char(36), p), 7, 2) + Sql.Substring(Sql.Convert2(Sql.Char(36), p), 5, 2) + Sql.Substring(Sql.Convert2(Sql.Char(36), p), 3, 2) + Sql.Substring(Sql.Convert2(Sql.Char(36), p), 1, 2) + "-" +
896 Sql.Substring(Sql.Convert2(Sql.Char(36), p), 11, 2) + Sql.Substring(Sql.Convert2(Sql.Char(36), p), 9, 2) + "-" +
897 Sql.Substring(Sql.Convert2(Sql.Char(36), p), 15, 2) + Sql.Substring(Sql.Convert2(Sql.Char(36), p), 13, 2) + "-" +
898 Sql.Substring(Sql.Convert2(Sql.Char(36), p), 17, 4) + "-" +
899 Sql.Substring(Sql.Convert2(Sql.Char(36), p), 21, 12))) },
900
901 { M(() => Sql.Cot (0)), L<F?,F?>(v => Sql.Cos(v) / Sql.Sin(v) ) },
902 { M(() => Sql.Log10(0.0)), L<F?,F?>(v => Sql.Log(10, v) ) },
903
904 { M(() => Sql.Degrees((Decimal?)0)), L<Decimal?,Decimal?>( v => (Decimal?)(v.Value * (180 / (Decimal)Math.PI))) },
905 { M(() => Sql.Degrees((Double?) 0)), L<Double?, Double?> ( v => (Double?) (v.Value * (180 / Math.PI))) },
906 { M(() => Sql.Degrees((Int16?) 0)), L<Int16?, Int16?> ( v => (Int16?) (v.Value * (180 / Math.PI))) },
907 { M(() => Sql.Degrees((Int32?) 0)), L<Int32?, Int32?> ( v => (Int32?) (v.Value * (180 / Math.PI))) },
908 { M(() => Sql.Degrees((Int64?) 0)), L<Int64?, Int64?> ( v => (Int64?) (v.Value * (180 / Math.PI))) },
909 { M(() => Sql.Degrees((SByte?) 0)), L<SByte?, SByte?> ( v => (SByte?) (v.Value * (180 / Math.PI))) },
910 { M(() => Sql.Degrees((Single?) 0)), L<Single?, Single?> ( v => (Single?) (v.Value * (180 / Math.PI))) },
911 }},
912
913 #endregion
914
915 #region Firebird
916
917 { "Firebird", new Dictionary<MemberInfo,LambdaExpression> {
918 { M<S>(_ => Sql.Space(0 )), L<I?,S> ( p0 => Sql.PadRight(" ", p0, ' ')) },
919 { M<S>(s => Sql.Stuff(s, 0, 0, s)), L<S,I?,I?,S,S>((p0,p1,p2,p3) => AltStuff(p0, p1, p2, p3)) },
920
921 { M(() => Sql.Degrees((Decimal?)0)), L<Decimal?,Decimal?>( v => (Decimal?)(v.Value * 180 / DecimalPI())) },
922 { M(() => Sql.Degrees((Double?) 0)), L<Double?, Double?> ( v => (Double?) (v.Value * (180 / Math.PI))) },
923 { M(() => Sql.Degrees((Int16?) 0)), L<Int16?, Int16?> ( v => (Int16?) (v.Value * (180 / Math.PI))) },
924 { M(() => Sql.Degrees((Int32?) 0)), L<Int32?, Int32?> ( v => (Int32?) (v.Value * (180 / Math.PI))) },
925 { M(() => Sql.Degrees((Int64?) 0)), L<Int64?, Int64?> ( v => (Int64?) (v.Value * (180 / Math.PI))) },
926 { M(() => Sql.Degrees((SByte?) 0)), L<SByte?, SByte?> ( v => (SByte?) (v.Value * (180 / Math.PI))) },
927 { M(() => Sql.Degrees((Single?) 0)), L<Single?, Single?> ( v => (Single?) (v.Value * (180 / Math.PI))) },
928
929 { M(() => Sql.RoundToEven(0.0) ), L<F?,F?> ( v => (double)Sql.RoundToEven((decimal)v)) },
930 { M(() => Sql.RoundToEven(0.0,0)), L<F?,I?,F?>((v,p) => (double)Sql.RoundToEven((decimal)v, p)) },
931 }},
932
933 #endregion
934
935 #region MySql
936
937 { "MySql", new Dictionary<MemberInfo,LambdaExpression> {
938 { M<S>(s => Sql.Stuff(s, 0, 0, s)), L<S,I?,I?,S,S>((p0,p1,p2,p3) => AltStuff(p0, p1, p2, p3)) },
939
940 { M(() => Sql.Cosh(0)), L<F?,F?>(v => (Sql.Exp(v) + Sql.Exp(-v)) / 2) },
941 { M(() => Sql.Sinh(0)), L<F?,F?>(v => (Sql.Exp(v) - Sql.Exp(-v)) / 2) },
942 { M(() => Sql.Tanh(0)), L<F?,F?>(v => (Sql.Exp(v) - Sql.Exp(-v)) / (Sql.Exp(v) + Sql.Exp(-v))) },
943 }},
944
945 #endregion
946
947 #region PostgreSQL
948
949 { "PostgreSQL", new Dictionary<MemberInfo,LambdaExpression> {
950 { M(() => Sql.Left ("",0) ), L<S,I?,S> ((p0,p1) => Sql.Substring(p0, 1, p1)) },
951 { M(() => Sql.Right("",0) ), L<S,I?,S> ((p0,p1) => Sql.Substring(p0, p0.Length - p1 + 1, p1)) },
952 { M(() => Sql.Stuff("",0,0,"")), L<S,I?,I?,S,S>((p0,p1,p2,p3) => AltStuff(p0, p1, p2, p3)) },
953 { M(() => Sql.Space(0) ), L<I?,S> ( p0 => Replicate(" ", p0)) },
954
955 { M(() => Sql.Cosh(0) ), L<F?,F?> ( v => (Sql.Exp(v) + Sql.Exp(-v)) / 2 ) },
956 { M(() => Sql.Round (0.0,0)), L<F?,I?,F?> ((v,p) => (double)Sql.Round ((decimal)v, p)) },
957 { M(() => Sql.RoundToEven(0.0) ), L<F?,F?> ( v => (double)Sql.RoundToEven((decimal)v)) },
958 { M(() => Sql.RoundToEven(0.0,0)), L<F?,I?,F?> ((v,p) => (double)Sql.RoundToEven((decimal)v, p)) },
959
960 { M(() => Sql.Log ((double)0,0)), L<F?,F?,F?> ((m,n) => (F?)Sql.Log((M)m,(M)n).Value ) },
961 { M(() => Sql.Sinh (0) ), L<F?,F?> ( v => (Sql.Exp(v) - Sql.Exp(-v)) / 2) },
962 { M(() => Sql.Tanh (0) ), L<F?,F?> ( v => (Sql.Exp(v) - Sql.Exp(-v)) / (Sql.Exp(v) + Sql.Exp(-v))) },
963
964 { M(() => Sql.Truncate(0.0) ), L<F?,F?> ( v => (double)Sql.Truncate((decimal)v)) },
965 }},
966
967 #endregion
968
969 #region SQLite
970
971 { "SQLite", new Dictionary<MemberInfo,LambdaExpression> {
972 { M(() => Sql.Stuff ("",0,0,"")), L<S,I?,I?,S,S>((p0,p1,p2,p3) => AltStuff(p0, p1, p2, p3)) },
973 { M(() => Sql.PadRight("",0,' ') ), L<S,I?,C?,S> ((p0,p1,p2) => p0.Length > p1 ? p0 : p0 + Replicate(p2, p1 - p0.Length)) },
974 { M(() => Sql.PadLeft ("",0,' ') ), L<S,I?,C?,S> ((p0,p1,p2) => p0.Length > p1 ? p0 : Replicate(p2, p1 - p0.Length) + p0) },
975
976 { M(() => Sql.MakeDateTime(0, 0, 0)), L<I?,I?,I?,D?>((y,m,d) => Sql.Convert(Sql.Date,
977 y.ToString() + "-" +
978 (m.ToString().Length == 1 ? "0" + m.ToString() : m.ToString()) + "-" +
979 (d.ToString().Length == 1 ? "0" + d.ToString() : d.ToString()))) },
980
981 { M(() => Sql.MakeDateTime(0, 0, 0, 0, 0, 0)), L<I?,I?,I?,I?,I?,I?,D?>((y,m,d,h,i,s) => Sql.Convert(Sql.DateTime2,
982 y.ToString() + "-" +
983 (m.ToString().Length == 1 ? "0" + m.ToString() : m.ToString()) + "-" +
984 (d.ToString().Length == 1 ? "0" + d.ToString() : d.ToString()) + " " +
985 (h.ToString().Length == 1 ? "0" + h.ToString() : h.ToString()) + ":" +
986 (i.ToString().Length == 1 ? "0" + i.ToString() : i.ToString()) + ":" +
987 (s.ToString().Length == 1 ? "0" + s.ToString() : s.ToString()))) },
988
989 { M(() => Sql.ConvertTo<String>.From(Guid.Empty)), L<Guid,S>(p => Sql.Lower(
990 Sql.Substring(Hex(p), 7, 2) + Sql.Substring(Hex(p), 5, 2) + Sql.Substring(Hex(p), 3, 2) + Sql.Substring(Hex(p), 1, 2) + "-" +
991 Sql.Substring(Hex(p), 11, 2) + Sql.Substring(Hex(p), 9, 2) + "-" +
992 Sql.Substring(Hex(p), 15, 2) + Sql.Substring(Hex(p), 13, 2) + "-" +
993 Sql.Substring(Hex(p), 17, 4) + "-" +
994 Sql.Substring(Hex(p), 21, 12))) },
995
996 { M(() => Sql.Log (0m, 0)), L<M?,M?,M?>((m,n) => Sql.Log(n) / Sql.Log(m)) },
997 { M(() => Sql.Log (0.0,0)), L<F?,F?,F?>((m,n) => Sql.Log(n) / Sql.Log(m)) },
998
999 { M(() => Sql.Truncate(0m)), L<M?,M?>( v => v >= 0 ? Sql.Floor(v) : Sql.Ceiling(v)) },
1000 { M(() => Sql.Truncate(0.0)), L<F?,F?>( v => v >= 0 ? Sql.Floor(v) : Sql.Ceiling(v)) },
1001 }},
1002
1003 #endregion
1004
1005 #region Sybase
1006
1007 { "Sybase", new Dictionary<MemberInfo,LambdaExpression> {
1008 { M(() => Sql.PadRight("",0,' ')), L<S,I?,C?,S>((p0,p1,p2) => p0.Length > p1 ? p0 : p0 + Replicate(p2, p1 - p0.Length)) },
1009 { M(() => Sql.PadLeft ("",0,' ')), L<S,I?,C?,S>((p0,p1,p2) => p0.Length > p1 ? p0 : Replicate(p2, p1 - p0.Length) + p0) },
1010 { M(() => Sql.Trim ("") ), L<S,S> ( p0 => Sql.TrimLeft(Sql.TrimRight(p0))) },
1011
1012 { M(() => Sql.Cosh(0) ), L<F?,F?> ( v => (Sql.Exp(v) + Sql.Exp(-v)) / 2) },
1013 { M(() => Sql.Log (0m, 0)), L<M?,M?,M?>((m,n) => Sql.Log(n) / Sql.Log(m)) },
1014 { M(() => Sql.Log (0.0,0)), L<F?,F?,F?>((m,n) => Sql.Log(n) / Sql.Log(m)) },
1015
1016 { M(() => Sql.Degrees((Decimal?)0)), L<Decimal?,Decimal?>( v => (Decimal?)(v.Value * (180 / (Decimal)Math.PI))) },
1017 { M(() => Sql.Degrees((Double?) 0)), L<Double?, Double?> ( v => (Double?) (v.Value * (180 / Math.PI))) },
1018 { M(() => Sql.Degrees((Int16?) 0)), L<Int16?, Int16?> ( v => (Int16?) (v.Value * (180 / Math.PI))) },
1019 { M(() => Sql.Degrees((Int32?) 0)), L<Int32?, Int32?> ( v => (Int32?) (v.Value * (180 / Math.PI))) },
1020 { M(() => Sql.Degrees((Int64?) 0)), L<Int64?, Int64?> ( v => (Int64?) (v.Value * (180 / Math.PI))) },
1021 { M(() => Sql.Degrees((SByte?) 0)), L<SByte?, SByte?> ( v => (SByte?) (v.Value * (180 / Math.PI))) },
1022 { M(() => Sql.Degrees((Single?) 0)), L<Single?, Single?> ( v => (Single?) (v.Value * (180 / Math.PI))) },
1023
1024 { M(() => Sql.Sinh(0)), L<F?,F?>( v => (Sql.Exp(v) - Sql.Exp(-v)) / 2) },
1025 { M(() => Sql.Tanh(0)), L<F?,F?>( v => (Sql.Exp(v) - Sql.Exp(-v)) / (Sql.Exp(v) + Sql.Exp(-v))) },
1026
1027 { M(() => Sql.Truncate(0m)), L<M?,M?>( v => v >= 0 ? Sql.Floor(v) : Sql.Ceiling(v)) },
1028 { M(() => Sql.Truncate(0.0)), L<F?,F?>( v => v >= 0 ? Sql.Floor(v) : Sql.Ceiling(v)) },
1029 }},
1030
1031 #endregion
1032
1033 #region Access
1034
1035 { "Access", new Dictionary<MemberInfo,LambdaExpression> {
1036 { M(() => Sql.Stuff ("",0,0,"")), L<S,I?,I?,S,S>((p0,p1,p2,p3) => AltStuff(p0, p1, p2, p3)) },
1037 { M(() => Sql.PadRight("",0,' ') ), L<S,I?,C?,S> ((p0,p1,p2) => p0.Length > p1 ? p0 : p0 + Replicate(p2, p1 - p0.Length)) },
1038 { M(() => Sql.PadLeft ("",0,' ') ), L<S,I?,C?,S> ((p0,p1,p2) => p0.Length > p1 ? p0 : Replicate(p2, p1 - p0.Length) + p0) },
1039 { M(() => Sql.MakeDateTime(0,0,0)), L<I?,I?,I?,D?>((y,m,d) => MakeDateTime2(y, m, d)) },
1040
1041 { M(() => Sql.ConvertTo<String>.From(Guid.Empty)), L<Guid,S>(p => Sql.Lower(Sql.Substring(p.ToString(), 2, 36))) },
1042
1043 { M(() => Sql.Ceiling((Decimal)0)), L<Decimal?,Decimal?>(p => -Sql.Floor(-p) ) },
1044 { M(() => Sql.Ceiling((Double) 0)), L<Double?, Double?> (p => -Sql.Floor(-p) ) },
1045
1046 { M(() => Sql.Cot (0) ), L<F?,F?> ( v => Sql.Cos(v) / Sql.Sin(v) ) },
1047 { M(() => Sql.Cosh (0) ), L<F?,F?> ( v => (Sql.Exp(v) + Sql.Exp(-v)) / 2) },
1048 { M(() => Sql.Log (0m, 0)), L<M?,M?,M?>((m,n) => Sql.Log(n) / Sql.Log(m) ) },
1049 { M(() => Sql.Log (0.0,0)), L<F?,F?,F?>((m,n) => Sql.Log(n) / Sql.Log(m) ) },
1050 { M(() => Sql.Log10(0.0) ), L<F?,F?> ( n => Sql.Log(n) / Sql.Log(10.0) ) },
1051
1052 { M(() => Sql.Degrees((Decimal?)0)), L<Decimal?,Decimal?>( v => (Decimal?) ( v.Value * (180 / (Decimal)Math.PI))) },
1053 { M(() => Sql.Degrees((Double?) 0)), L<Double?, Double?> ( v => (Double?) ( v.Value * (180 / Math.PI))) },
1054 { M(() => Sql.Degrees((Int16?) 0)), L<Int16?, Int16?> ( v => (Int16?) AccessInt(AccessInt(v.Value) * (180 / Math.PI))) },
1055 { M(() => Sql.Degrees((Int32?) 0)), L<Int32?, Int32?> ( v => (Int32?) AccessInt(AccessInt(v.Value) * (180 / Math.PI))) },
1056 { M(() => Sql.Degrees((Int64?) 0)), L<Int64?, Int64?> ( v => (Int64?) AccessInt(AccessInt(v.Value) * (180 / Math.PI))) },
1057 { M(() => Sql.Degrees((SByte?) 0)), L<SByte?, SByte?> ( v => (SByte?) AccessInt(AccessInt(v.Value) * (180 / Math.PI))) },
1058 { M(() => Sql.Degrees((Single?) 0)), L<Single?, Single?> ( v => (Single?) ( v.Value * (180 / Math.PI))) },
1059
1060 { M(() => Sql.Round (0m) ), L<M?,M?> ( d => d - Sql.Floor(d) == 0.5m && Sql.Floor(d) % 2 == 0? Sql.Ceiling(d) : AccessRound(d, 0)) },
1061 { M(() => Sql.Round (0.0) ), L<F?,F?> ( d => d - Sql.Floor(d) == 0.5 && Sql.Floor(d) % 2 == 0? Sql.Ceiling(d) : AccessRound(d, 0)) },
1062 { M(() => Sql.Round (0m, 0)), L<M?,I?,M?>((v,p)=>
1063 p == 1 ? Sql.Round(v * 10) / 10 :
1064 p == 2 ? Sql.Round(v * 10) / 10 :
1065 p == 3 ? Sql.Round(v * 10) / 10 :
1066 p == 4 ? Sql.Round(v * 10) / 10 :
1067 p == 5 ? Sql.Round(v * 10) / 10 :
1068 Sql.Round(v * 10) / 10) },
1069 { M(() => Sql.Round (0.0,0)), L<F?,I?,F?>((v,p)=>
1070 p == 1 ? Sql.Round(v * 10) / 10 :
1071 p == 2 ? Sql.Round(v * 10) / 10 :
1072 p == 3 ? Sql.Round(v * 10) / 10 :
1073 p == 4 ? Sql.Round(v * 10) / 10 :
1074 p == 5 ? Sql.Round(v * 10) / 10 :
1075 Sql.Round(v * 10) / 10) },
1076 { M(() => Sql.RoundToEven(0m) ), L<M?,M?> ( v => AccessRound(v, 0))},
1077 { M(() => Sql.RoundToEven(0.0) ), L<F?,F?> ( v => AccessRound(v, 0))},
1078 { M(() => Sql.RoundToEven(0m, 0)), L<M?,I?,M?>((v,p)=> AccessRound(v, p))},
1079 { M(() => Sql.RoundToEven(0.0,0)), L<F?,I?,F?>((v,p)=> AccessRound(v, p))},
1080
1081 { M(() => Sql.Sinh(0)), L<F?,F?>( v => (Sql.Exp(v) - Sql.Exp(-v)) / 2) },
1082 { M(() => Sql.Tanh(0)), L<F?,F?>( v => (Sql.Exp(v) - Sql.Exp(-v)) / (Sql.Exp(v) + Sql.Exp(-v))) },
1083
1084 { M(() => Sql.Truncate(0m)), L<M?,M?>( v => v >= 0 ? Sql.Floor(v) : Sql.Ceiling(v)) },
1085 { M(() => Sql.Truncate(0.0)), L<F?,F?>( v => v >= 0 ? Sql.Floor(v) : Sql.Ceiling(v)) },
1086 }},
1087
1088 #endregion
1089 };
1090
1091 #region Sql specific
1092
1093 [CLSCompliant(false)]
1094 [SqlFunction("RTrim", 0)]
1095 public static string TrimRight(string str, char[] trimChars)
1096 {
1097 return str == null ? null : str.TrimEnd(trimChars);
1098 }
1099
1100 [CLSCompliant(false)]
1101 [SqlFunction("LTrim", 0)]
1102 public static string TrimLeft(string str, char[] trimChars)
1103 {
1104 return str == null ? null : str.TrimStart(trimChars);
1105 }
1106
1107 #endregion
1108
1109 #region Provider specific functions
1110
1111 [SqlFunction]
1112 static int? ConvertToCaseCompareTo(string str, string value)
1113 {
1114 return str == null || value == null ? (int?)null : str.CompareTo(value);
1115 }
1116
1117 // Access, DB2, Firebird, Informix, MySql, Oracle, PostgreSQL, SQLite
1118 //
1119 [SqlFunction]
1120 static string AltStuff(string str, int? startLocation, int? length, string value)
1121 {
1122 return Sql.Stuff(str, startLocation, length, value);
1123 }
1124
1125 // DB2
1126 //
1127 [SqlFunction]
1128 static string VarChar(object obj, int? size)
1129 {
1130 return obj.ToString();
1131 }
1132
1133 // DB2
1134 //
1135 [SqlFunction]
1136 static string Hex(Guid? guid)
1137 {
1138 return guid == null ? null : guid.ToString();
1139 }
1140
1141 #pragma warning disable 3019
1142
1143 // DB2, PostgreSQL, Access, MS SQL, SqlCe
1144 //
1145 [CLSCompliant(false)]
1146 [SqlFunction]
1147 [SqlFunction("DB2", "Repeat")]
1148 [SqlFunction("PostgreSQL", "Repeat")]
1149 [SqlFunction("Access", "String", 1, 0)]
1150 static string Replicate(string str, int? count)
1151 {
1152 if (str == null || count == null)
1153 return null;
1154
1155 var sb = new StringBuilder(str.Length * count.Value);
1156
1157 for (var i = 0; i < count; i++)
1158 sb.Append(str);
1159
1160 return sb.ToString();
1161 }
1162
1163 [CLSCompliant(false)]
1164 [SqlFunction]
1165 [SqlFunction("DB2", "Repeat")]
1166 [SqlFunction("PostgreSQL", "Repeat")]
1167 [SqlFunction("Access", "String", 1, 0)]
1168 static string Replicate(char? ch, int? count)
1169 {
1170 if (ch == null || count == null)
1171 return null;
1172
1173 var sb = new StringBuilder(count.Value);
1174
1175 for (var i = 0; i < count; i++)
1176 sb.Append(ch);
1177
1178 return sb.ToString();
1179 }
1180
1181 // MSSQL
1182 //
1183 [SqlFunction]
1184 static DateTime? DateAdd(Sql.DateParts part, int? number, int? days)
1185 {
1186 return days == null ? null : Sql.DateAdd(part, number, new DateTime(1900, 1, days.Value + 1));
1187 }
1188
1189 // MSSQL
1190 //
1191 [SqlFunction] static Decimal? Round(Decimal? value, int precision, int mode) { return 0; }
1192 [SqlFunction] static Double? Round(Double? value, int precision, int mode) { return 0; }
1193
1194 // Access
1195 //
1196 [SqlFunction("Access", "DateSerial")]
1197 static DateTime? MakeDateTime2(int? year, int? month, int? day)
1198 {
1199 return year == null || month == null || day == null?
1200 (DateTime?)null :
1201 new DateTime(year.Value, month.Value, day.Value);
1202 }
1203
1204 // Access
1205 //
1206 [CLSCompliant(false)]
1207 [SqlFunction("Int", 0)]
1208 static T AccessInt<T>(T value)
1209 {
1210 return value;
1211 }
1212
1213 // Access
1214 //
1215 [CLSCompliant(false)]
1216 [SqlFunction("Round", 0, 1)]
1217 static T AccessRound<T>(T value, int? precision) { return value; }
1218
1219 // Firebird
1220 //
1221 [SqlFunction("PI", ServerSideOnly = true)] static decimal DecimalPI() { return (decimal)Math.PI; }
1222 [SqlFunction("PI", ServerSideOnly = true)] static double DoublePI () { return Math.PI; }
1223
1224 // Informix
1225 //
1226 [SqlFunction]
1227 static DateTime? Mdy(int? month, int? day, int? year)
1228 {
1229 return year == null || month == null || day == null ?
1230 (DateTime?)null :
1231 new DateTime(year.Value, month.Value, day.Value);
1232 }
1233
1234 #endregion
1235
1236 #endregion
1237 }
1238 }