Knight Data Access Layer
LoadPage<T>(String,Dictionary<String,Object>,String,Int32,Int32,Boolean) Method




KellermanSoftware.NetDataAccessLayer Namespace > IObjectCrud Interface > LoadPage Method : LoadPage<T>(String,Dictionary<String,Object>,String,Int32,Int32,Boolean) Method
Generic class type
A SQL where clause
The parameters to use for the where clause
Order by SQL Clause
Page of records starting at 1
The number of records to get per page
If true, load the children
Load a page of records that are filtered by a where clause and ordered and children are specified
Syntax
Overloads Function LoadPage(Of T As {Class, New})( _
   ByVal whereClause As String, _
   ByVal parameters As Dictionary(Of String,Object), _
   ByVal orderBy As String, _
   ByVal page As Integer, _
   ByVal pageSize As Integer, _
   ByVal loadChildren As Boolean _
) As List(Of T)
Dim instance As IObjectCrud
Dim whereClause As String
Dim parameters As Dictionary(Of String,Object)
Dim orderBy As String
Dim page As Integer
Dim pageSize As Integer
Dim loadChildren As Boolean
Dim value As List(Of T)
 
value = instance.LoadPage(Of T)(whereClause, parameters, orderBy, page, pageSize, loadChildren)
List<T> LoadPage<T>( 
   string whereClause,
   Dictionary<string,object> parameters,
   string orderBy,
   int page,
   int pageSize,
   bool loadChildren
)
where T: class, new()
List<T*>* LoadPage<T>( 
   string* whereClause,
   Dictionary<string*,Object*>* parameters,
   string* orderBy,
   int page,
   int pageSize,
   bool loadChildren
) 
where T: ref class, gcnew()
List<T^>^ LoadPagegeneric<typename T>
( 
   String^ whereClause,
   Dictionary<String^,Object^>^ parameters,
   String^ orderBy,
   int page,
   int pageSize,
   bool loadChildren
) 
where T: ref class, gcnew()

Parameters

whereClause
A SQL where clause
parameters
The parameters to use for the where clause
orderBy
Order by SQL Clause
page
Page of records starting at 1
pageSize
The number of records to get per page
loadChildren
If true, load the children

Type Parameters

T
Generic class type
Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

Reference

IObjectCrud Interface
IObjectCrud Members
Overload List