Class NpgsqlDataAdapter
This class represents an adapter from many commands: select, update, insert and delete to fill a DataSet.
Inherited Members
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
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
OnRowUpdated(RowUpdatedEventArgs)
Raise the RowUpdated event.
Declaration
protected override void OnRowUpdated(RowUpdatedEventArgs value)
Parameters
Type | Name | Description |
---|---|---|
RowUpdatedEventArgs | value |
Overrides
OnRowUpdating(RowUpdatingEventArgs)
Raise the RowUpdating event.
Declaration
protected override void OnRowUpdating(RowUpdatingEventArgs value)
Parameters
Type | Name | Description |
---|---|---|
RowUpdatingEventArgs | value |
Overrides
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 |