Search Results for

    Show / Hide Table of Contents

    Class NpgsqlBatch

    Inheritance
    Object
    DbBatch
    NpgsqlBatch
    Implements
    IDisposable
    IAsyncDisposable
    Inherited Members
    DbBatch.CreateBatchCommand()
    DbBatch.Dispose()
    DbBatch.DisposeAsync()
    Object.Equals(Object)
    Object.Equals(Object, Object)
    Object.GetHashCode()
    Object.GetType()
    Object.MemberwiseClone()
    Object.ReferenceEquals(Object, Object)
    Object.ToString()
    Namespace: Npgsql
    Assembly: Npgsql.dll
    Syntax
    public class NpgsqlBatch : DbBatch, IDisposable, IAsyncDisposable

    Constructors

    NpgsqlBatch(NpgsqlConnection, NpgsqlTransaction)

    Initializes a new NpgsqlBatch.

    Declaration
    public NpgsqlBatch(NpgsqlConnection connection = null, NpgsqlTransaction transaction = null)
    Parameters
    Type Name Description
    NpgsqlConnection connection

    A NpgsqlConnection that represents the connection to a PostgreSQL server.

    NpgsqlTransaction transaction

    The NpgsqlTransaction in which the NpgsqlCommand executes.

    Properties

    BatchCommands

    Declaration
    public NpgsqlBatchCommandCollection BatchCommands { get; }
    Property Value
    Type Description
    NpgsqlBatchCommandCollection

    Connection

    Declaration
    public NpgsqlConnection Connection { get; set; }
    Property Value
    Type Description
    NpgsqlConnection

    DbBatchCommands

    Declaration
    protected override DbBatchCommandCollection DbBatchCommands { get; }
    Property Value
    Type Description
    DbBatchCommandCollection
    Overrides
    DbBatch.DbBatchCommands

    DbConnection

    Declaration
    protected override DbConnection DbConnection { get; set; }
    Property Value
    Type Description
    DbConnection
    Overrides
    DbBatch.DbConnection

    DbTransaction

    Declaration
    protected override DbTransaction DbTransaction { get; set; }
    Property Value
    Type Description
    DbTransaction
    Overrides
    DbBatch.DbTransaction

    Timeout

    Declaration
    public override int Timeout { get; set; }
    Property Value
    Type Description
    Int32
    Overrides
    DbBatch.Timeout

    Transaction

    Declaration
    public NpgsqlTransaction Transaction { get; set; }
    Property Value
    Type Description
    NpgsqlTransaction

    Methods

    Cancel()

    Declaration
    public override void Cancel()
    Overrides
    DbBatch.Cancel()

    CreateDbBatchCommand()

    Declaration
    protected override DbBatchCommand CreateDbBatchCommand()
    Returns
    Type Description
    DbBatchCommand
    Overrides
    DbBatch.CreateDbBatchCommand()

    ExecuteDbDataReader(CommandBehavior)

    Declaration
    protected override DbDataReader ExecuteDbDataReader(CommandBehavior behavior)
    Parameters
    Type Name Description
    CommandBehavior behavior
    Returns
    Type Description
    DbDataReader
    Overrides
    DbBatch.ExecuteDbDataReader(CommandBehavior)

    ExecuteDbDataReaderAsync(CommandBehavior, CancellationToken)

    Declaration
    protected override async Task<DbDataReader> ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
    Parameters
    Type Name Description
    CommandBehavior behavior
    CancellationToken cancellationToken
    Returns
    Type Description
    Task<DbDataReader>
    Overrides
    DbBatch.ExecuteDbDataReaderAsync(CommandBehavior, CancellationToken)

    ExecuteNonQuery()

    Declaration
    public override int ExecuteNonQuery()
    Returns
    Type Description
    Int32
    Overrides
    DbBatch.ExecuteNonQuery()

    ExecuteNonQueryAsync(CancellationToken)

    Declaration
    public override Task<int> ExecuteNonQueryAsync(CancellationToken cancellationToken = default(CancellationToken))
    Parameters
    Type Name Description
    CancellationToken cancellationToken
    Returns
    Type Description
    Task<Int32>
    Overrides
    DbBatch.ExecuteNonQueryAsync(CancellationToken)

    ExecuteReader(CommandBehavior)

    Declaration
    public NpgsqlDataReader ExecuteReader(CommandBehavior behavior = CommandBehavior.Default)
    Parameters
    Type Name Description
    CommandBehavior behavior
    Returns
    Type Description
    NpgsqlDataReader

    ExecuteReaderAsync(CommandBehavior, CancellationToken)

    Declaration
    public Task<NpgsqlDataReader> ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken = default(CancellationToken))
    Parameters
    Type Name Description
    CommandBehavior behavior
    CancellationToken cancellationToken
    Returns
    Type Description
    Task<NpgsqlDataReader>

    ExecuteReaderAsync(CancellationToken)

    Declaration
    public Task<NpgsqlDataReader> ExecuteReaderAsync(CancellationToken cancellationToken = default(CancellationToken))
    Parameters
    Type Name Description
    CancellationToken cancellationToken
    Returns
    Type Description
    Task<NpgsqlDataReader>

    ExecuteScalar()

    Declaration
    public override object ExecuteScalar()
    Returns
    Type Description
    Object
    Overrides
    DbBatch.ExecuteScalar()

    ExecuteScalarAsync(CancellationToken)

    Declaration
    public override Task<object> ExecuteScalarAsync(CancellationToken cancellationToken = default(CancellationToken))
    Parameters
    Type Name Description
    CancellationToken cancellationToken
    Returns
    Type Description
    Task<Object>
    Overrides
    DbBatch.ExecuteScalarAsync(CancellationToken)

    Prepare()

    Declaration
    public override void Prepare()
    Overrides
    DbBatch.Prepare()

    PrepareAsync(CancellationToken)

    Declaration
    public override Task PrepareAsync(CancellationToken cancellationToken = default(CancellationToken))
    Parameters
    Type Name Description
    CancellationToken cancellationToken
    Returns
    Type Description
    Task
    Overrides
    DbBatch.PrepareAsync(CancellationToken)

    Implements

    System.IDisposable
    System.IAsyncDisposable
    In This Article
    Back to top © Copyright 2022 The Npgsql Development Team