Name | Description | |
---|---|---|
![]() | DbCommandSetDataProvider Constructor | Initializes a new instance of the data provider. |
The following tables list the members exposed by DbCommandSetDataProvider.
Name | Description | |
---|---|---|
![]() | DbCommandSetDataProvider Constructor | Initializes a new instance of the data provider. |
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. |
Name | Description | |
---|---|---|
![]() | AddCommand | Overloaded. Adds a command to the provider, resulting in an additional table in the Designer. |
![]() | AddRelation | Adds a relation between two commands/tables. |
![]() | Dispose | |
![]() | SetLogger | Allows to override the default debug logger. |
Name | Description | |
---|---|---|
![]() | ExecuteDbCommand | This event allows to edit the DbCommand before it is executed on the database. |
![]() | TranslateFilterSyntax | This event can be used to override the default filter syntax translation. It is called before the filter gets translated by List & Label. If the Result property is set to null, the default translation will be carried out. Otherwise, the result will be used as translation. See also IAdvancedFiltering Interface. |