Knight Data Access Layer
BuildTopRecordsSql Method (PostgreSqlProvider)




KellermanSoftware.NetDataAccessLayer.Providers Namespace > PostgreSqlProvider Class : BuildTopRecordsSql Method
Name of the table.
The where clause.
The order by clause.
The maximum records.
Builds the top records SQL.
Syntax
Protected Overrides Function BuildTopRecordsSql( _
   ByVal tableName As String, _
   ByVal whereClause As String, _
   ByVal orderByClause As String, _
   ByVal maxRecords As Integer _
) As String
Dim instance As PostgreSqlProvider
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 override string BuildTopRecordsSql( 
   string tableName,
   string whereClause,
   string orderByClause,
   int maxRecords
)
protected: string* BuildTopRecordsSql( 
   string* tableName,
   string* whereClause,
   string* orderByClause,
   int maxRecords
) override 
protected:
String^ BuildTopRecordsSql( 
   String^ tableName,
   String^ whereClause,
   String^ orderByClause,
   int maxRecords
) override 

Parameters

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

Return Value

SQL string
Remarks
This is overridden due to PostgreSQL not supporting square brackets
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

PostgreSqlProvider Class
PostgreSqlProvider Members