Class SqlDataSourceNode

Namespace

LfrlAnvil.Sql.Expressions.Objects

Assembly

LfrlAnvil.Sql.Core.dll

Represents an SQL syntax tree node that defines a single data source.

public abstract class SqlDataSourceNode : SqlNodeBase

Inheritance

object

SqlNodeBase

SqlDataSourceNode

Derived

SqlDummyDataSourceNode

SqlMultiDataSourceNode

SqlSingleDataSourceNode<TRecordSetNode>

Inherited Members

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.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.Exists(SqlDataSourceNode)

SqlDataSourceNodeExtensions.GetAll(SqlDataSourceNode)

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.NotExists(SqlDataSourceNode)

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.ToDeleteFrom(SqlDataSourceNode)

SqlDataSourceNodeExtensions.ToUpdate(SqlDataSourceNode, params SqlValueAssignmentNode[])

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

SqlNodeExtensions.Join(SqlDataSourceNode, params SqlDataSourceJoinOnNode[])

SqlNodeExtensions.Join(SqlDataSourceNode, params SqlJoinDefinition[])

SqlNodeExtensions.Join(SqlDataSourceNode, IEnumerable<SqlDataSourceJoinOnNode>)

SqlNodeExtensions.Join(SqlDataSourceNode, IEnumerable<SqlJoinDefinition>)

Constructors

SqlDataSourceNode(Chain<SqlTraitNode>)

Creates a new SqlDataSourceNode instance.

protected SqlDataSourceNode(Chain<SqlTraitNode> traits)

Parameters

traits Chain<SqlTraitNode>

Collection of decorating traits.

Properties

From

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

public abstract SqlRecordSetNode From { get; }

Property Value

SqlRecordSetNode

this[string]

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

public SqlRecordSetNode this[string recordSetIdentifier] { get; }

Parameters

recordSetIdentifier string

Record set's Identifier.

Property Value

SqlRecordSetNode

Exceptions

KeyNotFoundException

When record set does not exist.

Joins

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

public abstract ReadOnlyArray<SqlDataSourceJoinOnNode> Joins { get; }

Property Value

ReadOnlyArray<SqlDataSourceJoinOnNode>

RecordSets

Collection of all record sets contained by this data source.

public abstract IReadOnlyCollection<SqlRecordSetNode> RecordSets { get; }

Property Value

IReadOnlyCollection<SqlRecordSetNode>

Traits

Collection of decorating traits.

public Chain<SqlTraitNode> Traits { get; }

Property Value

Chain<SqlTraitNode>

Methods

AddTrait(SqlTraitNode)

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

[Pure]
public virtual SqlDataSourceNode AddTrait(SqlTraitNode trait)

Parameters

trait SqlTraitNode

Trait to add.

Returns

SqlDataSourceNode

New SQL data source syntax tree node.

GetRecordSet(string)

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

[Pure]
public abstract 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 abstract SqlDataSourceNode SetTraits(Chain<SqlTraitNode> traits)

Parameters

traits Chain<SqlTraitNode>

Collection of traits to set.

Returns

SqlDataSourceNode

New SQL data source syntax tree node.