Mercurial > pub > bltoolkit

comparison Tools/DocGen/Content/Doc/Data/LinqSqlTransformations.txt @ 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 * DB2
2 | SELECT x | db.Select(() => x) | #sql SELECT x \nFROM SYSIBM.SYSDUMMY1 \nFETCH FIRST 1 ROW ONLY
3 | TAKE x | query.Take(x) | #sql ... FETCH FIRST x ROWS ONLY
4
5 * Informix
6 | SELECT x | db.Select(() => x) | #sql SELECT FIRST 1 x\nFROM SYSTABLES
7 | TAKE x | query.Take(x) | #sql SELECT FIRST x
8
9 * Oracle
10 | SELECT x | db.Select(() => x) | #sql SELECT x \nFROM SYS.DUAL
11 | TAKE x | query.Take(x) | #sql ... WHERE rownum <= x
12
13 * Firebird
14 | SELECT x | db.Select(() => x) | #sql SELECT x \nFROM rdb$database
15 | TAKE x | query.Take(x) | #sql SELECT FIRST x
16
17 * PostgreSQL
18 | SELECT x | db.Select(() => x) | #sql SELECT x
19 | TAKE x | query.Take(x) | #sql ... LIMIT x
20
21 * MySql
22 | SELECT x | db.Select(() => x) | #sql SELECT x
23 | TAKE x | query.Take(x) | #sql ... LIMIT x
24
25 * MS SQL
26 | SELECT x | db.Select(() => x) | #sql SELECT x
27 | TAKE x | query.Take(x) | #sql SELECT TOP x
28
29 * SqlCe
30 | SELECT x | db.Select(() => x) | #sql SELECT x
31
32 * Sybase
33 | SELECT x | db.Select(() => x) | #sql SELECT x
34 | TAKE x | query.Take(x) | #sql SELECT TOP x
35
36 * SQLite
37 | SELECT x | db.Select(() => x) | #sql SELECT x
38 | TAKE x | query.Take(x) | #sql ... LIMIT x
39
40 * Access
41 | SELECT x | db.Select(() => x) | #sql SELECT x
42 | TAKE x | query.Take(x) | #sql SELECT TOP x