Class PostgreSQLOptions

Namespace

LinqToDB.DataProvider.PostgreSQL

Assembly

linq2db.dll

public sealed record PostgreSQLOptions : DataProviderOptions<PostgreSQLOptions>, IOptionSet, IConfigurationID, IEquatable<DataProviderOptions<PostgreSQLOptions>>, IEquatable<PostgreSQLOptions>

Inheritance

object

DataProviderOptions<PostgreSQLOptions>

PostgreSQLOptions

Implements

IOptionSet

IConfigurationID

IEquatable<DataProviderOptions<PostgreSQLOptions>>

IEquatable<PostgreSQLOptions>

Inherited Members

DataProviderOptions<PostgreSQLOptions>.Deconstruct(out BulkCopyType)

DataProviderOptions<PostgreSQLOptions>.BulkCopyType

DataProviderOptions<PostgreSQLOptions>.Default

object.GetType()

object.Equals(object, object)

object.ReferenceEquals(object, object)

Extension Methods

Sql.IsDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

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

SqlExtensions.In<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, T)

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

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

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

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

Constructors

PostgreSQLOptions()

public PostgreSQLOptions()

PostgreSQLOptions(BulkCopyType, bool, PostgreSQLIdentifierQuoteMode)

public PostgreSQLOptions(BulkCopyType BulkCopyType = BulkCopyType.MultipleRows, bool NormalizeTimestampData = true, PostgreSQLIdentifierQuoteMode IdentifierQuoteMode = PostgreSQLIdentifierQuoteMode.Auto)

Parameters

BulkCopyType BulkCopyType

Default bulk copy mode, used for PostgreSQL by BulkCopy<T>(DataConnection, IEnumerable<T>) methods, if mode is not specified explicitly. Default value: MultipleRows.

NormalizeTimestampData bool

Enables normalization of DateTime and DateTimeOffset data, passed to query as parameter or passed to BulkCopy<T>(ITable<T>, IEnumerable<T>) APIs, to comform with Npgsql 6 requerements:

• convert DateTimeOffset value to UTC value with zero Offset
• Use Utc for DateTime timestamptz values
• Use Unspecified for DateTime timestamp values with Utc kind

Default value: true.

IdentifierQuoteMode PostgreSQLIdentifierQuoteMode

Specify identifiers quotation logic for SQL generation. Default value: Auto.

Properties

EqualityContract

protected override Type EqualityContract { get; }

Property Value

Type

IdentifierQuoteMode

Specify identifiers quotation logic for SQL generation. Default value: Auto.

public PostgreSQLIdentifierQuoteMode IdentifierQuoteMode { get; init; }

Property Value

PostgreSQLIdentifierQuoteMode

NormalizeTimestampData

Enables normalization of DateTime and DateTimeOffset data, passed to query as parameter or passed to BulkCopy<T>(ITable<T>, IEnumerable<T>) APIs, to comform with Npgsql 6 requerements:

• convert DateTimeOffset value to UTC value with zero Offset
• Use Utc for DateTime timestamptz values
• Use Unspecified for DateTime timestamp values with Utc kind

Default value: true.

public bool NormalizeTimestampData { get; init; }

Property Value

bool

Methods

CreateID(IdentifierBuilder)

protected override IdentifierBuilder CreateID(IdentifierBuilder builder)

Parameters

builder IdentifierBuilder

Returns

IdentifierBuilder

Deconstruct(out BulkCopyType, out bool, out PostgreSQLIdentifierQuoteMode)

public void Deconstruct(out BulkCopyType BulkCopyType, out bool NormalizeTimestampData, out PostgreSQLIdentifierQuoteMode IdentifierQuoteMode)

Parameters

BulkCopyType BulkCopyType

NormalizeTimestampData bool

IdentifierQuoteMode PostgreSQLIdentifierQuoteMode

Equals(DataProviderOptions<PostgreSQLOptions>?)

public override sealed bool Equals(DataProviderOptions<PostgreSQLOptions>? other)

Parameters

other DataProviderOptions<PostgreSQLOptions>

Returns

bool

Equals(PostgreSQLOptions?)

public bool Equals(PostgreSQLOptions? other)

Parameters

other PostgreSQLOptions

Returns

bool

Equals(object?)

public override bool Equals(object? obj)

Parameters

obj object

Returns

bool

GetHashCode()

public override int GetHashCode()

Returns

int

PrintMembers(StringBuilder)

protected override bool PrintMembers(StringBuilder builder)

Parameters

builder StringBuilder

Returns

bool

ToString()

public override string ToString()

Returns

string

<Clone>$()

public override DataProviderOptions<PostgreSQLOptions> <Clone>$()

Returns

DataProviderOptions<PostgreSQLOptions>

Operators

operator ==(PostgreSQLOptions?, PostgreSQLOptions?)

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

Parameters

left PostgreSQLOptions

right PostgreSQLOptions

Returns

bool

operator !=(PostgreSQLOptions?, PostgreSQLOptions?)

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

Parameters

left PostgreSQLOptions

right PostgreSQLOptions

Returns

bool