view Tools/DocGen/Content/Doc/Data/LinqOperators.txt @ 9:1e85f66cf767 default tip

update bltoolkit
author nickolay
date Thu, 05 Apr 2018 20:53:26 +0300
parents f990fcb411a9
children
line wrap: on
line source

* 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