Class TranslationPolicy

Namespace

The.SQL.Persistence

Assembly

Instagile.dll

public sealed record TranslationPolicy : IEquatable<TranslationPolicy>

Inheritance

object

TranslationPolicy

Implements

IEquatable<TranslationPolicy>

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.ReferenceEquals(object, object)

object.ToString()

Constructors

TranslationPolicy(bool, bool, bool, bool, bool, RegexReplacementSyntax)

public TranslationPolicy(bool Optimise, bool ReprojectViaCTE, bool AllowSubqueryWithinAggregate, bool CurrencyManipulationUnsupported, bool MillisecondResolution, RegexReplacementSyntax RegexReplacement = RegexReplacementSyntax.DotNet)

Parameters

Optimise bool

Spend extra CPU time to save DB work.

ReprojectViaCTE bool

Generate a common table expression instead of a subquery to implement skip/reorder.

AllowSubqueryWithinAggregate bool

Generate subqueries instead of outer joins inside aggregate functions. Used for databases which can handle SUM(SELECT X FROM Y).

CurrencyManipulationUnsupported bool

The database does not support manipulation of currency attributes.

MillisecondResolution bool

The database supports time values in milliseconds (rather than seconds).

RegexReplacement RegexReplacementSyntax

The substitution syntax the backend's regex-replace expects, used to rewrite Regex.Replace replacement strings. Defaults to .NET syntax (no rewrite), which suits the transient and SQLite backends.

Properties

AllowSubqueryWithinAggregate

Generate subqueries instead of outer joins inside aggregate functions. Used for databases which can handle SUM(SELECT X FROM Y).

public bool AllowSubqueryWithinAggregate { get; init; }

Property Value

bool

CurrencyManipulationUnsupported

The database does not support manipulation of currency attributes.

public bool CurrencyManipulationUnsupported { get; init; }

Property Value

bool

MillisecondResolution

The database supports time values in milliseconds (rather than seconds).

public bool MillisecondResolution { get; init; }

Property Value

bool

Optimise

Spend extra CPU time to save DB work.

public bool Optimise { get; init; }

Property Value

bool

RegexReplacement

The substitution syntax the backend's regex-replace expects, used to rewrite Regex.Replace replacement strings. Defaults to .NET syntax (no rewrite), which suits the transient and SQLite backends.

public RegexReplacementSyntax RegexReplacement { get; init; }

Property Value

RegexReplacementSyntax

ReprojectViaCTE

Generate a common table expression instead of a subquery to implement skip/reorder.

public bool ReprojectViaCTE { get; init; }

Property Value

bool

Methods

Translate(Expression)

public TranslatedQuery Translate(Expression untranslated)

Parameters

untranslated Expression

Returns

TranslatedQuery