Interface ISqlViewBuilder

Namespace

LfrlAnvil.Sql.Objects.Builders

Assembly

LfrlAnvil.Sql.Core.dll

Represents an SQL view builder.

public interface ISqlViewBuilder : ISqlObjectBuilder

Inherited Members

ISqlObjectBuilder.Name

ISqlObjectBuilder.Type

ISqlObjectBuilder.Database

ISqlObjectBuilder.ReferencingObjects

ISqlObjectBuilder.IsRemoved

ISqlObjectBuilder.CanRemove

ISqlObjectBuilder.Remove()

Extension Methods

SqlNodeExtensions.ToRecordSet(ISqlViewBuilder, string?)

SqlObjectExtensions.ToCreateNode(ISqlViewBuilder, bool)

Properties

Info

Represents a full name information of this view.

SqlRecordSetInfo Info { get; }

Property Value

SqlRecordSetInfo

Node

Underlying SqlViewBuilderNode instance that represents this view.

SqlViewBuilderNode Node { get; }

Property Value

SqlViewBuilderNode

ReferencedObjects

Collection of objects (tables, views and columns) referenced by this view's Source.

IReadOnlyCollection<ISqlObjectBuilder> ReferencedObjects { get; }

Property Value

IReadOnlyCollection<ISqlObjectBuilder>

Schema

Schema that this view belongs to.

ISqlSchemaBuilder Schema { get; }

Property Value

ISqlSchemaBuilder

Source

Underlying source query expression that defines this view.

SqlQueryExpressionNode Source { get; }

Property Value

SqlQueryExpressionNode

Methods

SetName(string)

Changes the name of this object.

ISqlViewBuilder SetName(string name)

Parameters

name string

Name to set.

Returns

ISqlViewBuilder

this.

Exceptions

SqlObjectBuilderException

When name cannot be changed.