Class QueryableOperation

DataOperation class that performs data operation in IQueryable type data sources.

Inheritance

System.Object

QueryableOperation

Namespace: Syncfusion.Blazor.Data

Assembly: Syncfusion.Blazor.dll

Syntax

public static class QueryableOperation : Object

Methods

Execute<T>(IQueryable<T>, DataManagerRequest)

Executes the query against the given data source and returns the resultant records.

Declaration

public static IQueryable<T> Execute<T>(IQueryable<T> dataSource, DataManagerRequest manager)

Parameters

Type	Name	Description
System.Linq.IQueryable<T>	dataSource	Input data source against which the query to be executed.
DataManagerRequest	manager	Query to be executed.

Returns

Type	Description
System.Linq.IQueryable<T>	IQueryable - resultant records.

Type Parameters

Name
T

PerformFiltering<T>(IQueryable<T>, List<WhereFilter>, String)

Apply the given filter criteria against the data source and returns the filtered records.

Declaration

public static IQueryable<T> PerformFiltering<T>(IQueryable<T> dataSource, List<WhereFilter> whereFilter, string condition)

Parameters

Type	Name	Description
System.Linq.IQueryable<T>	dataSource	Data source to be filtered.
System.Collections.Generic.List<WhereFilter>	whereFilter	List of filter criteria.
System.String	condition	Filter merge condition. Value can be either AND or OR.

Returns

Type	Description
System.Linq.IQueryable<T>	IQueryable - filtered records.

Type Parameters

Name
T

PerformGrouping<T>(IQueryable<T>, List<String>)

Groups data source by the given list of column names.

Declaration

public static IQueryable PerformGrouping<T>(IQueryable<T> dataSource, List<string> grouped)

Parameters

Type	Name	Description
System.Linq.IQueryable<T>	dataSource	Input data source to be grouped.
System.Collections.Generic.List<System.String>	grouped	List of column names by which rows will be grouped.

Returns

Type	Description
System.Linq.IQueryable	IQueryable.

Type Parameters

Name
T

PerformSearching<T>(IQueryable<T>, List<SearchFilter>)

Apply the given search criteria against the data source and returns the filtered records.

Declaration

public static IQueryable<T> PerformSearching<T>(IQueryable<T> dataSource, List<SearchFilter> searchFilter)

Parameters

Type	Name	Description
System.Linq.IQueryable<T>	dataSource	Data source to be filtered.
System.Collections.Generic.List<SearchFilter>	searchFilter	List of search criteria.

Returns

Type	Description
System.Linq.IQueryable<T>	IQueryable - searched records.

Type Parameters

Name
T

PerformSelect(IQueryable, List<String>)

Selects the fields from data source.

Declaration

public static IQueryable PerformSelect(IQueryable dataSource, List<string> select)

Parameters

Type	Name	Description
System.Linq.IQueryable	dataSource	Input data source.
System.Collections.Generic.List<System.String>	select	Fields to select.

Returns

Type
System.Linq.IQueryable

PerformSelect<T>(IQueryable, List<String>)

Selects the fields from data source.

Declaration

public static IQueryable PerformSelect<T>(IQueryable dataSource, List<string> select)

Parameters

Type	Name	Description
System.Linq.IQueryable	dataSource	Input data source.
System.Collections.Generic.List<System.String>	select	Fields to select.

Returns

Type
System.Linq.IQueryable

Type Parameters

Name	Description
T	Type of the data source elements.

PerformSkip<T>(IQueryable<T>, Int32)

Skip the given number of records from data source and returns the resultant records.

Declaration

public static IQueryable<T> PerformSkip<T>(IQueryable<T> dataSource, int skip)

Parameters

Type	Name	Description
System.Linq.IQueryable<T>	dataSource	Input data source.
System.Int32	skip	Number of records to be skipped.

Returns

Type	Description
System.Linq.IQueryable<T>	IQueryable.

Type Parameters

Name
T

PerformSorting<T>(IQueryable<T>, List<Sort>)

Sorts the data source using the given sort descriptor and returns the sorted records.

Declaration

public static IQueryable<T> PerformSorting<T>(IQueryable<T> dataSource, List<Sort> sortColumns)

Parameters

Type	Name	Description
System.Linq.IQueryable<T>	dataSource	Data source to be sorted.
System.Collections.Generic.List<Sort>	sortColumns	List of sort criteria.

Returns

Type	Description
System.Linq.IQueryable<T>	IQueryable - sorted records.

Type Parameters

Name
T

PerformSorting<T>(IQueryable<T>, List<SortedColumn>)

Sorts the data source using the given sort descriptor and returns the sorted records.

Declaration

public static IQueryable<T> PerformSorting<T>(IQueryable<T> dataSource, List<SortedColumn> sortedColumns)

Parameters

Type	Name	Description
System.Linq.IQueryable<T>	dataSource	Data source to be sorted.
System.Collections.Generic.List<SortedColumn>	sortedColumns	List of sort criteria.

Returns

Type	Description
System.Linq.IQueryable<T>	IQueryable - sorted records.

Type Parameters

Name
T

PerformTake<T>(IQueryable<T>, Int32)

Take the given number of records from data source.

Declaration

public static IQueryable<T> PerformTake<T>(IQueryable<T> dataSource, int take)

Parameters

Type	Name	Description
System.Linq.IQueryable<T>	dataSource	Input data source.
System.Int32	take	Number of records to be taken.

Returns

Type	Description
System.Linq.IQueryable<T>	IQueryable.

Type Parameters

Name
T