MSSqlConnectionProvider.FormatSelect(String, String, String, String, String, String, Int32, Int32) Method

This member supports the internal infrastructure and is not intended to be used directly from your code.

Namespace: DevExpress.Xpo.DB

Assembly: DevExpress.Xpo.v21.1.dll

NuGet Package: DevExpress.Xpo

Declaration

C#

public override string FormatSelect(
    string selectedPropertiesSql,
    string fromSql,
    string whereSql,
    string orderBySql,
    string groupBySql,
    string havingSql,
    int skipSelectedRecords,
    int topSelectedRecords
)

VB.NET

Public Overrides Function FormatSelect(
    selectedPropertiesSql As String,
    fromSql As String,
    whereSql As String,
    orderBySql As String,
    groupBySql As String,
    havingSql As String,
    skipSelectedRecords As Integer,
    topSelectedRecords As Integer
) As String

Parameters

Name	Type
selectedPropertiesSql	String
fromSql	String
whereSql	String
orderBySql	String
groupBySql	String
havingSql	String
skipSelectedRecords	Int32
topSelectedRecords	Int32

Returns

Type
String

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the FormatSelect(String, String, String, String, String, String, Int32, Int32) method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

XPO_how-to-use-custom-sql-queries-as-a-data-source-in-xpo-via-common-table-expressions-cte-e3468/CS/S138124/MsSqlWithCte.cs#L77

public override string FormatSelect(string selectedPropertiesSql, string fromSql, string whereSql, string orderBySql, string groupBySql, string havingSql, int skipSelectedRecords, int topSelectedRecords) {
    string selectBody = base.FormatSelect(selectedPropertiesSql, fromSql, whereSql, orderBySql, groupBySql, havingSql, skipSelectedRecords, topSelectedRecords);
    if(usedCtes == null || usedCtes.Count == 0)

VB.NET

XPO_how-to-use-custom-sql-queries-as-a-data-source-in-xpo-via-common-table-expressions-cte-e3468/VB/S138124/MsSqlWithCte.vb#L84

Public Overrides Function FormatSelect(ByVal selectedPropertiesSql As String, ByVal fromSql As String, ByVal whereSql As String, ByVal orderBySql As String, ByVal groupBySql As String, ByVal havingSql As String, ByVal skipSelectedRecords As Integer, ByVal topSelectedRecords As Integer) As String
    Dim selectBody As String = MyBase.FormatSelect(selectedPropertiesSql, fromSql, whereSql, orderBySql, groupBySql, havingSql, skipSelectedRecords, topSelectedRecords)
    If usedCtes Is Nothing OrElse usedCtes.Count = 0 Then