Class SqlOptions

Namespace

LinqToDB

Assembly

linq2db.dll

public sealed record SqlOptions : IOptionSet, IConfigurationID, IEquatable<SqlOptions>

Inheritance

object

SqlOptions

Implements

IOptionSet

IConfigurationID

IEquatable<SqlOptions>

Inherited Members

object.GetType()

object.Equals(object, object)

object.ReferenceEquals(object, object)

Extension Methods

DataOptionsExtensions.WithEnableConstantExpressionInOrderBy(SqlOptions, bool)

DataOptionsExtensions.WithGenerateFinalAliases(SqlOptions, bool)

Sql.IsDistinctFrom<T>(T, T)

Sql.IsDistinctFrom<T>(T, T)

Sql.IsDistinctFrom<T>(T, T)

Sql.IsDistinctFrom<T>(T, T)

Sql.IsDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Utils.IsNullValue(object?)

Utils.IsNullValue(object?)

Utils.IsNullValue(object?)

Utils.IsNullValue(object?)

Utils.IsNullValue(object?)

Constructors

SqlOptions()

public SqlOptions()

SqlOptions(bool, bool)

public SqlOptions(bool EnableConstantExpressionInOrderBy = false, bool GenerateFinalAliases = false)

Parameters

EnableConstantExpressionInOrderBy bool

If true, linq2db will allow any constant expressions in ORDER BY clause. Default value: false.

GenerateFinalAliases bool

Indicates whether SQL Builder should generate aliases for final projection. It is not required for correct query processing but simplifies SQL analysis.

Default value: false.

For the query

var query = from child in db.Child
   select new
   {
      TrackId = child.ChildID,
   };

When property is true

SELECT
   [child].[ChildID] as [TrackId]
FROM
   [Child] [child]

Otherwise alias will be removed

SELECT
   [child].[ChildID]
FROM
   [Child] [child]

Properties

Default

Gets default SqlOptions instance.

public static SqlOptions Default { get; set; }

Property Value

SqlOptions

EnableConstantExpressionInOrderBy

If true, linq2db will allow any constant expressions in ORDER BY clause. Default value: false.

public bool EnableConstantExpressionInOrderBy { get; init; }

Property Value

bool

GenerateFinalAliases

Indicates whether SQL Builder should generate aliases for final projection. It is not required for correct query processing but simplifies SQL analysis.

Default value: false.

For the query

var query = from child in db.Child
   select new
   {
      TrackId = child.ChildID,
   };

When property is true

SELECT
   [child].[ChildID] as [TrackId]
FROM
   [Child] [child]

Otherwise alias will be removed

SELECT
   [child].[ChildID]
FROM
   [Child] [child]

public bool GenerateFinalAliases { get; init; }

Property Value

bool

Methods

Deconstruct(out bool, out bool)

public void Deconstruct(out bool EnableConstantExpressionInOrderBy, out bool GenerateFinalAliases)

Parameters

EnableConstantExpressionInOrderBy bool

GenerateFinalAliases bool

Equals(SqlOptions?)

public bool Equals(SqlOptions? other)

Parameters

other SqlOptions

Returns

bool

Equals(object?)

public override bool Equals(object? obj)

Parameters

obj object

Returns

bool

GetHashCode()

public override int GetHashCode()

Returns

int

ToString()

public override string ToString()

Returns

string

Operators

operator ==(SqlOptions?, SqlOptions?)

public static bool operator ==(SqlOptions? left, SqlOptions? right)

Parameters

left SqlOptions

right SqlOptions

Returns

bool

operator !=(SqlOptions?, SqlOptions?)

public static bool operator !=(SqlOptions? left, SqlOptions? right)

Parameters

left SqlOptions

right SqlOptions

Returns

bool