Class SqlProviderPostgreSql

Namespace

Tripous.Data

Assembly

Tripous.Data.dll

SqlProvider for PostgreSQL databases.

public class SqlProviderPostgreSql : SqlProvider

Inheritance

object

SqlProvider

SqlProviderPostgreSql

Inherited Members

SqlProvider.GlobalPrefix

SqlProvider.ReplaceDecimalPlaceholders(string)

SqlProvider.CreateParamMap(SqlParams)

SqlProvider.FindParam(Dictionary<string, SqlParam>, string, string)

SqlProvider.GetNativeParameterName(string)

SqlProvider.GetSqlParameterToken(string)

SqlProvider.CreateDbParameter(DbCommand, SqlParam)

SqlProvider.PrepareCommand(DbCommand, string, SqlParams)

SqlProvider.DecimalWithArgsSql(string)

SqlProvider.Log(Exception, string, object[], MemTable)

SqlProvider.FormatSqlLogValue(object)

SqlProvider.FormatSqlParameters(DbParameterCollection)

SqlProvider.CanLogSql(string)

SqlProvider.LogSql(DbCommand)

SqlProvider.CreateSqlParams(string, params object[])

SqlProvider.WaitUntilDatabaseReady(string, int, int)

SqlProvider.ReplaceDataTypePlaceholders(string)

SqlProvider.CreateConnectionStringBuilder(string)

SqlProvider.GetDatabaseName(string)

SqlProvider.CreateConnection(string)

SqlProvider.CreateCommand(DbConnection, string, params object[])

SqlProvider.CreateCommand(DbConnection, string, SqlParams)

SqlProvider.CanConnect(string, bool)

SqlProvider.DatabaseExists(string)

SqlProvider.EnsureConnection(string)

SqlProvider.OpenConnection(DbConnectionInfo)

SqlProvider.OpenConnection(string)

SqlProvider.BeginTransactionContext(DbConnectionInfo)

SqlProvider.BeginTransactionContext(string)

SqlProvider.NormalizeConnectionString(string)

SqlProvider.CreateConnectionString(string, string, string, string)

SqlProvider.Select(DbConnectionInfo, string)

SqlProvider.Select(DbConnectionInfo, string, params object[])

SqlProvider.Select(string, string)

SqlProvider.Select(string, string, params object[])

SqlProvider.Select(string, string, int, params object[])

SqlProvider.Select(DbTransaction, string, int, params object[])

SqlProvider.SelectTo(DbConnectionInfo, MemTable, string)

SqlProvider.SelectTo(DbConnectionInfo, MemTable, string, params object[])

SqlProvider.SelectTo(string, MemTable, string, params object[])

SqlProvider.SelectTo(string, MemTable, string, int, params object[])

SqlProvider.SelectTo(DbTransaction, MemTable, string, int, params object[])

SqlProvider.ExecSql(DbConnectionInfo, string)

SqlProvider.ExecSql(DbConnectionInfo, string, params object[])

SqlProvider.ExecSql(string, string)

SqlProvider.ExecSql(string, string, params object[])

SqlProvider.ExecSql(string, string, int, params object[])

SqlProvider.ExecSql(DbConnectionInfo, IEnumerable<string>)

SqlProvider.ExecSql(string, IEnumerable<string>)

SqlProvider.ExecSql(DbTransaction, string)

SqlProvider.ExecSql(DbTransaction, string, params object[])

SqlProvider.ExecSql(DbTransaction, string, int, params object[])

SqlProvider.ExecSql(DbConnectionInfo, Action<DbTransaction>)

SqlProvider.ExecSql(string, Action<DbTransaction>)

SqlProvider.SelectResults(string, string)

SqlProvider.SelectResults(string, string, params object[])

SqlProvider.SelectResults(DbTransaction, string, int, params object[])

SqlProvider.SelectResult(string, string)

SqlProvider.SelectResult(string, string, object)

SqlProvider.SelectResult(string, string, object, params object[])

SqlProvider.SelectResult(DbTransaction, string, int, object, params object[])

SqlProvider.IntegerResult(string, string, int)

SqlProvider.IntegerResult(string, string, int, params object[])

SqlProvider.IntegerResult(DbTransaction, string, int, int, params object[])

SqlProvider.SelectForUpdateSql(string, string)

SqlProvider.SelectForUpdate(DbTransaction, string, string, object)

SqlProvider.SelectForUpdate(DbTransaction, string, string, int, object)

SqlProvider.SelectIncrementLocked(DbConnectionInfo, string, string, object, string)

SqlProvider.SelectIncrementLocked(string, string, string, object, string, int)

SqlProvider.SelectIncrementLocked(DbTransaction, string, string, object, string, int)

SqlProvider.NormalizeRowLimit(int)

SqlProvider.QuoteName(string)

SqlProvider.Concat(params string[])

SqlProvider.GetServerDateTime(DbConnectionInfo)

SqlProvider.QSDate(DateTime)

SqlProvider.QSDateTime(DateTime)

SqlProvider.SupportsAlterTableType(AlterTableType)

SqlProvider.AddColumnSql(string, string)

SqlProvider.DropColumnSql(string, string)

SqlProvider.SetDefaultBeforeNotNullUpdateSql(string, string, string, bool)

SqlProvider.AddUniqueConstraintSql(string, string, string)

SqlProvider.DropUniqueConstraintSql(string, string)

SqlProvider.AddForeignKeySql(string, string, string, string, string)

SqlProvider.DropForeignKeySql(string, string)

SqlProvider.Name

SqlProvider.Factory

SqlProvider.ServerType

SqlProvider.ConnectionStringAdapter

SqlProvider.PositionalParameters

SqlProvider.Description

SqlProvider.SupportsTransactions

SqlProvider.SupportedAlterTableTypes

SqlProvider.DefaultCommandTimeoutSeconds

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Extension Methods

TypeExtensions.InheritsFrom(object, Type)

Properties

AutoIncSql

Keyword, used in replacing a placeholder

public override string AutoIncSql { get; }

Property Value

string

BlobSql

Keyword, used in replacing a placeholder

public override string BlobSql { get; }

Property Value

string

BlobTextSql

Keyword, used in replacing a placeholder

public override string BlobTextSql { get; }

Property Value

string

BoolSql

Keyword, used in replacing a placeholder

public override string BoolSql { get; }

Property Value

string

CanCreateDatabases

Returns true if the provider can create databases.

public override bool CanCreateDatabases { get; }

Property Value

bool

ConnectionStringTemplate

The connection string template.

public override string ConnectionStringTemplate { get; }

Property Value

string

DatabaseKeys

A list of strings used as database name key in connection strings.

public override string[] DatabaseKeys { get; }

Property Value

string[]

DateSql

Keyword, used in replacing a placeholder

public override string DateSql { get; }

Property Value

string

DateTimeSql

Keyword, used in replacing a placeholder

public override string DateTimeSql { get; }

Property Value

string

DecimalSql

Keyword, used in replacing a placeholder

public override string DecimalSql { get; }

Property Value

string

FloatSql

Keyword, used in replacing a placeholder

public override string FloatSql { get; }

Property Value

string

LastIdSql

The SQL used to get the last inserted id.

public override string LastIdSql { get; }

Property Value

string

NBlobTextSql

Keyword, used in replacing a placeholder

public override string NBlobTextSql { get; }

Property Value

string

NVarcharSql

Keyword, used in replacing a placeholder

public override string NVarcharSql { get; }

Property Value

string

NativePrefix

The prefix used for native parameters.

public override string NativePrefix { get; }

Property Value

string

NotNullSql

Keyword, used in replacing a placeholder

public override string NotNullSql { get; }

Property Value

string

NullSql

Keyword, used in replacing a placeholder

public override string NullSql { get; }

Property Value

string

ObjectEndDelimiter

The delimiter used to quote object names.

public override string ObjectEndDelimiter { get; }

Property Value

string

ObjectStartDelimiter

The delimiter used to quote object names.

public override string ObjectStartDelimiter { get; }

Property Value

string

OidMode

The OidMode.

public override OidMode OidMode { get; }

Property Value

OidMode

PasswordKeys

A list of strings used as password key in connection strings.

public override string[] PasswordKeys { get; }

Property Value

string[]

PrimaryKeySql

Keyword, used in replacing a placeholder

public override string PrimaryKeySql { get; }

Property Value

string

ServerDateTimeSql

The SQL used to get the current date and time of the database server.

public override string ServerDateTimeSql { get; }

Property Value

string

ServerKeys

A list of strings used as server name key in connection strings.

public override string[] ServerKeys { get; }

Property Value

string[]

SuperUser

The super user name.

public override string SuperUser { get; }

Property Value

string

SuperUserPassword

The super user password.

public override string SuperUserPassword { get; }

Property Value

string

SupportsAutoIncFields

True if the provider supports auto-increment fields.

public override bool SupportsAutoIncFields { get; }

Property Value

bool

SupportsGenerators

True if the provider supports generators.

public override bool SupportsGenerators { get; }

Property Value

bool

UserNameKeys

A list of strings used as user name key in connection strings.

public override string[] UserNameKeys { get; }

Property Value

string[]

VarcharSql

Keyword, used in replacing a placeholder

public override string VarcharSql { get; }

Property Value

string

Methods

ApplyRowLimit(string, int)

Applies a row limit to the SqlText.

public override string ApplyRowLimit(string SqlText, int RowLimit)

Parameters

SqlText string

RowLimit int

Returns

string

CreateDatabase(string)

Creates a database.

public override bool CreateDatabase(string ConnectionString)

Parameters

ConnectionString string

Returns

bool

CreateGenerator(string, string)

Creates the GeneratorName generator to the database.

public override void CreateGenerator(string ConnectionString, string GeneratorName)

Parameters

ConnectionString string

GeneratorName string

DropColumnDefaultSql(string, string)

Returns an "alter column" SQL statement.

public override string DropColumnDefaultSql(string TableName, string ColumnName)

Parameters

TableName string

ColumnName string

Returns

string

DropNotNullSql(string, string, string)

Returns an "alter column" SQL statement.

public override string DropNotNullSql(string TableName, string ColumnName, string DataType)

Parameters

TableName string

ColumnName string

DataType string

Returns

string

GeneratorExists(string, string)

Returns true if the GeneratorName exists in a database.

public override bool GeneratorExists(string ConnectionString, string GeneratorName)

Parameters

ConnectionString string

GeneratorName string

Returns

bool

GetServerDateTime(string)

Returns the current date and time of the database server

public override DateTime GetServerDateTime(string ConnectionString)

Parameters

ConnectionString string

Returns

DateTime

LastId(DbTransaction, string)

Returns the last id produced by an INSERT Sqlt statement.

It should be used only with databases that support identity (auto-increment) columns

public override int LastId(DbTransaction Transaction, string TableName)

Parameters

Transaction DbTransaction

TableName string

Returns

int

NextIdByGenerator(DbTransaction, string)

Returns the next value of the GeneratorName generator.

public override int NextIdByGenerator(DbTransaction Transaction, string GeneratorName)

Parameters

Transaction DbTransaction

GeneratorName string

Returns

int

RenameColumnSql(string, string, string)

Returns an "alter column" SQL statement.

public override string RenameColumnSql(string TableName, string ColumnName, string NewColumnName)

Parameters

TableName string

ColumnName string

NewColumnName string

Returns

string

SetColumnDefaultSql(string, string, string)

Returns an "alter column" SQL statement.

public override string SetColumnDefaultSql(string TableName, string ColumnName, string DefaultExpression)

Parameters

TableName string

ColumnName string

DefaultExpression string

Returns

string

SetColumnLengthSql(string, string, string, string, string)

Returns an "alter column" SQL statement.

public override string SetColumnLengthSql(string TableName, string ColumnName, string DataType, string Required, string DefaultExpression)

Parameters

TableName string

ColumnName string

DataType string

Required string

DefaultExpression string

Returns

string

SetGeneratorTo(string, string, int)

Attempts to set a generator/sequencer to Value.

DANGEROOUS.

public override void SetGeneratorTo(string ConnectionString, string GeneratorName, int Value)

Parameters

ConnectionString string

GeneratorName string

Value int

SetNotNullSql(string, string, string)

Returns an "alter column" SQL statement.

public override string SetNotNullSql(string TableName, string ColumnName, string DataType)

Parameters

TableName string

ColumnName string

DataType string

Returns

string

SetTableGeneratorTo(string, string, int)

Attempts to set a generator/sequencer or identity column to Value.

VERY DANGEROOUS.

public override void SetTableGeneratorTo(string ConnectionString, string TableName, int Value)

Parameters

ConnectionString string

TableName string

Value int