JoinGraph

Classes > Nimblesite.Sql.Model > JoinGraph

Represents the join relationships for one-to-many scenarios that need grouping

public sealed class JoinGraph

Properties

Count

public int Count { get; }

Gets the number of join relationships

Methods

Add(string, string, string, string)

public void Add(string leftTable, string rightTable, string condition, string joinType = "INNER")

Adds a new join relationship to the graph

Parameters:

Name Type Description
leftTable String The left table name
rightTable String The right table name
condition String The join condition
joinType String The join type (default: INNER)

GetRelationships()

public IReadOnlyList<JoinRelationship> GetRelationships()

Gets all join relationships as a read-only collection

Returns: JoinRelationship> - The join relationships