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.v24.1.dll

NuGet Packages: DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap, DevExpress.Xpo

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)