view Tools/DocGen/Content/Doc/Data/LinqSqlTransformations.txt @ 1:8f65451dc28f

Исправлена проблема с фабрикой и выборкой нескольких объектов в linq выражении
author cin
date Fri, 28 Mar 2014 01:04:56 +0400
parents f990fcb411a9
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