Provides pivot data operations for IQueryable data sources using LINQ expressions. This data provider enables pivot operations on in-memory collections, Entity Framework contexts, and other LINQ-compatible data sources with support for dynamic grouping, filtering, and aggregation.
Definition
Namespace:Telerik.Pivot.Queryable
Assembly:Telerik.WinControls.PivotGrid.dll
Syntax:
public class QueryableDataProvider : DataProviderBase, IDataProvider, INotifyPropertyChanged, ISupportInitializeInheritance: objectDataProviderBaseQueryableDataProvider
Implements:
Inherited Members
Constructors
Initializes a new instance of the QueryableDataProvider class with default pivot engine. Sets up the provider for processing IQueryable data sources with LINQ-based pivot operations.
public QueryableDataProvider()Properties
Gets a collection of QueryableAggregateDescriptionBase objects that specify how data should be aggregated within the intersection of row and column groups. These define the calculated values displayed in pivot cells using LINQ aggregate functions.
public Collection<QueryableAggregateDescriptionBase> AggregateDescriptions { get; }Gets a collection of CalculatedField objects that define calculated aggregate values. Calculated fields allow creating custom expressions and formulas that can be used as aggregate values in the pivot.
public Collection<CalculatedField> CalculatedFields { get; }Gets a collection of QueryableGroupDescription objects that specify how the pivot data should be grouped by columns. Column groupings create the hierarchical structure displayed at the top of the pivot grid using LINQ expressions.
public Collection<QueryableGroupDescription> ColumnGroupDescriptions { get; }Gets or sets the CultureInfo used for grouping, formatting, and date/time operations. This culture affects how data is grouped and displayed in different locales.
public CultureInfo Culture { get; set; }Gets a collection of QueryableFilterDescription objects that specify how pivot items should be filtered. Filters are applied to the IQueryable source before grouping and aggregation operations are performed.
public Collection<QueryableFilterDescription> FilterDescriptions { get; }Results
IPivotResults
Gets the current pivot calculation results containing the processed data from the IQueryable source. This property provides access to the aggregated and grouped data ready for display in pivot controls.
protected override IPivotResults Results { get; }Overrides:
Gets a collection of QueryableGroupDescription objects that specify how the pivot data should be grouped by rows. Row groupings create the hierarchical structure displayed on the left side of the pivot grid using LINQ expressions.
public Collection<QueryableGroupDescription> RowGroupDescriptions { get; }Gets or sets the IQueryable data source for pivot operations. This can be any IQueryable implementation including LINQ to Objects collections, Entity Framework contexts, or other LINQ providers that support the required query operations.
public IQueryable Source { get; set; }Gets the current state object representing the IQueryable source for this data provider. This state is used for field description retrieval and connection management.
public override object State { get; }The Source object representing the current provider state.
Overrides:
Methods
Blocks the calling thread until the current refresh operation completes. For queryable data provider, this waits for the parallel processing engine to complete all operations.
public override void BlockUntilRefreshCompletes()Overrides:
Creates a field description provider for retrieving metadata and field information from the IQueryable data source. This provider is used to discover available properties and their types in the source data.
protected override IFieldDescriptionProvider CreateFieldDescriptionsProvider()A new QueryableFieldDescriptionsProvider instance for analyzing the queryable source.
Overrides:
Creates an aggregate description for the specified field that can be used in queryable pivot operations. The description is configured based on the field type, using appropriate aggregate functions for numeric vs non-numeric data.
protected override IAggregateDescription GetAggregateDescriptionForFieldDescriptionCore(IPivotFieldInfo description)The pivot field information to create an aggregate description for.
Returns:A QueryableAggregateDescriptionBase configured for the specified field.
Exceptions:Thrown when description is null.
Overrides:
Creates a filter description for the specified field that can be used in queryable pivot filtering operations. The description is configured with the field name for property-based filtering using LINQ expressions.
protected override FilterDescription GetFilterDescriptionForFieldDescriptionCore(IPivotFieldInfo description)The pivot field information to create a filter description for.
Returns:A QueryablePropertyFilterDescription configured for the specified field.
Exceptions:Thrown when description is null.
Overrides:
Creates a group description for the specified field that can be used in queryable pivot grouping operations. The description type is chosen based on the field data type, supporting numeric ranges, date/time steps, and property grouping.
protected override IGroupDescription GetGroupDescriptionForFieldDescriptionCore(IPivotFieldInfo description)The pivot field information to create a group description for.
Returns:A QueryableGroupDescription configured for the specified field type.
Exceptions:Thrown when description is null.
Overrides:
Performs the core refresh operation by generating LINQ queries, executing them against the IQueryable source, and processing the results. This method handles field initialization, query generation, and result processing.
protected override void RefreshOverride()Overrides: