Loads specified number of entities of type EntityType, filtered by criteria given a sort order and a page number.
Namespace: Aspectize.CoreAssembly: AspectizeDAL (in AspectizeDAL.dll) Version: 1.0.0.0 (1.0.0.0)
Syntax
| C# |
|---|
void LoadEntitiesByPage<EntityType>( int pageNumber, int rowsPerPage, IEnumerable<SortCriteria> sortCriterias, QueryCriteria criteria ) where EntityType : new(), Entity, IEntity, IDataWrapper |
| Visual Basic |
|---|
Sub LoadEntitiesByPage(Of EntityType As {New, Entity, IEntity, IDataWrapper}) ( _ pageNumber As Integer, _ rowsPerPage As Integer, _ sortCriterias As IEnumerable(Of SortCriteria), _ criteria As QueryCriteria _ ) |
Parameters
- pageNumber
- Type: System..::..Int32
The given page number starting at 1.
- rowsPerPage
- Type: System..::..Int32
The specified number of entities.
- sortCriterias
- Type: System.Collections.Generic..::..IEnumerable<(Of <(<'SortCriteria>)>)>
The given sort order (sequence of column name and direction).
- criteria
- Type: Aspectize.Core..::..QueryCriteria
The critiria to meet.
Type Parameters
- EntityType
- Type of Entity to load
Examples
List<SortCriteria> sortCriterias = new List<SortCriteria>(); sortCriterias.Add(new SortCriteria(AdventureWorks.Production.Product.Fields.Name, Order.Asc)); QueryCriteria queryCriteria = new QueryCriteria(AdventureWorks.Production.Product.Fields.ListPrice, ComparisonOperator.LessThan, 10000); dm.LoadEntitiesByPage<AdventureWorks.Production.Product>(8, 7, sortCriterias, queryCriteria);
Dim sortCriterias As List(Of SortCriteria) = New List(Of SortCriteria)() sortCriterias.Add(New SortCriteria(AdventureWorks.Production.Product.Fields.Name, Order.Asc)) Dim queryCriteria As QueryCriteria = New QueryCriteria(AdventureWorks.Production.Product.Fields.ListPrice, ComparisonOperator.LessThan, 10000) dm.LoadEntitiesByPage(Of AdventureWorks.Production.Product)(8, 7, sortCriterias, queryCriteria)