Class SqlSegment

Namespace

Utils.Data.Sql

Assembly

Utils.Data.dll

Represents a section of a SQL statement, such as SELECT columns or a WHERE clause.

public sealed class SqlSegment

Inheritance

object

SqlSegment

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)

Properties

IsEmpty

Gets a value indicating whether the segment contains any parts.

public bool IsEmpty { get; }

Property Value

bool

Name

Gets the name of the segment.

public string Name { get; }

Property Value

string

Subqueries

Gets the subqueries found in the segment.

public IEnumerable<SqlStatement> Subqueries { get; }

Property Value

IEnumerable<SqlStatement>

Methods

AddCommaSeparatedElement(string)

Appends a comma-separated element to the segment, inserting a comma when required.

public void AddCommaSeparatedElement(string sql)

Parameters

sql string

The SQL snippet representing the new element.

AddConjunction(string, string)

Appends a logical conjunction to the segment followed by an expression.

public void AddConjunction(string conjunction, string expression)

Parameters

conjunction string

The conjunction keyword such as AND or OR.

expression string

The expression to append.

AddRaw(string)

Appends raw SQL tokens to the segment.

public void AddRaw(string sql)

Parameters

sql string

The SQL snippet to append.

ToSql()

Builds the SQL text represented by the segment.

public string ToSql()

Returns

string

The SQL string representing the segment.