Join Class

A relation between two data tables created using a join operation in a SelectQuery.

Namespace: DevExpress.DataAccess.Sql

Assembly: DevExpress.DataAccess.v18.1.dll

Declaration

C#

public sealed class Join

VB.NET

Public NotInheritable Class Join

Related API Members

The following members accept/return Join objects:

• IncompleteRelationValidationException.Join
• NoRelationColumnsValidationException.Join
• SelectQuery.AddRelation(Table, Table, JoinType, RelationColumnInfo[])
• SelectQuery.AddRelation(Table, Table, JoinType, String)
• SelectQuery.AddRelation(Table, Table, JoinType, String, String)
• SelectQuery.AddRelation(Table, Table, JoinType, String, String, ConditionType)
• SelectQuery.AddRelation(Table, Table, RelationColumnInfo[])
• SelectQuery.AddRelation(Table, Table, String)
• SelectQuery.AddRelation(Table, Table, String, String)
• SelectQuery.AddRelation(Table, Table, String, String, ConditionType)

Remarks

A Join object is returned by the SelectQuery.AddRelation method.

To access all joins corresponding to a specific query, use the SelectQuery.Relations property.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the Join class.

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#

Reporting_how-to-use-the-web-report-designer-and-web-document-viewer-in-the-web-gardens-t528588/CS/DevExpressWebFarmsWebGardenReporting/Reports/InvoiceReport.cs#L100

DevExpress.DataAccess.Sql.ColumnExpression columnExpression33 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Join join1 = new DevExpress.DataAccess.Sql.Join();
DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo1 = new DevExpress.DataAccess.Sql.RelationColumnInfo();

VB.NET

Reporting_how-to-use-the-web-report-designer-and-web-document-viewer-in-the-web-gardens-t528588/VB/DevExpressWebFarmsWebGardenReporting/Reports/InvoiceReport.vb#L102

Dim columnExpression33 As New DevExpress.DataAccess.Sql.ColumnExpression()
Dim join1 As New DevExpress.DataAccess.Sql.Join()
Dim relationColumnInfo1 As New DevExpress.DataAccess.Sql.RelationColumnInfo()

Inheritance

Object

Join