Knight Data Access Layer
LoadTop(String,String,Dictionary<String,Object>,String,Int32) Method




KellermanSoftware.NetDataAccessLayer Namespace > IDatabaseProvider Interface > LoadTop Method : LoadTop(String,String,Dictionary<String,Object>,String,Int32) Method
The name of the table
A SQL where clause
The parameters to use for the where clause
Order by SQL Clause
The maximum records to retrieve
Get a limited number of records for a table
Syntax
Overloads Function LoadTop( _
   ByVal tableName As String, _
   ByVal whereClause As String, _
   ByVal parameters As Dictionary(Of String,Object), _
   ByVal orderBy As String, _
   ByVal maxRecords As Integer _
) As List(Of Dictionary(Of String,Object))
Dim instance As IDatabaseProvider
Dim tableName As String
Dim whereClause As String
Dim parameters As Dictionary(Of String,Object)
Dim orderBy As String
Dim maxRecords As Integer
Dim value As List(Of Dictionary(Of String,Object))
 
value = instance.LoadTop(tableName, whereClause, parameters, orderBy, maxRecords)

Parameters

tableName
The name of the table
whereClause
A SQL where clause
parameters
The parameters to use for the where clause
orderBy
Order by SQL Clause
maxRecords
The maximum records to retrieve
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

IDatabaseProvider Interface
IDatabaseProvider Members
Overload List