Enum BasicSqlBuilder.ConcatBuildStyle

Namespace

LinqToDB.Internal.SqlProvider

Assembly

linq2db.dll

Built-in strategies for emitting a SqlConcatExpression. Providers select one via ConcatStyle; BuildSqlConcatExpression(SqlConcatExpression) is overridden only when none of the three fits.

protected enum BasicSqlBuilder.ConcatBuildStyle

Extension Methods

Sql.Between<T>(T, T, T)

Sql.IsDistinctFrom<T>(T, T)

Sql.IsDistinctFrom<T>(T, T?)

Sql.IsNotDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T?)

Sql.NotBetween<T>(T, T, T)

SqlExtensions.In<T>(T, T, T)

SqlExtensions.In<T>(T, T, T, T)

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

SqlExtensions.In<T>(T, IEnumerable<T>)

SqlExtensions.In<T>(T, IQueryable<T>)

SqlExtensions.NotIn<T>(T, T, T)

SqlExtensions.NotIn<T>(T, T, T, T)

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

SqlExtensions.NotIn<T>(T, IEnumerable<T>)

SqlExtensions.NotIn<T>(T, IQueryable<T>)

Fields

Function = 2

CONCAT(a, b, c) — MySQL, ClickHouse.

Pipes = 1

a || b || c — ANSI-SQL standard; PostgreSQL, Oracle, SQLite, DB2, Firebird, Informix, SAP HANA, DuckDB, Sybase ASE, SQL Server 2025+.

Plus = 0

a + b + c — SQL Server pre-2025, SqlCe, Access.