Class PivotExtension

Represents the extension class for pivot operations.

Inheritance

System.Object

PivotExtension

Inherited Members

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: Syncfusion.Olap.Engine.Extension

Assembly: Syncfusion.Olap.Base.dll

Syntax

public static class PivotExtension

Methods

GroupBy(IEnumerable<DataRow>, Expression<Func<DataRow, Object>>[])

Groups by rows.

Declaration

public static IEnumerable<GroupResult> GroupBy(this IEnumerable<DataRow> rows, params Expression<Func<DataRow, object>>[] groupSelectors)

Parameters

Type	Name	Description
System.Collections.Generic.IEnumerable<System.Data.DataRow>	rows	The collection of rows.
System.Linq.Expressions.Expression<System.Func<System.Data.DataRow, System.Object>>[]	groupSelectors	The array of group selectors.

Returns

Type	Description
System.Collections.Generic.IEnumerable<GroupResult>	IEnumerable of group result.

GroupBy(DataTable, String[])

Groups by data table with properties.

Declaration

public static IEnumerable<GroupResult> GroupBy(this DataTable source, params string[] properties)

Parameters

Type	Name	Description
System.Data.DataTable	source	The source.
System.String[]	properties	The array of properties.

Returns

Type	Description
System.Collections.Generic.IEnumerable<GroupResult>	IEnumerable of group result.

GroupBy(IQueryable, String[])

Group by IQueryable source.

Declaration

public static IEnumerable<GroupResult> GroupBy(this IQueryable source, params string[] properties)

Parameters

Type	Name	Description
System.Linq.IQueryable	source	The source.
System.String[]	properties	The array of properties.

Returns

Type	Description
System.Collections.Generic.IEnumerable<GroupResult>	IEnumerable of group result.

GroupByMany(IQueryable, IEnumerable<String>)

Groups many elements to one group.

Declaration

public static IEnumerable<GroupResult> GroupByMany(this IQueryable source, IEnumerable<string> properties)

Parameters

Type	Name	Description
System.Linq.IQueryable	source	The source.
System.Collections.Generic.IEnumerable<System.String>	properties	The collection of properties.

Returns

Type	Description
System.Collections.Generic.IEnumerable<GroupResult>	IEnumerable of group result.

GroupByMany<TElement>(IEnumerable<TElement>, IEnumerable<Func<TElement, Object>>)

Groups many elements to one group.

Declaration

public static IEnumerable<GroupResult> GroupByMany<TElement>(this IEnumerable<TElement> elements, IEnumerable<Func<TElement, object>> groupSelectors)

Parameters

Type	Name	Description
System.Collections.Generic.IEnumerable<TElement>	elements	The collection of elements.
System.Collections.Generic.IEnumerable<System.Func<TElement, System.Object>>	groupSelectors	The group selectors.

Returns

Type	Description
System.Collections.Generic.IEnumerable<GroupResult>	IEnumerable of group result.

Type Parameters

Name	Description
TElement	The type of the element.

GroupByMany<TElement>(IEnumerable<TElement>, Int32, Func<TElement, Object>[])

Groups many elements to one group.

Declaration

public static IEnumerable<GroupResult> GroupByMany<TElement>(this IEnumerable<TElement> elements, int currentLevel, params Func<TElement, object>[] groupSelectors)

Parameters

Type	Name	Description
System.Collections.Generic.IEnumerable<TElement>	elements	The collection of elements.
System.Int32	currentLevel	The current level.
System.Func<TElement, System.Object>[]	groupSelectors	The group selectors.

Returns

Type	Description
System.Collections.Generic.IEnumerable<GroupResult>	IEnumerable of group result.

Type Parameters

Name	Description
TElement	The type of the element.