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>.BulkCopyType

DataProviderOptions<PostgreSQLOptions>.Default

Extension Methods

Sql.IsDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<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>)

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

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

Equals(PostgreSQLOptions?)

Indicates whether the current object is equal to another object of the same type.

public bool Equals(PostgreSQLOptions? other)

Parameters

other PostgreSQLOptions

An object to compare with this object.

Returns

bool

true if the current object is equal to the other parameter; otherwise, false.

GetHashCode()

Serves as a hash function for a particular type.

public override int GetHashCode()

Returns

int

A hash code for the current object.