diff Tools/DocGen/Content/Doc/Data/LinqOperators.txt @ 0:f990fcb411a9

Копия текущей версии из github
author cin
date Thu, 27 Mar 2014 21:46:09 +0400
parents
children
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/Tools/DocGen/Content/Doc/Data/LinqOperators.txt	Thu Mar 27 21:46:09 2014 +0400
@@ -0,0 +1,117 @@
+* DB2
+| Modulo        | a % b             | Mod(a, b)
+| Bitwise AND   | a & b             | BitAnd(a, b)
+| Bitwise OR    | a || b            | BitOr(a, b)
+| Bitwise XOR   | a ^ b             | BitXor(a, b)
+| Coalesce      | a ?? b            | Coalesce(a, b)
+| Coalesce      | a ?? b ?? c       | Coalesce(a, b, c)
+| Conditional   | a ? b : c         | CASE WHEN a THEN b ELSE c END
+| Conditional   | a ? b : c ? d : e | CASE WHEN a THEN b WHEN c THEN d ELSE e END
+| Concatenation | a + b + c         | a || b || c
+
+* Informix
+| Modulo        | a % b             | Mod(a, b)
+| Bitwise AND   | a & b             | BitAnd(a, b)
+| Bitwise OR    | a || b            | BitOr(a, b)
+| Bitwise XOR   | a ^ b             | BitXor(a, b)
+| Coalesce      | a ?? b            | Nvl(a, b)
+| Coalesce      | a ?? b ?? c       | Nvl(a, b, c)
+| Conditional   | a ? b : c         | CASE WHEN a THEN b ELSE c END
+| Conditional   | a ? b : c ? d : e | CASE WHEN a THEN b WHEN c THEN d ELSE e END
+| Concatenation | a + b + c         | a || b || c
+
+* Oracle
+| Modulo        | a % b             | Mod(a, b)
+| Bitwise AND   | a & b             | BitAnd(a, b)
+| Bitwise OR    | a || b            | (a + b) - BitAnd(a, b)
+| Bitwise XOR   | a ^ b             | (a + b) - BitAnd(a, b) * 2
+| Coalesce      | a ?? b            | Nvl(a, b)
+| Coalesce      | a ?? b ?? c       | Nvl(a, b, c)
+| Conditional   | a ? b : c         | CASE WHEN a THEN b ELSE c END
+| Conditional   | a ? b : c ? d : e | CASE WHEN a THEN b WHEN c THEN d ELSE e END
+| Concatenation | a + b + c         | a || b || c
+
+* Firebird
+| Modulo        | a % b             | Mod(a, b)
+| Bitwise AND   | a & b             | Bin_And(a, b)
+| Bitwise OR    | a || b            | Bin_Or(a, b)
+| Bitwise XOR   | a ^ b             | Bin_Xor(a, b)
+| Coalesce      | a ?? b            | Coalesce(a, b)
+| Coalesce      | a ?? b ?? c       | Coalesce(a, b, c)
+| Conditional   | a ? b : c         | CASE WHEN a THEN b ELSE c END
+| Conditional   | a ? b : c ? d : e | CASE WHEN a THEN b WHEN c THEN d ELSE e END
+| Concatenation | a + b + c         | a || b || c
+
+* PostgreSQL
+| Modulo        | a % b             | a % b
+| Bitwise AND   | a & b             | a & b
+| Bitwise OR    | a || b            | a || b
+| Bitwise XOR   | a ^ b             | a # b
+| Coalesce      | a ?? b            | Coalesce(a, b)
+| Coalesce      | a ?? b ?? c       | Coalesce(a, b, c)
+| Conditional   | a ? b : c         | CASE WHEN a THEN b ELSE c END
+| Conditional   | a ? b : c ? d : e | CASE WHEN a THEN b WHEN c THEN d ELSE e END
+| Concatenation | a + b + c         | a || b || c
+
+* MySql
+| Modulo        | a % b             | a % b
+| Bitwise AND   | a & b             | a & b
+| Bitwise OR    | a || b            | a || b
+| Bitwise XOR   | a ^ b             | a ^ b
+| Coalesce      | a ?? b            | Coalesce(a, b)
+| Coalesce      | a ?? b ?? c       | Coalesce(a, b, c)
+| Conditional   | a ? b : c         | CASE WHEN a THEN b ELSE c END
+| Conditional   | a ? b : c ? d : e | CASE WHEN a THEN b WHEN c THEN d ELSE e END
+| Concatenation | a + b + c         | Concat(a, b, c)
+
+* MS SQL
+| Modulo        | a % b             | a % b
+| Bitwise AND   | a & b             | a & b
+| Bitwise OR    | a || b            | a || b
+| Bitwise XOR   | a ^ b             | a ^ b
+| Coalesce      | a ?? b            | Coalesce(a, b)
+| Coalesce      | a ?? b ?? c       | Coalesce(a, b, c)
+| Conditional   | a ? b : c         | CASE WHEN a THEN b ELSE c END
+| Conditional   | a ? b : c ? d : e | CASE WHEN a THEN b WHEN c THEN d ELSE e END
+| Concatenation | a + b + c         | a + b + c
+
+* SqlCe
+| Modulo        | a % b             | a % b
+| Bitwise AND   | a & b             | a & b
+| Bitwise OR    | a || b            | a || b
+| Bitwise XOR   | a ^ b             | a ^ b
+| Coalesce      | a ?? b            | Coalesce(a, b)
+| Coalesce      | a ?? b ?? c       | Coalesce(a, b, c)
+| Conditional   | a ? b : c         | CASE WHEN a THEN b ELSE c END
+| Conditional   | a ? b : c ? d : e | CASE WHEN a THEN b WHEN c THEN d ELSE e END
+| Concatenation | a + b + c         | a + b + c
+
+* Sybase
+| Modulo        | a % b             | a % b
+| Bitwise AND   | a & b             | a & b
+| Bitwise OR    | a || b            | a || b
+| Bitwise XOR   | a ^ b             | a ^ b
+| Coalesce      | a ?? b            | Coalesce(a, b)
+| Coalesce      | a ?? b ?? c       | Coalesce(a, b, c)
+| Conditional   | a ? b : c         | CASE WHEN a THEN b ELSE c END
+| Conditional   | a ? b : c ? d : e | CASE WHEN a THEN b WHEN c THEN d ELSE e END
+| Concatenation | a + b + c         | a + b + c
+
+* SQLite
+| Modulo        | a % b             | a % b
+| Bitwise AND   | a & b             | a & b
+| Bitwise OR    | a || b            | a || b
+| Bitwise XOR   | a ^ b             | (a + b) - (a & b) * 2
+| Coalesce      | a ?? b            | Coalesce(a, b)
+| Coalesce      | a ?? b ?? c       | Coalesce(a, b, c)
+| Conditional   | a ? b : c         | CASE WHEN a THEN b ELSE c END
+| Conditional   | a ? b : c ? d : e | CASE WHEN a THEN b WHEN c THEN d ELSE e END
+| Concatenation | a + b + c         | a || b || c
+
+* Access
+| Modulo        | a % b             | a MOD b
+| Coalesce      | a ?? b            | Iif(a IS NULL, b, a)
+| Coalesce      | a ?? b ?? c       | Iif(a IS NULL, Iif(b IS NULL, c, b), a)
+| Conditional   | a ? b : c         | Iif(a, b, c)
+| Conditional   | a ? b : c ? d : e | Iif(a, b, Iif(c, d, e))
+| Concatenation | a + b + c         | a + b + c