VistaDB 4
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.