Name | Description | |
---|---|---|
![]() | CancelBeforeClose | |
![]() | 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. |
![]() | Support1to1Sortings | |
![]() | 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. |
![]() | SupportsAdvancedFiltering | Gets or sets if advanced filtering can be supported. If set to true, the default handling will be used to translate filter expressions to database queries. Depending on the database system, you may need to adapt the queries that are generated. Override the OnTranslateFilterSyntax in order to customize the queries. If you're working with one of the DbConnectionDataProvider descendants, you can also use the TranslateFilterSyntax Event for a fine tuning. If you're not sure what to do you should leave this property at its default value or - if you're inheriting from DbConnectionDataProvider - implement a getter that always returns 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. |