Class SqlQuery

Namespace

Utils.Data.Sql

Assembly

Utils.Data.dll

Represents the root of an analysed SQL statement.

public sealed class SqlQuery

Inheritance

object

SqlQuery

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

SqlQuery(SqlStatement, SqlSyntaxOptions?)

Initializes a new instance of the SqlQuery class.

public SqlQuery(SqlStatement rootStatement, SqlSyntaxOptions? syntaxOptions = null)

Parameters

rootStatement SqlStatement

The root statement of the SQL query.

syntaxOptions SqlSyntaxOptions

Syntax options describing identifier handling for the query.

Exceptions

ArgumentNullException

Thrown when rootStatement is null.

Properties

AllStatements

Gets all statements contained in the query, including the root and nested statements such as CTEs or subqueries. The collection is rebuilt on each access so that modifications applied to the query tree are reflected immediately.

public IReadOnlyList<SqlStatement> AllStatements { get; }

Property Value

IReadOnlyList<SqlStatement>

RootStatement

Gets the root statement of the query.

public SqlStatement RootStatement { get; }

Property Value

SqlStatement

SyntaxOptions

Gets the syntax options associated with the query.

public SqlSyntaxOptions SyntaxOptions { get; }

Property Value

SqlSyntaxOptions

Methods

ToSql(SqlFormattingOptions?)

Reconstructs the SQL text from the analysed structure.

public string ToSql(SqlFormattingOptions? options = null)

Parameters

options SqlFormattingOptions

Formatting options controlling the SQL output.

Returns

string

A SQL string equivalent to the parsed statement.