Class SqlSingleDataSourceNode<TRecordSetNode>

Namespace

LfrlAnvil.Sql.Expressions.Objects

Assembly

LfrlAnvil.Sql.Core.dll

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

public sealed class SqlSingleDataSourceNode<TRecordSetNode> : SqlDataSourceNode where TRecordSetNode : SqlRecordSetNode

Type Parameters

TRecordSetNode

SQL record set node type.

Inheritance

object

SqlNodeBase

SqlDataSourceNode

SqlSingleDataSourceNode<TRecordSetNode>

Inherited Members

SqlDataSourceNode.Traits

SqlNodeBase.NodeType

SqlNodeBase.ToString()

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

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

Properties

From

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

public override TRecordSetNode From { get; }

Property Value

TRecordSetNode

this[string]

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

public TRecordSetNode this[string identifier] { get; }

Parameters

identifier string

Property Value

TRecordSetNode

Exceptions

KeyNotFoundException

When record set does not exist.

Joins

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

public override ReadOnlyArray<SqlDataSourceJoinOnNode> Joins { get; }

Property Value

ReadOnlyArray<SqlDataSourceJoinOnNode>

RecordSets

Collection of all record sets contained by this data source.

public override 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 SqlSingleDataSourceNode<TRecordSetNode> AddTrait(SqlTraitNode trait)

Parameters

trait SqlTraitNode

Trait to add.

Returns

SqlSingleDataSourceNode<TRecordSetNode>

New SQL data source syntax tree node.

GetRecordSet(string)

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

[Pure]
public override TRecordSetNode GetRecordSet(string identifier)

Parameters

identifier string

Record set's Identifier.

Returns

TRecordSetNode

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 SqlSingleDataSourceNode<TRecordSetNode> SetTraits(Chain<SqlTraitNode> traits)

Parameters

traits Chain<SqlTraitNode>

Collection of traits to set.

Returns

SqlSingleDataSourceNode<TRecordSetNode>

New SQL data source syntax tree node.