view 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 source

* 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