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




KellermanSoftware.NetDataAccessLayer Namespace > ObjectCrud Class > LoadTop Method : LoadTop<T>(String,Dictionary<String,Object>,String,Int32) Method
Generic class type
A SQL where clause
Parameters for the where clause
Order by SQL Clause
Number of records to retrieve
Load Top N Records filtered by a Where clause that are ordered
Syntax
Public Overloads Function LoadTop(Of T As {Class, New})( _
   ByVal whereClause As String, _
   ByVal parameters As Dictionary(Of String,Object), _
   ByVal orderBy As String, _
   ByVal records As Integer _
) As List(Of T)
Dim instance As ObjectCrud
Dim whereClause As String
Dim parameters As Dictionary(Of String,Object)
Dim orderBy As String
Dim records As Integer
Dim value As List(Of T)
 
value = instance.LoadTop(Of T)(whereClause, parameters, orderBy, records)
public List<T> LoadTop<T>( 
   string whereClause,
   Dictionary<string,object> parameters,
   string orderBy,
   int records
)
where T: class, new()
public: List<T*>* LoadTop<T>( 
   string* whereClause,
   Dictionary<string*,Object*>* parameters,
   string* orderBy,
   int records
) 
where T: ref class, gcnew()
public:
List<T^>^ LoadTopgeneric<typename T>
( 
   String^ whereClause,
   Dictionary<String^,Object^>^ parameters,
   String^ orderBy,
   int records
) 
where T: ref class, gcnew()

Parameters

whereClause
A SQL where clause
parameters
Parameters for the where clause
orderBy
Order by SQL Clause
records
Number of records to retrieve

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

ObjectCrud Class
ObjectCrud Members
Overload List