diff Tools/DocGen/Content/Doc/Data/LinqSqlTransformations.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/LinqSqlTransformations.txt	Thu Mar 27 21:46:09 2014 +0400
@@ -0,0 +1,42 @@
+* DB2
+| SELECT x | db.Select(() => x) | #sql SELECT x \nFROM SYSIBM.SYSDUMMY1 \nFETCH FIRST 1 ROW ONLY
+| TAKE x   | query.Take(x)      | #sql ... FETCH FIRST x ROWS ONLY
+
+* Informix
+| SELECT x | db.Select(() => x) | #sql SELECT FIRST 1 x\nFROM SYSTABLES
+| TAKE x   | query.Take(x)      | #sql SELECT FIRST x
+
+* Oracle
+| SELECT x | db.Select(() => x) | #sql SELECT x \nFROM SYS.DUAL
+| TAKE x   | query.Take(x)      | #sql ... WHERE rownum <= x
+
+* Firebird
+| SELECT x | db.Select(() => x) | #sql SELECT x \nFROM rdb$database
+| TAKE x   | query.Take(x)      | #sql SELECT FIRST x
+
+* PostgreSQL
+| SELECT x | db.Select(() => x) | #sql SELECT x
+| TAKE x   | query.Take(x)      | #sql ... LIMIT x
+
+* MySql
+| SELECT x | db.Select(() => x) | #sql SELECT x
+| TAKE x   | query.Take(x)      | #sql ... LIMIT x
+
+* MS SQL
+| SELECT x | db.Select(() => x) | #sql SELECT x
+| TAKE x   | query.Take(x)      | #sql SELECT TOP x
+
+* SqlCe
+| SELECT x | db.Select(() => x) | #sql SELECT x
+
+* Sybase
+| SELECT x | db.Select(() => x) | #sql SELECT x
+| TAKE x   | query.Take(x)      | #sql SELECT TOP x
+
+* SQLite
+| SELECT x | db.Select(() => x) | #sql SELECT x
+| TAKE x   | query.Take(x)      | #sql ... LIMIT x
+
+* Access
+| SELECT x | db.Select(() => x) | #sql SELECT x
+| TAKE x   | query.Take(x)      | #sql SELECT TOP x