| Name | Description | |
|---|---|---|
 | CaseSensitive | Gets or sets if the key field lookup is performed case sensitive. |
| MinimalSelect | Gets or sets if the select statements should be adapted at print time to select only those fields actually required by the project. For performance reasons, this property should normally be left at it's default true. Please note that JOIN statements may generate ambiguous column names in the result set. Set this property to "False" if you receive "Ambiguous Column Name" exceptions. |
| PrefixTableNameWithSchema | If the property is set to true, the schema name of the table is prefixed with the table name to be declared. (Default: false) |
| Support1to1Sortings | |
| SupportGetCount | Gets or sets if the provider should support the Count Property and thus be able to display a progress bar at print time (default: true). Set it to false if performance and minimal server load has absolute priority for your application. |
| SupportGetParentRow | Gets or sets if the provider should support the GetParentRow Method. While doing so is the default, the Designer performance and experience for large databases with many fields and tables can be improved considerably by setting it to false. |
| SupportsAnyBaseTable | A provider can display if any base table is allowed in the Designer or if the hierarchy of data sources has to be maintained. (Default: False) |
| SupportSorting | Gets or sets if the provider should support the SetSortOrder Method. With this property set to default (true), an ascending and descending sorting for all fields will be offered. If you want to prevent the user from sorting (and save server load by not having to sort select results), set this property to false. |
| UseJoinsForParentRow | If set to true (default), 1:1 relations are queried using JOIN statements which yields a much better performance. Set to false for very complex statements. |