Getting Data from Tables and Views

SaveToDB products can connect to tables and views out of the box.

The set of selected columns depends on the data provider in use. For instance, older OLEDB and ODBC drivers may not support newer data types.

Users can select columns to retrieve and apply as filters. Developers can define these filter columns using the ParameterValues event type in the xls.handlers table. This feature is particularly useful for large tables, as it allows for loading less data by utilizing indexed columns.

Both DBGate and ODataDB automatically support paging for tables and views.

ODataDB exposes tables and views as EntitySets. If a table or view lacks primary keys or at least an identity column, ODataDB generates a row number column to serve as a surrogate key for paging and marks the EntitySet as read-only.