Search Results for

    Show / Hide Table of Contents

    Class NpgsqlDataAdapter

    This class represents an adapter from many commands: select, update, insert and delete to fill a DataSet.

    Inheritance
    Object
    MarshalByRefObject
    Component
    DataAdapter
    DbDataAdapter
    NpgsqlDataAdapter
    Implements
    IComponent
    IDisposable
    IDbDataAdapter
    IDataAdapter
    ICloneable
    Inherited Members
    DbDataAdapter.DefaultSourceTableName
    DbDataAdapter.AddToBatch(IDbCommand)
    DbDataAdapter.ClearBatch()
    DbDataAdapter.Dispose(Boolean)
    DbDataAdapter.ExecuteBatch()
    DbDataAdapter.Fill(DataSet)
    DbDataAdapter.Fill(DataSet, Int32, Int32, String)
    DbDataAdapter.Fill(DataSet, Int32, Int32, String, IDbCommand, CommandBehavior)
    DbDataAdapter.Fill(DataSet, String)
    DbDataAdapter.Fill(DataTable)
    DbDataAdapter.Fill(DataTable, IDbCommand, CommandBehavior)
    DbDataAdapter.Fill(DataTable[], Int32, Int32, IDbCommand, CommandBehavior)
    DbDataAdapter.Fill(Int32, Int32, DataTable[])
    DbDataAdapter.FillSchema(DataSet, SchemaType)
    DbDataAdapter.FillSchema(DataSet, SchemaType, IDbCommand, String, CommandBehavior)
    DbDataAdapter.FillSchema(DataSet, SchemaType, String)
    DbDataAdapter.FillSchema(DataTable, SchemaType)
    DbDataAdapter.FillSchema(DataTable, SchemaType, IDbCommand, CommandBehavior)
    DbDataAdapter.GetBatchedParameter(Int32, Int32)
    DbDataAdapter.GetBatchedRecordsAffected(Int32, Int32, Exception)
    DbDataAdapter.GetFillParameters()
    DbDataAdapter.InitializeBatching()
    DbDataAdapter.ICloneable.Clone()
    DbDataAdapter.TerminateBatching()
    DbDataAdapter.Update(DataRow[])
    DbDataAdapter.Update(DataRow[], DataTableMapping)
    DbDataAdapter.Update(DataSet)
    DbDataAdapter.Update(DataSet, String)
    DbDataAdapter.Update(DataTable)
    DbDataAdapter.FillCommandBehavior
    DbDataAdapter.IDbDataAdapter.DeleteCommand
    DbDataAdapter.IDbDataAdapter.InsertCommand
    DbDataAdapter.IDbDataAdapter.SelectCommand
    DbDataAdapter.IDbDataAdapter.UpdateCommand
    DbDataAdapter.UpdateBatchSize
    DataAdapter.CloneInternals()
    DataAdapter.CreateTableMappings()
    DataAdapter.Fill(DataSet, String, IDataReader, Int32, Int32)
    DataAdapter.Fill(DataTable, IDataReader)
    DataAdapter.Fill(DataTable[], IDataReader, Int32, Int32)
    DataAdapter.FillSchema(DataSet, SchemaType, String, IDataReader)
    DataAdapter.FillSchema(DataTable, SchemaType, IDataReader)
    DataAdapter.HasTableMappings()
    DataAdapter.OnFillError(FillErrorEventArgs)
    DataAdapter.ShouldSerializeTableMappings()
    DataAdapter.AcceptChangesDuringFill
    DataAdapter.AcceptChangesDuringUpdate
    DataAdapter.ContinueUpdateOnError
    DataAdapter.FillLoadOption
    DataAdapter.MissingMappingAction
    DataAdapter.MissingSchemaAction
    DataAdapter.ReturnProviderSpecificTypes
    DataAdapter.IDataAdapter.TableMappings
    DataAdapter.TableMappings
    DataAdapter.FillError
    Component.Dispose()
    Component.GetService(Type)
    Component.ToString()
    Component.CanRaiseEvents
    Component.Container
    Component.DesignMode
    Component.Events
    Component.Site
    Component.Disposed
    MarshalByRefObject.GetLifetimeService()
    MarshalByRefObject.InitializeLifetimeService()
    MarshalByRefObject.MemberwiseClone(Boolean)
    Object.Equals(Object)
    Object.Equals(Object, Object)
    Object.GetHashCode()
    Object.GetType()
    Object.MemberwiseClone()
    Object.ReferenceEquals(Object, Object)
    Namespace: Npgsql
    Assembly: Npgsql.dll
    Syntax
    public sealed class NpgsqlDataAdapter : DbDataAdapter, IComponent, IDisposable, IDbDataAdapter, IDataAdapter, ICloneable

    Constructors

    NpgsqlDataAdapter()

    Default constructor.

    Declaration
    public NpgsqlDataAdapter()

    NpgsqlDataAdapter(NpgsqlCommand)

    Constructor.

    Declaration
    public NpgsqlDataAdapter(NpgsqlCommand selectCommand)
    Parameters
    Type Name Description
    NpgsqlCommand selectCommand

    NpgsqlDataAdapter(String, NpgsqlConnection)

    Constructor.

    Declaration
    public NpgsqlDataAdapter(string selectCommandText, NpgsqlConnection selectConnection)
    Parameters
    Type Name Description
    String selectCommandText
    NpgsqlConnection selectConnection

    NpgsqlDataAdapter(String, String)

    Constructor.

    Declaration
    public NpgsqlDataAdapter(string selectCommandText, string selectConnectionString)
    Parameters
    Type Name Description
    String selectCommandText
    String selectConnectionString

    Properties

    DeleteCommand

    Delete command.

    Declaration
    public NpgsqlCommand DeleteCommand { get; set; }
    Property Value
    Type Description
    NpgsqlCommand

    InsertCommand

    Insert command.

    Declaration
    public NpgsqlCommand InsertCommand { get; set; }
    Property Value
    Type Description
    NpgsqlCommand

    SelectCommand

    Select command.

    Declaration
    public NpgsqlCommand SelectCommand { get; set; }
    Property Value
    Type Description
    NpgsqlCommand

    UpdateCommand

    Update command.

    Declaration
    public NpgsqlCommand UpdateCommand { get; set; }
    Property Value
    Type Description
    NpgsqlCommand

    Methods

    CreateRowUpdatedEvent(DataRow, IDbCommand, StatementType, DataTableMapping)

    Create row updated event.

    Declaration
    protected override RowUpdatedEventArgs CreateRowUpdatedEvent(DataRow dataRow, IDbCommand command, StatementType statementType, DataTableMapping tableMapping)
    Parameters
    Type Name Description
    DataRow dataRow
    IDbCommand command
    StatementType statementType
    DataTableMapping tableMapping
    Returns
    Type Description
    RowUpdatedEventArgs
    Overrides
    DbDataAdapter.CreateRowUpdatedEvent(DataRow, IDbCommand, StatementType, DataTableMapping)

    CreateRowUpdatingEvent(DataRow, IDbCommand, StatementType, DataTableMapping)

    Create row updating event.

    Declaration
    protected override RowUpdatingEventArgs CreateRowUpdatingEvent(DataRow dataRow, IDbCommand command, StatementType statementType, DataTableMapping tableMapping)
    Parameters
    Type Name Description
    DataRow dataRow
    IDbCommand command
    StatementType statementType
    DataTableMapping tableMapping
    Returns
    Type Description
    RowUpdatingEventArgs
    Overrides
    DbDataAdapter.CreateRowUpdatingEvent(DataRow, IDbCommand, StatementType, DataTableMapping)

    OnRowUpdated(RowUpdatedEventArgs)

    Raise the RowUpdated event.

    Declaration
    protected override void OnRowUpdated(RowUpdatedEventArgs value)
    Parameters
    Type Name Description
    RowUpdatedEventArgs value
    Overrides
    DbDataAdapter.OnRowUpdated(RowUpdatedEventArgs)

    OnRowUpdating(RowUpdatingEventArgs)

    Raise the RowUpdating event.

    Declaration
    protected override void OnRowUpdating(RowUpdatingEventArgs value)
    Parameters
    Type Name Description
    RowUpdatingEventArgs value
    Overrides
    DbDataAdapter.OnRowUpdating(RowUpdatingEventArgs)

    Events

    RowUpdated

    Row updated event.

    Declaration
    public event NpgsqlRowUpdatedEventHandler RowUpdated
    Event Type
    Type Description
    NpgsqlRowUpdatedEventHandler

    RowUpdating

    Row updating event.

    Declaration
    public event NpgsqlRowUpdatingEventHandler RowUpdating
    Event Type
    Type Description
    NpgsqlRowUpdatingEventHandler

    Implements

    System.ComponentModel.IComponent
    System.IDisposable
    System.Data.IDbDataAdapter
    System.Data.IDataAdapter
    System.ICloneable
    In This Article
    Back to top © Copyright 2022 The Npgsql Development Team