Class SqlMultiDataSourceNode

Namespace

LfrlAnvil.Sql.Expressions.Objects

Assembly

LfrlAnvil.Sql.Core.dll

Represents an SQL syntax tree node that defines a single data source from potentially many SqlRecordSetNode instances.

public class SqlMultiDataSourceNode : SqlDataSourceNode

Inheritance

object

SqlNodeBase

SqlDataSourceNode

SqlMultiDataSourceNode

Inherited Members

SqlDataSourceNode.Traits

SqlDataSourceNode.this[string]

SqlNodeBase.NodeType

SqlNodeBase.ToString()

SqlNodeBase.ToString(SqlNodeDebugInterpreter)

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

Extension Methods

SqlDataSourceNodeExtensions.Exists(SqlDataSourceNode)

SqlDataSourceNodeExtensions.GetAll(SqlDataSourceNode)

SqlDataSourceNodeExtensions.NotExists(SqlDataSourceNode)

SqlDataSourceNodeExtensions.ToDeleteFrom(SqlDataSourceNode)

SqlDataSourceNodeExtensions.ToUpdate(SqlDataSourceNode, params SqlValueAssignmentNode[])

SqlNodeExtensions.Join(SqlDataSourceNode, params SqlDataSourceJoinOnNode[])

SqlNodeExtensions.Join(SqlDataSourceNode, params SqlJoinDefinition[])

SqlNodeExtensions.Join(SqlDataSourceNode, IEnumerable<SqlDataSourceJoinOnNode>)

SqlNodeExtensions.Join(SqlDataSourceNode, IEnumerable<SqlJoinDefinition>)

SqlDataSourceNodeExtensions.AndHaving<TDataSourceNode>(TDataSourceNode, SqlConditionNode)

SqlDataSourceNodeExtensions.AndHaving<TDataSourceNode>(TDataSourceNode, Func<TDataSourceNode, SqlConditionNode>)

SqlDataSourceNodeExtensions.AndWhere<TDataSourceNode>(TDataSourceNode, SqlConditionNode)

SqlDataSourceNodeExtensions.AndWhere<TDataSourceNode>(TDataSourceNode, Func<TDataSourceNode, SqlConditionNode>)

SqlDataSourceNodeExtensions.Distinct<TDataSourceNode>(TDataSourceNode)

SqlDataSourceNodeExtensions.GroupBy<TDataSourceNode>(TDataSourceNode, params SqlExpressionNode[])

SqlDataSourceNodeExtensions.GroupBy<TDataSourceNode>(TDataSourceNode, IEnumerable<SqlExpressionNode>)

SqlDataSourceNodeExtensions.GroupBy<TDataSourceNode>(TDataSourceNode, Func<TDataSourceNode, IEnumerable<SqlExpressionNode>>)

SqlDataSourceNodeExtensions.Limit<TDataSourceNode>(TDataSourceNode, SqlExpressionNode)

SqlDataSourceNodeExtensions.Offset<TDataSourceNode>(TDataSourceNode, SqlExpressionNode)

SqlDataSourceNodeExtensions.OrHaving<TDataSourceNode>(TDataSourceNode, SqlConditionNode)

SqlDataSourceNodeExtensions.OrHaving<TDataSourceNode>(TDataSourceNode, Func<TDataSourceNode, SqlConditionNode>)

SqlDataSourceNodeExtensions.OrWhere<TDataSourceNode>(TDataSourceNode, SqlConditionNode)

SqlDataSourceNodeExtensions.OrWhere<TDataSourceNode>(TDataSourceNode, Func<TDataSourceNode, SqlConditionNode>)

SqlDataSourceNodeExtensions.OrderBy<TDataSourceNode>(TDataSourceNode, params SqlOrderByNode[])

SqlDataSourceNodeExtensions.OrderBy<TDataSourceNode>(TDataSourceNode, IEnumerable<SqlOrderByNode>)

SqlDataSourceNodeExtensions.OrderBy<TDataSourceNode>(TDataSourceNode, Func<TDataSourceNode, IEnumerable<SqlOrderByNode>>)

SqlDataSourceNodeExtensions.Select<TDataSourceNode>(TDataSourceNode, params SqlSelectNode[])

SqlDataSourceNodeExtensions.Select<TDataSourceNode>(TDataSourceNode, IEnumerable<SqlSelectNode>)

SqlDataSourceNodeExtensions.Select<TDataSourceNode>(TDataSourceNode, Func<TDataSourceNode, IEnumerable<SqlSelectNode>>)

SqlDataSourceNodeExtensions.ToUpdate<TDataSourceNode>(TDataSourceNode, Func<TDataSourceNode, IEnumerable<SqlValueAssignmentNode>>)

SqlDataSourceNodeExtensions.Window<TDataSourceNode>(TDataSourceNode, params SqlWindowDefinitionNode[])

SqlDataSourceNodeExtensions.Window<TDataSourceNode>(TDataSourceNode, IEnumerable<SqlWindowDefinitionNode>)

SqlDataSourceNodeExtensions.Window<TDataSourceNode>(TDataSourceNode, Func<TDataSourceNode, IEnumerable<SqlWindowDefinitionNode>>)

SqlDataSourceNodeExtensions.With<TDataSourceNode>(TDataSourceNode, params SqlCommonTableExpressionNode[])

SqlDataSourceNodeExtensions.With<TDataSourceNode>(TDataSourceNode, IEnumerable<SqlCommonTableExpressionNode>)

SqlDataSourceNodeExtensions.With<TDataSourceNode>(TDataSourceNode, Func<TDataSourceNode, IEnumerable<SqlCommonTableExpressionNode>>)

Constructors

SqlMultiDataSourceNode(SqlMultiDataSourceNode, Chain<SqlTraitNode>)

Creates a new SqlMultiDataSourceNode instance.

protected SqlMultiDataSourceNode(SqlMultiDataSourceNode @base, Chain<SqlTraitNode> traits)

Parameters

base SqlMultiDataSourceNode

Source SqlMultiDataSourceNode instance.

traits Chain<SqlTraitNode>

Collection of decorating traits.

SqlMultiDataSourceNode(SqlRecordSetNode, SqlDataSourceJoinOnNode[])

Creates a new SqlMultiDataSourceNode instance.

protected SqlMultiDataSourceNode(SqlRecordSetNode from, SqlDataSourceJoinOnNode[] joins)

Parameters

from SqlRecordSetNode

First SqlRecordSetNode instance from which this data source's definition begins.

joins SqlDataSourceJoinOnNode[]

Sequential collection of all SqlDataSourceJoinOnNode instances that define this data source.

SqlMultiDataSourceNode(SqlRecordSetNode, SqlJoinDefinition[])

Creates a new SqlMultiDataSourceNode instance.

protected SqlMultiDataSourceNode(SqlRecordSetNode from, SqlJoinDefinition[] definitions)

Parameters

from SqlRecordSetNode

First SqlRecordSetNode instance from which this data source's definition begins.

definitions SqlJoinDefinition[]

Sequential collection of all SqlJoinDefinition instances that define this data source's Joins.

Properties

From

First SqlRecordSetNode instance from which this data source's definition begins.

public override sealed SqlRecordSetNode From { get; }

Property Value

SqlRecordSetNode

Joins

Sequential collection of all SqlDataSourceJoinOnNode instances that define this data source.

public override sealed ReadOnlyArray<SqlDataSourceJoinOnNode> Joins { get; }

Property Value

ReadOnlyArray<SqlDataSourceJoinOnNode>

RecordSets

Collection of all record sets contained by this data source.

public override sealed IReadOnlyCollection<SqlRecordSetNode> RecordSets { get; }

Property Value

IReadOnlyCollection<SqlRecordSetNode>

Methods

AddTrait(SqlTraitNode)

Creates a new SQL data source syntax tree node by adding a new trait.

[Pure]
public override SqlMultiDataSourceNode AddTrait(SqlTraitNode trait)

Parameters

trait SqlTraitNode

Trait to add.

Returns

SqlMultiDataSourceNode

New SQL data source syntax tree node.

GetRecordSet(string)

Returns a record set associated with this data source by its identifier.

[Pure]
public override sealed SqlRecordSetNode GetRecordSet(string identifier)

Parameters

identifier string

Record set's Identifier.

Returns

SqlRecordSetNode

SqlRecordSetNode instance associated with the provided identifier.

Exceptions

KeyNotFoundException

When record set does not exist.

SetTraits(Chain<SqlTraitNode>)

Creates a new SQL data source syntax tree node by changing the Traits collection.

[Pure]
public override SqlMultiDataSourceNode SetTraits(Chain<SqlTraitNode> traits)

Parameters

traits Chain<SqlTraitNode>

Collection of traits to set.

Returns

SqlMultiDataSourceNode

New SQL data source syntax tree node.