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