Class SqlCommandFactory

Namespace

Utils.Data

Assembly

Utils.Data.dll

Provides factory methods to create SQL commands and compile SQL queries using configured syntax options.

public sealed class SqlCommandFactory

Inheritance

object

SqlCommandFactory

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.ReferenceEquals(object, object)

object.ToString()

Extension Methods

DataUtils.ToDbValue(object?)

SqlCommandFactoryExtensions.CreateCommand(SqlCommandFactory, DbConnection, SqlCommandFactory.CommandInterpolator)

SqlCommandFactoryExtensions.CreateCommand(SqlCommandFactory, IDbConnection, SqlCommandFactory.CommandInterpolator)

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

SqlCommandFactory(SqlSyntaxOptions?)

Initializes a new instance of the SqlCommandFactory class.

public SqlCommandFactory(SqlSyntaxOptions? syntaxOptions = null)

Parameters

syntaxOptions SqlSyntaxOptions

Syntax options controlling parameter and identifier prefixes.

Properties

SyntaxOptions

Gets the syntax options applied by the factory.

public SqlSyntaxOptions SyntaxOptions { get; }

Property Value

SqlSyntaxOptions

Methods

CompileQuery(string)

Compiles the provided SQL text using the configured syntax options.

public SqlQuery CompileQuery(string sql)

Parameters

sql string

SQL string to parse.

Returns

SqlQuery

A parsed representation of the SQL statement.