VistaDB

Versions

Although VistaDB 3 capability still exists in LightSpeed 4, it is deprecated, and may be removed in a future release.  We advise customers using VistaDB 3 to upgrade to VistaDB 4 if possible.

Paging and Ordering

VistaDB does not support paging, except for the specific case of limiting.  (That is, you can use the Take operator, but not the Skip operator.)  In addition, VistaDB does not support expressions in an OrderBy clause: you can order only by primitive properties, not computed expressions or properties of associated entities.

LINQ Support

There are several engine limitations which can affect complex LINQ queries, specifically around joining, grouping, composition (e.g. Intersect), subselects and the Distinct operator.

Tools Support

The designer does not currently support dragging views from VistaDB.

Migrations have only limited support on VistaDB.