Knight Data Access Layer
BuildTopRecordsSql Method (BaseDatabaseProvider)




KellermanSoftware.NetDataAccessLayer Namespace > BaseDatabaseProvider Class : BuildTopRecordsSql Method
Name of the table.
The where clause.
The order by clause.
The maximum records.
Builds the top records SQL.
Syntax
Protected Overridable Function BuildTopRecordsSql( _
   ByVal tableName As String, _
   ByVal whereClause As String, _
   ByVal orderByClause As String, _
   ByVal maxRecords As Integer _
) As String
Dim instance As BaseDatabaseProvider
Dim tableName As String
Dim whereClause As String
Dim orderByClause As String
Dim maxRecords As Integer
Dim value As String
 
value = instance.BuildTopRecordsSql(tableName, whereClause, orderByClause, maxRecords)
protected virtual string BuildTopRecordsSql( 
   string tableName,
   string whereClause,
   string orderByClause,
   int maxRecords
)
protected: virtual string* BuildTopRecordsSql( 
   string* tableName,
   string* whereClause,
   string* orderByClause,
   int maxRecords
) 
protected:
virtual String^ BuildTopRecordsSql( 
   String^ tableName,
   String^ whereClause,
   String^ orderByClause,
   int maxRecords
) 

Parameters

tableName
Name of the table.
whereClause
The where clause.
orderByClause
The order by clause.
maxRecords
The maximum records.

Return Value

SQL string
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

BaseDatabaseProvider Class
BaseDatabaseProvider Members