 | Sql |
Represents features of SQL engine
Namespace: SanteDB.OrmLite.Providers
Assembly: SanteDB.OrmLite (in SanteDB.OrmLite.dll) Version: 3.0.2081-alpha+d0a78774d3f97b9193d2ae2fef6d129ea9f29519
SyntaxMembers| Member name | Value | Description |
|---|---|---|
| None | 0 | The sql engine has no features |
| ReturnedInsertsAsReader | 1 | The sql engine returns the INSERT A RETURNING B as a data reader |
| AutoGenerateGuids | 2 | The sql engine can auto-generate UUIDS when the AutoGeneratedAttribute is on a colum |
| AutoGenerateTimestamps | 4 | The sql engine can auto-generate TIMESTAMPS when the AutoGeneratedAttribute is on a DateTimeOffset column |
| LimitOffset | 8 | The sql engine uses standard OFFSET X ROWS LIMIT Y ROWS syntax |
| FetchOffset | 16 | The sql engine uses FETCH FIRST X ROWS ONLY LIMIT Y ROWS syntax |
| ReturnedInsertsAsParms | 32 | The sql engine returns the INSERT A RETURNING B as a series of output parameters |
| StrictSubQueryColumnNames | 64 | The sql engine is strict about sub-query column names |
| MustNameSubQuery | 128 | The sql engine requires that sub-queries have names |
| SetTimeout | 256 | The sql engine supports the SET TIMEOUT option |
| ReturnedUpdatesAsReader | 512 | The sql egine supports updates as a reader |
| MaterializedViews | 1,024 | The sql engine supports materialized views |
| AutoGenerateSequences | 2,048 | The SQL engine can auto-generate columns with AutoGeneratedAttribute of type int (sequences) |
| Truncate | 4,096 | The SQL engine supports the TRUNCATE command |
| Cascades | 8,192 | The SQL engine supports TRUNCATE X CASCADE or DELETE FROM X CASCADE syntax |
| StoredFreetextIndex | 16,384 | The SQL engine requires manual intervention of the freetext index |
| AuditGeneratePrimaryKeySequences | 32,768 | Can generate primary key sequences |
See Also