Enum JoinType

Specifies join type.

Namespace: Mediachase.BusinessFoundation.Data.Sql.Management
Assembly: Mediachase.BusinessFoundation.Data.dll
Version: 10.8.0
Syntax
public enum JoinType

Fields

Name Description
CrossJoin

A join whose result set includes one row for each possible pairing of rows from the two tables.

FullOuterJoin

All rows in all joined tables are included, whether they are matched or not.

Inner

A join that displays only the rows that have a match in both joined tables.

LeftOuter

All rows from the first-named table (the "left" table, which appears leftmost in the JOIN clause) are included. Unmatched rows in the right table do not appear.

RightOuter

All rows in the second-named table (the "right" table, which appears rightmost in the JOIN clause) are included. Unmatched rows in the left table are not included.

Extension Methods