Class CteDefinition

Namespace

Utils.Data.Sql

Assembly

Utils.Data.dll

Represents a CTE definition inside a WITH clause.

public sealed class CteDefinition

Inheritance

object

CteDefinition

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.ReferenceEquals(object, object)

object.ToString()

Extension Methods

DataUtils.ToDbValue(object?)

MathEx.Clamp<T>(T, T, T, IComparer<T>)

FluentExtensions.Failure<T>(T)

FluentExtensions.IsEqualTo<T, CT>(T, CT)

FluentExtensions.IsGreaterOrEqualsThan<T, CT>(T, CT)

FluentExtensions.IsGreaterThan<T, CT>(T, CT)

FluentExtensions.IsIn<T>(T, params T[])

FluentExtensions.IsLowerOrEqualsThan<T, CT>(T, CT)

FluentExtensions.IsLowerThan<T, CT>(T, CT)

FluentExtensions.IsNotIn<T>(T, params T[])

FluentExtensions.IsNotNull<T>(T)

FluentExtensions.IsNull<T>(T)

FluentExtensions.Success<T>(T)

FluentExtensions.Test<T>(T, Func<T, bool>)

ObjectUtils.Between<T>(T, IComparer<T>, T, T)

ObjectUtils.Between<T>(T, IComparer<T>, T, T, bool, bool)

ObjectUtils.DoAsync<T, Result>(T, Func<T, Task<Result>>, Func<Task<Result>>)

ObjectUtils.DoAsync<T, Result>(T, Func<T, Task<Result>>, Result)

ObjectUtils.DoAsync<T, Result>(T, Func<T, Result>, Func<Result>)

ObjectUtils.DoAsync<T, Result>(T, Func<T, Result>, Result)

ObjectUtils.Do<T, Result>(T, Func<T, Result>, Func<Result>)

ObjectUtils.Do<T, Result>(T, Func<T, Result>, Result)

ObjectUtils.In<T>(T, params T[])

ObjectUtils.NotIn<T>(T, params T[])

Validations.ArgMustBe<T>(T, Func<T, bool>, string, string)

Validations.ArgMustNotBe<T>(T, Func<T, bool>, string, string)

Validations.Arg<T>(T, string)

Validations.ValueMustNotBeNull<T>(T, string)

Validations.Variable<T>(T, string)

Constructors

CteDefinition(string, IReadOnlyList<string>?, SqlStatement)

Initializes a new instance of the CteDefinition class.

public CteDefinition(string name, IReadOnlyList<string>? columns, SqlStatement statement)

Parameters

name string

Name of the CTE.

columns IReadOnlyList<string>

Optional list of column names.

statement SqlStatement

The statement defining the CTE.

Properties

Columns

Gets the optional list of column names.

public IReadOnlyList<string>? Columns { get; }

Property Value

IReadOnlyList<string>

Name

Gets the name of the CTE.

public string Name { get; }

Property Value

string

Statement

Gets the statement associated with the CTE.

public SqlStatement Statement { get; }

Property Value

SqlStatement

Methods

ToSql()

Builds the SQL text representing the CTE definition.

public string ToSql()

Returns

string

The SQL string for the CTE.