Class SqlBuilderInterpolator

Namespace

Utils.Data

Assembly

Utils.Data.dll

Interpolated string handler used to build parameterized SQL statements.

public class SqlBuilderInterpolator

Inheritance

object

SqlBuilderInterpolator

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

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

SqlBuilderInterpolator(int, int, DbConnection, SqlSyntaxOptions?)

Initializes a new instance of the SqlBuilderInterpolator class.

public SqlBuilderInterpolator(int literalLength, int formattedCount, DbConnection dbConnection, SqlSyntaxOptions? syntaxOptions = null)

Parameters

literalLength int

Provided by the compiler to optimize the size of the string builder.

formattedCount int

Number of formatted placeholders in the interpolation.

dbConnection DbConnection

Connection used to create the underlying command.

syntaxOptions SqlSyntaxOptions

Syntax options controlling parameter prefixes.

SqlBuilderInterpolator(int, int, IDbCommand, SqlSyntaxOptions?)

Initializes a new instance of the SqlBuilderInterpolator class.

public SqlBuilderInterpolator(int literalLength, int formattedCount, IDbCommand dbCommand, SqlSyntaxOptions? syntaxOptions = null)

Parameters

literalLength int

Provided by the compiler to optimize the size of the string builder.

formattedCount int

Number of formatted placeholders in the interpolation.

dbCommand IDbCommand

Command to modify.

syntaxOptions SqlSyntaxOptions

Syntax options controlling parameter prefixes.

SqlBuilderInterpolator(int, int, IDbConnection, SqlSyntaxOptions?)

Initializes a new instance of the SqlBuilderInterpolator class.

public SqlBuilderInterpolator(int literalLength, int formattedCount, IDbConnection dbConnection, SqlSyntaxOptions? syntaxOptions = null)

Parameters

literalLength int

Provided by the compiler to optimize the size of the string builder.

formattedCount int

Number of formatted placeholders in the interpolation.

dbConnection IDbConnection

Connection used to create the underlying command.

syntaxOptions SqlSyntaxOptions

Syntax options controlling parameter prefixes.

Properties

DbCommand

Command associated with this interpolator. Parameters will be created on this command.

public IDbCommand DbCommand { get; }

Property Value

IDbCommand

SyntaxOptions

Gets the syntax options controlling parameter names for the interpolator.

public SqlSyntaxOptions SyntaxOptions { get; }

Property Value

SqlSyntaxOptions

Methods

AppendFormatted<T>(T, string?)

Adds a formatted value to the SQL query and ensures a parameter is created.

public void AppendFormatted<T>(T value, string? name = null)

Parameters

value T

The value being interpolated.

name string

Name of the argument being interpolated.

Type Parameters

T

Type of the value to append.

AppendLiteral(string)

Appends a literal piece of SQL to the internal buffer.

public void AppendLiteral(string s)

Parameters

s string

The literal string to append.

ToString()

Returns the built SQL query.

public override string ToString()

Returns

string

The SQL string accumulated so far.