Class NpgsqlDataSource

Namespace

Npgsql

Assembly

Npgsql.dll

public abstract class NpgsqlDataSource : DbDataSource, IDisposable, IAsyncDisposable

Inheritance

object

DbDataSource

NpgsqlDataSource

Implements

IDisposable

IAsyncDisposable

Derived

NpgsqlMultiHostDataSource

Inherited Members

DbDataSource.Dispose()

DbDataSource.DisposeAsync()

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Properties

ConnectionString

public override string ConnectionString { get; }

Property Value

string

Password

Manually sets the password to be used the next time a physical connection is opened. Consider using UsePeriodicPasswordProvider(Func<NpgsqlConnectionStringBuilder, CancellationToken, ValueTask<string>>?, TimeSpan, TimeSpan) instead.

public string Password { set; }

Property Value

string

Methods

Create(NpgsqlConnectionStringBuilder)

Creates a new NpgsqlDataSource for the given connectionStringBuilder.

public static NpgsqlDataSource Create(NpgsqlConnectionStringBuilder connectionStringBuilder)

Parameters

connectionStringBuilder NpgsqlConnectionStringBuilder

Returns

NpgsqlDataSource

Create(string)

Creates a new NpgsqlDataSource for the given connectionString.

public static NpgsqlDataSource Create(string connectionString)

Parameters

connectionString string

Returns

NpgsqlDataSource

CreateBatch()

Creates a batch ready for use against this NpgsqlDataSource.

public NpgsqlBatch CreateBatch()

Returns

NpgsqlBatch

CreateCommand(string?)

Creates a command ready for use against this NpgsqlDataSource.

public NpgsqlCommand CreateCommand(string? commandText = null)

Parameters

commandText string

An optional SQL for the command.

Returns

NpgsqlCommand

CreateConnection()

public NpgsqlConnection CreateConnection()

Returns

NpgsqlConnection

CreateDbBatch()

protected override DbBatch CreateDbBatch()

Returns

DbBatch

CreateDbCommand(string?)

protected override DbCommand CreateDbCommand(string? commandText = null)

Parameters

commandText string

Returns

DbCommand

CreateDbConnection()

protected override DbConnection CreateDbConnection()

Returns

DbConnection

Dispose(bool)

protected override sealed void Dispose(bool disposing)

Parameters

disposing bool

DisposeAsyncBase()

protected virtual ValueTask DisposeAsyncBase()

Returns

ValueTask

DisposeAsyncCore()

protected override sealed ValueTask DisposeAsyncCore()

Returns

ValueTask

DisposeBase()

protected virtual void DisposeBase()

OpenConnection()

public NpgsqlConnection OpenConnection()

Returns

NpgsqlConnection

OpenConnectionAsync(CancellationToken)

public ValueTask<NpgsqlConnection> OpenConnectionAsync(CancellationToken cancellationToken = default)

Parameters

cancellationToken CancellationToken

Returns

ValueTask<NpgsqlConnection>

OpenDbConnection()

protected override DbConnection OpenDbConnection()

Returns

DbConnection

OpenDbConnectionAsync(CancellationToken)

protected override ValueTask<DbConnection> OpenDbConnectionAsync(CancellationToken cancellationToken = default)

Parameters

cancellationToken CancellationToken

Returns

ValueTask<DbConnection>