combit List & Label 29 - .NET Help
combit.Reporting.DataProviders Namespace / DbCommandSetDataProvider Class
Properties Methods Events

In This Topic
    DbCommandSetDataProvider Class Members
    In This Topic

    The following tables list the members exposed by DbCommandSetDataProvider.

    Public Constructors
     NameDescription
    Public ConstructorInitializes a new instance of the data provider.  
    Top
    Public Properties
     NameDescription
    Public PropertyGets or sets if the key field lookup is performed case sensitive.  
    Public Property

    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.

     
    Public Property

    If the property is set to true, the schema name of the table is prefixed with the table name to be declared. (Default: false)

     
    Public Property  
    Public PropertyGets 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.  
    Public PropertyGets 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.  
    Public PropertyA 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)  
    Public PropertyGets 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.  
    Public Property

    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.

     
    Top
    Public Methods
     NameDescription
    Public MethodOverloaded. Adds a command to the provider, resulting in an additional table in the Designer.  
    Public Method

    Adds a relation between two commands/tables.

     
    Public Method  
    Public Method

    Allows to override the default debug logger.

     
    Top
    Public Events
     NameDescription
    Public EventThis event allows to edit the DbCommand before it is executed on the database.  
    Public Event

    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.

     
    Top
    See Also