Show / Hide Table of Contents

Class NpgsqlDataAdapter

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

Inheritance
System.Object
System.MarshalByRefObject
System.ComponentModel.Component
System.Data.Common.DataAdapter
System.Data.Common.DbDataAdapter
NpgsqlDataAdapter
Implements
System.ComponentModel.IComponent
System.IDisposable
System.Data.IDbDataAdapter
System.Data.IDataAdapter
System.ICloneable
Inherited Members
System.Data.Common.DbDataAdapter.DefaultSourceTableName
System.Data.Common.DbDataAdapter.AddToBatch(System.Data.IDbCommand)
System.Data.Common.DbDataAdapter.ClearBatch()
System.Data.Common.DbDataAdapter.System.ICloneable.Clone()
System.Data.Common.DbDataAdapter.Dispose(System.Boolean)
System.Data.Common.DbDataAdapter.ExecuteBatch()
System.Data.Common.DbDataAdapter.FillSchema(System.Data.DataTable, System.Data.SchemaType)
System.Data.Common.DbDataAdapter.FillSchema(System.Data.DataSet, System.Data.SchemaType)
System.Data.Common.DbDataAdapter.FillSchema(System.Data.DataSet, System.Data.SchemaType, System.String)
System.Data.Common.DbDataAdapter.FillSchema(System.Data.DataSet, System.Data.SchemaType, System.Data.IDbCommand, System.String, System.Data.CommandBehavior)
System.Data.Common.DbDataAdapter.FillSchema(System.Data.DataTable, System.Data.SchemaType, System.Data.IDbCommand, System.Data.CommandBehavior)
System.Data.Common.DbDataAdapter.Fill(System.Data.DataSet)
System.Data.Common.DbDataAdapter.Fill(System.Data.DataSet, System.String)
System.Data.Common.DbDataAdapter.Fill(System.Data.DataSet, System.Int32, System.Int32, System.String)
System.Data.Common.DbDataAdapter.Fill(System.Data.DataSet, System.Int32, System.Int32, System.String, System.Data.IDbCommand, System.Data.CommandBehavior)
System.Data.Common.DbDataAdapter.Fill(System.Data.DataTable)
System.Data.Common.DbDataAdapter.Fill(System.Int32, System.Int32, System.Data.DataTable[])
System.Data.Common.DbDataAdapter.Fill(System.Data.DataTable, System.Data.IDbCommand, System.Data.CommandBehavior)
System.Data.Common.DbDataAdapter.Fill(System.Data.DataTable[], System.Int32, System.Int32, System.Data.IDbCommand, System.Data.CommandBehavior)
System.Data.Common.DbDataAdapter.GetBatchedParameter(System.Int32, System.Int32)
System.Data.Common.DbDataAdapter.GetBatchedRecordsAffected(System.Int32, System.Int32, System.Exception)
System.Data.Common.DbDataAdapter.GetFillParameters()
System.Data.Common.DbDataAdapter.InitializeBatching()
System.Data.Common.DbDataAdapter.TerminateBatching()
System.Data.Common.DbDataAdapter.Update(System.Data.DataSet)
System.Data.Common.DbDataAdapter.Update(System.Data.DataRow[])
System.Data.Common.DbDataAdapter.Update(System.Data.DataTable)
System.Data.Common.DbDataAdapter.Update(System.Data.DataSet, System.String)
System.Data.Common.DbDataAdapter.Update(System.Data.DataRow[], System.Data.Common.DataTableMapping)
System.Data.Common.DbDataAdapter.System.Data.IDbDataAdapter.DeleteCommand
System.Data.Common.DbDataAdapter.FillCommandBehavior
System.Data.Common.DbDataAdapter.System.Data.IDbDataAdapter.InsertCommand
System.Data.Common.DbDataAdapter.System.Data.IDbDataAdapter.SelectCommand
System.Data.Common.DbDataAdapter.UpdateBatchSize
System.Data.Common.DbDataAdapter.System.Data.IDbDataAdapter.UpdateCommand
System.Data.Common.DataAdapter.ShouldSerializeTableMappings()
System.Data.Common.DataAdapter.HasTableMappings()
System.Data.Common.DataAdapter.CloneInternals()
System.Data.Common.DataAdapter.CreateTableMappings()
System.Data.Common.DataAdapter.FillSchema(System.Data.DataSet, System.Data.SchemaType, System.String, System.Data.IDataReader)
System.Data.Common.DataAdapter.FillSchema(System.Data.DataTable, System.Data.SchemaType, System.Data.IDataReader)
System.Data.Common.DataAdapter.Fill(System.Data.DataSet, System.String, System.Data.IDataReader, System.Int32, System.Int32)
System.Data.Common.DataAdapter.Fill(System.Data.DataTable, System.Data.IDataReader)
System.Data.Common.DataAdapter.Fill(System.Data.DataTable[], System.Data.IDataReader, System.Int32, System.Int32)
System.Data.Common.DataAdapter.OnFillError(System.Data.FillErrorEventArgs)
System.Data.Common.DataAdapter.AcceptChangesDuringFill
System.Data.Common.DataAdapter.AcceptChangesDuringUpdate
System.Data.Common.DataAdapter.ContinueUpdateOnError
System.Data.Common.DataAdapter.FillLoadOption
System.Data.Common.DataAdapter.MissingMappingAction
System.Data.Common.DataAdapter.MissingSchemaAction
System.Data.Common.DataAdapter.ReturnProviderSpecificTypes
System.Data.Common.DataAdapter.TableMappings
System.Data.Common.DataAdapter.System.Data.IDataAdapter.TableMappings
System.Data.Common.DataAdapter.FillError
System.ComponentModel.Component.Dispose()
System.ComponentModel.Component.GetService(System.Type)
System.ComponentModel.Component.ToString()
System.ComponentModel.Component.CanRaiseEvents
System.ComponentModel.Component.Events
System.ComponentModel.Component.Site
System.ComponentModel.Component.Container
System.ComponentModel.Component.DesignMode
System.ComponentModel.Component.Disposed
System.MarshalByRefObject.MemberwiseClone(System.Boolean)
System.MarshalByRefObject.GetLifetimeService()
System.MarshalByRefObject.InitializeLifetimeService()
System.MarshalByRefObject.CreateObjRef(System.Type)
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
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
System.String selectCommandText
NpgsqlConnection selectConnection

NpgsqlDataAdapter(String, String)

Constructor.

Declaration
public NpgsqlDataAdapter(string selectCommandText, string selectConnectionString)
Parameters
Type Name Description
System.String selectCommandText
System.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
System.Data.DataRow dataRow
System.Data.IDbCommand command
System.Data.StatementType statementType
System.Data.Common.DataTableMapping tableMapping
Returns
Type Description
System.Data.Common.RowUpdatedEventArgs
Overrides
System.Data.Common.DbDataAdapter.CreateRowUpdatedEvent(System.Data.DataRow, System.Data.IDbCommand, System.Data.StatementType, System.Data.Common.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
System.Data.DataRow dataRow
System.Data.IDbCommand command
System.Data.StatementType statementType
System.Data.Common.DataTableMapping tableMapping
Returns
Type Description
System.Data.Common.RowUpdatingEventArgs
Overrides
System.Data.Common.DbDataAdapter.CreateRowUpdatingEvent(System.Data.DataRow, System.Data.IDbCommand, System.Data.StatementType, System.Data.Common.DataTableMapping)

OnRowUpdated(RowUpdatedEventArgs)

Raise the RowUpdated event.

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

OnRowUpdating(RowUpdatingEventArgs)

Raise the RowUpdating event.

Declaration
protected override void OnRowUpdating(RowUpdatingEventArgs value)
Parameters
Type Name Description
System.Data.Common.RowUpdatingEventArgs value
Overrides
System.Data.Common.DbDataAdapter.OnRowUpdating(System.Data.Common.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
Back to top Generated by DocFX