Getting Data from Tables and Views

SaveToDB products support connecting to tables and views from the box.

A set of selected columns depends on the applied data provider.

For example, older OLEDB and ODBC drivers may not support new data types.

Users can choose columns to select and use as filters.

Developers can define columns used as filters using the ParameterValues event type in the xls.handlers table.

This feature is useful for large tables to allow loading fewer data using indexed columns.

DBGate and ODataDB support paging for tables and views automatically.

ODataDB publishes tables and views as EntitySets.

If a table or view has no primary keys or, at least, the identity column, ODataDB creates a row number column used as a surrogate key for paging and marks the EntitySet read-only.