ContextQMD
Back to Devexpress

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

xpo-devexpress-dot-xpo-dot-db-dot-mssqlconnectionprovider-dot-formatselect-x28-system-dot-string-system-dot-string-system-dot-string-system-dot-string-system-dot-string-system-dot-string-system-dot-int32-system-dot-int32-x29.md

latest3.7 KB
Original Source

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.v25.2.dll

NuGet Package : DevExpress.Xpo

Declaration

csharp
public override string FormatSelect(
    string selectedPropertiesSql,
    string fromSql,
    string whereSql,
    string orderBySql,
    string groupBySql,
    string havingSql,
    int skipSelectedRecords,
    int topSelectedRecords
)
vb
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

NameType
selectedPropertiesSqlString
fromSqlString
whereSqlString
orderBySqlString
groupBySqlString
havingSqlString
skipSelectedRecordsInt32
topSelectedRecordsInt32

Returns

Type
String

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.

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

csharp
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)

See Also

MSSqlConnectionProvider Class

MSSqlConnectionProvider Members

DevExpress.Xpo.DB Namespace