ページの先頭行へ戻る
Symfoware Server V12.0.0 アプリケーション開発ガイド
FUJITSU Software

E.3 .NET Data Provider

Fujitsu Npgsql .NET Data Providerを利用して、アプリケーション開発するには2つの方法があります。

以下の表は、System.Data.Common名前空間のAPIをサポートしているかを示しています。なお、「Npgsql拡張API」と書かれたAPIは、System.Data.Common名前空間には存在せず、Npgsqlが独自に拡張したAPIです。

  

表E.1 リファレンス

System.Data.Common
のクラス名

Fujitsu Npgsql .NET Data Provider
のクラス名

メソッド(M)/関数(F)/プロパティ(P)

サポート状況

備考

名称

修飾子

DbCommand

NpgsqlCommand

CommandText

Public Property

  

CommandTimeout

Public Property

  

CommandType

Public Property

  

Connection

Public Property

  

Container

Public Property

  

DesignTimeVisible

Public Property

  

Parameters

Public Property

  

Site

Public Property

  

Transaction

Public Property

  

UpdatedRowSource

Public Property

  

LastInsertedOID

Public Property

Npgsql拡張API

NpgsqlCommand

Public Constructor

Npgsql拡張API

Cancel

Public method

  

Clone

Public method

  

CreateObjRef

Public method

  

CreateParameter

Public method

  

Dispose

Public method

  

Equals

Public method

  

ExecuteNonQuery

Public method

  

ExecuteReader

Public method

  

ExecuteScalar

Public method

  

GetHashCode

Public method

  

GetLifetimeService

Public method

  

GetType

Public method

  

InitializeLifetimeService

Public method

  

Prepare

Public method

  

ResetCommandTimeout

Public method

×

  

ToString

Public method

  

Disposed

Public event

  

DbCommandBuilder

NpgsqlCommandBuilder

CatalogLocation

Public Property

  

CatalogSeparator

Public Property

  

ConflictOption

Public Property

  

Container

Public Property

  

DataAdapter

Public Property

  

SchemaSeparator

Public Property

  

SetAllValues

Public Property

  

QuotePrefix

Public Property

  

QuoteSuffix

Public Property

  

Site

Public Property

  

NpgsqlCommandBuilder

Public Constructor

Npgsql拡張API

CreateObjRef

Public method

  

Dispose

Public method

  

Equals

Public method

  

GetDeleteCommand

Public method

  

GetHashCode

Public method

  

GetInsertCommand

Public method

  

GetLifetimeService

Public method

  

GetType

Public method

  

GetUpdateCommand

Public method

  

InitializeLifetimeService

Public method

  

QuoteIdentifier

Public method

  

RefreshSchema

Public method

  

ToString

Public method

  

UnquoteIdentifier

Public method

  

Disposed

Public event

  

DbConnection

NpgsqlConnection

ConnectionString

Public Property

  

ConnectionTimeout

Public Property

  

Container

Public Property

  

Database

Public Property

  

Datasource

Public Property

  

Host

Public Property

  

Port

Public Property

  

ServerVersion

Public Property

  

Site

Public Property

  

State

Public Property

  

BackendProtocolVersion

Public Property

Npgsql拡張API

ConnectionLifeTime

Public Property

Npgsql拡張API

CommandTimeout

Public Property

Npgsql拡張API

FullState

Public Property

Npgsql拡張API

NpgsqlCompatibilityVersion

Public Property

Npgsql拡張API

PostgreSqlVersion

Public Property

Npgsql拡張API

PreloadReader

Public Property

Npgsql拡張API

ProcessID

Public Property

Npgsql拡張API

SSL

Public Property

Npgsql拡張API

SyncNotification

Public Property

Npgsql拡張API

UseExtendedTypes

Public Property

Npgsql拡張API

NpgsqlConnection

Public Constructor

Npgsql拡張API

BeginTransaction

Public method

  

ChangeDatabase

Public method

  

ClearPool

Public method

  

Clone

Public method

  

Close

Public method

  

CreateCommand

Public method

  

CreateObjRef

Public method

  

Dispose

Public method

  

Equals

Public method

  

GetHashCode

Public method

  

GetLifetimeService

Public method

  

GetSchema

Public method

  

GetType

Public method

  

InitializeLifetimeService

Public method

  

Open

Public method

  

ToString

Public method

  

EnlistTransaction

Public method

  

Disposed

Public event

  

StateChange

Public event

  

CertificateSelectionCallback

Public event

Npgsql拡張API

CertificateValidationCallback

Public event

Npgsql拡張API

Notice

Public event

Npgsql拡張API

Notification

Public event

Npgsql拡張API

PrivateKeySelectionCallback

Public event

Npgsql拡張API

ProvideClientCertificatesCallback

Public event

Npgsql拡張API

DbConnectionStringBuilder

DbConnectionStringBuilder

BrowsableConnectionString

Public Property

  

ConnectionLifetime

Public Property

  

ConnectionString

Public Property

  

Count

Public Property

  

IsFixedSize

Public Property

  

IsReadOnly

Public Property

  

Item

Public Property

  

Keys

Public Property

  

MaxPoolSize

Public Property

  

MinPoolSize

Public Property

  

Password

Public Property

  

Pooling

Public Property

  

Port

Public Property

  

Values

Public Property

  

CommandTimeout

Public Property

Npgsql拡張API

Compatible

Public Property

Npgsql拡張API

Database

Public Property

Npgsql拡張API

Encoding

Public Property

Npgsql拡張API

Enlist

Public Property

Npgsql拡張API

Host

Public Property

Npgsql拡張API

IntegratedSecurity

Public Property

Npgsql拡張API

PreloadReader

Public Property

Npgsql拡張API

Protocol

Public Property

Npgsql拡張API

SearchPath

Public Property

Npgsql拡張API

SSL

Public Property

Npgsql拡張API

SslMode

Public Property

Npgsql拡張API

SyncNotification

Public Property

Npgsql拡張API

Timeout

Public Property

Npgsql拡張API

UseExtendedTypes

Public Property

Npgsql拡張API

UserName

Public Property

Npgsql拡張API

NpgsqlConnectionStringBuilder

Public Constructor

Npgsql拡張API

Add

Public method

  

Clear

Public method

  

ContainsKey

Public method

  

Equals

Public method

  

EquivalentTo

Public method

  

GetHashCode

Public method

  

GetType

Public method

  

Remove

Public method

  

ShouldSerialize

Public method

  

ToString

Public method

  

TryGetValue

Public method

  

Clone

Public method

Npgsql拡張API

DbDataAdapter

NpgsqlDataAdapter

AcceptChangesDuringFill

Public Property

  

AcceptChangesDuringUpdate

Public Property

  

Container

Public Property

  

ContinueUpdateOnError

Public Property

  

DeleteCommand

Public Property

  

FillLoadOption

Public Property

  

InsertCommand

Public Property

  

MissingMappingAction

Public Property

  

MissingSchemaAction

Public Property

  

ReturnProviderSpecificTypes

Public Property

  

SelectCommand

Public Property

  

Site

Public Property

  

TableMappings

Public Property

  

UpdateBatchSize

Public Property

  

UpdateCommand

Public Property

  

NpgsqlDataAdapter

Public Constructor

Npgsql拡張API

CreateObjRef

Public method

  

Dispose

Public method

  

Equals

Public method

  

Fill

Public method

  

FillSchema

Public method

  

GetFillParameters

Public method

  

GetHashCode

Public method

  

GetLifetimeService

Public method

  

GetType

Public method

  

InitializeLifetimeService

Public method

  

ToString

Public method

  

Update

Public method

  

ResetFillLoadOption

Public method

Npgsql拡張API

ShouldSerializeAcceptChangesDuringFill

Public method

Npgsql拡張API

ShouldSerializeFillLoadOption

Public method

Npgsql拡張API

Disposed

Public event

  

FillError

Public event

  

RowUpdated

Public event

  

RowUpdating

Public event

  

DbDataReader

NpgsqlDataReader

Depth

Public Property

  

IsClosed

Public Property

  

RecordsAffected

Public Property

  

FieldCount

Public Property

  

HasRows

Public Property

  

Item

Public Property

  

VisibleFieldCount

Public Property

  

Public Constructor

Public method

  

Close

Public method

  

CreateObjRef

Public method

  

Equals

Public method

  

GetBoolean

Public method

  

GetByte

Public method

×

  

GetBytes

Public method

  

GetChar

Public method

  

GetChars

Public method

  

GetDataTypeName

Public method

  

GetDateTime

Public method

  

GetDecimal

Public method

  

GetDouble

Public method

  

GetFieldType

Public method

  

GetFloat

Public method

  

GetGuid

Public method

  

GetHashCode

Public method

  

GetInt16

Public method

  

GetInt32

Public method

  

GetInt64

Public method

  

GetLifetimeService

Public method

  

GetName

Public method

  

GetOrdinal

Public method

  

GetSchemaTable

Public method

  

GetString

Public method

  

GetType

Public method

  

GetValue

Public method

  

GetValues

Public method

  

InitializeLifetimeService

Public method

  

IsDBNull

Public method

  

NextResult

Public method

  

Read

Public method

  

ToString

Public method

  

Dispose

Public method

  

GetBitString

Public method

Npgsql拡張API

GetData

Public method

  

GetDataTypeOID

Public method

Npgsql拡張API

GetDate

Public method

Npgsql拡張API

GetEnumerator

Public method

  

GetFieldDbType

Public method

Npgsql拡張API

GetFieldNpgsqlDbType

Public method

Npgsql拡張API

GetInterval

Public method

Npgsql拡張API

GetProviderSpecificFieldType

Public method

  

GetProviderSpecificValue

Public method

  

GetProviderSpecificValues

Public method

  

GetTime

Public method

Npgsql拡張API

GetTimeStamp

Public method

Npgsql拡張API

GetTimeStampTZ

Public method

Npgsql拡張API

GetTimeTZ

Public method

Npgsql拡張API

HasOrdinal

Public method

Npgsql拡張API

ReaderClosed

Public event

Npgsql拡張API

Finalize

Protect method

  

MemberwiseClone

Protect method

  

Dispose

Protect method

Npgsql拡張API

GetDbDataReader

Protect method

Npgsql拡張API

SendClosedEvent

Protect method

Npgsql拡張API

DBError

NpgsqlError

Message

Public Property

  

Number

Public Property

×

  

Source

Public Property

×

  

Code

Public Property

Npgsql拡張API

Detail

Public Property

Npgsql拡張API

ErrorSql

Public Property

Npgsql拡張API

File

Public Property

Npgsql拡張API

Hint

Public Property

Npgsql拡張API

InternalPosition

Public Property

Npgsql拡張API

InternalQuery

Public Property

Npgsql拡張API

Line

Public Property

Npgsql拡張API

Position

Public Property

Npgsql拡張API

Routine

Public Property

Npgsql拡張API

Severity

Public Property

Npgsql拡張API

Where

Public Property

Npgsql拡張API

NpgsqlError

Public Constructor

Npgsql拡張API

Equals

Public method

  

GetHashCode

Public method

  

GetType

Public method

  

ToString

Public method

  

DBErrorCollection

未サポート

Count

Public Property

×

  

Item

Public Property

×

  

CopyTo

Public method

×

  

Equals

Public method

×

  

GetHashCode

Public method

×

  

GetType

Public method

×

  

ToString

Public method

×

  

Finalize

Protect method

×

  

MemberwiseClone

Protect method

×

  

DBException

NpgsqlException

Data

Public Property

  

ErrorCode

Public Property

  

Errors

Public Property

  

HelpLink

Public Property

  

InnerException

Public Property

  

Message

Public Property

  

Number

Public Property

×

  

Source

Public Property

  

StackTrace

Public Property

  

TargetSite

Public Property

  

BaseMessage

Public Property

Npgsql拡張API

Code

Public Property

Npgsql拡張API

Detail

Public Property

Npgsql拡張API

ErrorSql

Public Property

Npgsql拡張API

File

Public Property

Npgsql拡張API

Hint

Public Property

Npgsql拡張API

Item

Public Property

Npgsql拡張API

Line

Public Property

Npgsql拡張API

Position

Public Property

Npgsql拡張API

Routine

Public Property

Npgsql拡張API

Severity

Public Property

Npgsql拡張API

Where

Public Property

Npgsql拡張API

NpgsqlException

Public Constructor

Npgsql拡張API

Equals

Public method

  

GetBaseException

Public method

  

GetHashCode

Public method

  

GetObjectData

Public method

  

GetType

Public method

  

ToString

Public method

  

DbProviderFactory

NpgsqlProviderFactory

Instance

Public field

  

CanCreateDataSourceEnumerator

Public Property

  

NpgsqlFactory

Public Constructor

Npgsql拡張API

CreateCommand

Public method

  

CreateCommandBuilder

Public method

  

CreateConnection

Public method

  

CreateConnectionStringBuilder

Public method

  

CreateDataAdapter

Public method

  

CreateDataSourceEnumerator

Public method

  

CreateParameter

Public method

  

CreatePermission

Public method

  

Equals

Public method

  

GetHashCode

Public method

  

GetType

Public method

  

ToString

Public method

  

GetService

Public method

Npgsql拡張API

DBInfoMessageEventArgs

未サポート

Errors

Public Property

×

  

Message

Public Property

×

  

Source

Public Property

×

  

DBParameter

NpgsqlParameter

DbType

Public Property

  

Direction

Public Property

  

IsNullable

Public Property

  

ParameterName

Public Property

  

Precision

Public Property

  

Scale

Public Property

  

Size

Public Property

  

SourceColumn

Public Property

  

SourceVersion

Public Property

  

Value

Public Property

  

NpgsqlDbType

Public Property

Npgsql拡張API

NpgsqlValue

Public Property

Npgsql拡張API

SourceColumnNullMapping

Public Property

  

UseCast

Public Property

Npgsql拡張API

NpgsqlParameter

Public Constructor

Npgsql拡張API

CreateObjRef

Public method

  

Equals

Public method

  

GetHashCode

Public method

  

GetLifetimeService

Public method

  

GetType

Public method

  

InitializeLifetimeService

Public method

  

ToString

Public method

  

Clone

Public method

  

ResetDbType

Public method

  

Finalize

Protect method

×

  

MemberwiseClone

Protect method

×

  

DBParameterCollection

NpgsqlParameterCollection

Count

Public Property

  

Item

Public Property

  

IsFixedSize

Public Property

Npgsql拡張API

IsReadOnly

Public Property

Npgsql拡張API

IsSynchronized

Public Property

Npgsql拡張API

SyncRoot

Public Property

Npgsql拡張API

NpgsqlParameterCollection

Public Constructor

Npgsql拡張API

Add

Public method

  

AddRange

Public method

  

Clear

Public method

  

Contains

Public method

  

CopyTo

Public method

  

IndexOf

Public method

  

Insert

Public method

  

Remove

Public method

  

RemoveAt

Public method

  

CreateObjRef

Public method

  

Equals

Public method

  

GetHashCode

Public method

  

GetLifetimeService

Public method

  

GetType

Public method

  

InitializeLifetimeService

Public method

  

ToString

Public method

  

AddWithValue

Public method

Npgsql拡張API

TryGetValue

Public method

Npgsql拡張API

GetEnumerator

Public method

Npgsql拡張API

Finalize

Protect method

×

  

MemberwiseClone

Protect method

×

  

DBDataPermission

未サポート

AllowBlankPassword

Public Property

×

  

Add

Public method

×

  

Assert

Public method

×

  

Copy

Public method

×

  

Demand

Public method

×

  

Deny

Public method

×

  

Equals

Public method

×

  

FromXml

Public method

×

  

GetHashCode

Public method

×

  

GetType

Public method

×

  

Intersect

Public method

×

  

IsSubsetOf

Public method

×

  

IsUnrestricted

Public method

×

  

PermitOnly

Public method

×

  

ToString

Public method

×

  

ToXml

Public method

×

  

Union

Public method

×

  

DBDataPermissionAttribute

未サポート

Action

Public Property

×

  

AllowBlankPassword

Public Property

×

  

ConnectionString

Public Property

×

  

KeyRestrictionBehavior

Public Property

×

  

KeyRestrictions

Public Property

×

  

TypeId

Public Property

×

  

Unrestricted

Public Property

×

  

CreatePermission

Public method

×

  

Equals

Public method

×

  

GetHashCode

Public method

×

  

GetType

Public method

×

  

IsDefaultAttribute

Public method

×

  

Match

Public method

×

  

ShouldSerializeConnectionString

Public method

×

  

ShouldSerializeKeyRestrictions

Public method

×

  

ToString

Public method

×

  

RowUpdatedEventArgs

NpgsqlRowUpdatedEventArgs

Command

Public Property

  

Errors

Public Property

  

Row

Public Property

  

StatementType

Public Property

  

Status

Public Property

  

TableMapping

Public Property

  

RecordsAffected

Public Property

  

RowCount

Public Property

Npgsql拡張API

NpgsqlRowUpdatedEventArgs

Public Constructor

Npgsql拡張API

Equals

Public method

  

GetHashCode

Public method

  

GetType

Public method

  

ToString

Public method

  

CopyToRows

Public method

Npgsql拡張API

Finalize

Protect method

  

MemberwiseClone

Protect method

  

RowUpdatingEventArgs

NpgsqlRowUpdatingEventArgs

Command

Public Property

  

Errors

Public Property

  

Row

Public Property

  

StatementType

Public Property

  

Status

Public Property

  

TableMapping

Public Property

  

NpgsqlRowUpdatingEventArgs

Public Constructor

Npgsql拡張API

Equals

Public method

  

GetHashCode

Public method

  

GetType

Public method

  

ToString

Public method

  

BaseCommand

Protect Property

  

Finalize

Protect method

  

MemberwiseClone

Protect method

  

DBTransaction

NpgsqlTransaction

Connection

Public Property

  

IsolationLevel

Public Property

  

NpgsqlTransaction

Public Constructor

Npgsql拡張API

Commit

Public method

  

CreateObjRef

Public method

  

Dispose

Public method

  

Equals

Public method

  

GetHashCode

Public method

  

GetLifetimeService

Public method

  

GetType

Public method

  

InitializeLifetimeService

Public method

  

Rollback

Public method

  

ToString

Public method

  

Save

Public method

  

Finalize

Protect method

×

  

MemberwiseClone

Protect method

×

  

該当なし

NpgsqlNotificationEventArgs

AdditionalInformation

Public Property

Npgsql拡張API

Condition

Public Property

Npgsql拡張API

PID

Public Property

Npgsql拡張API

Equals

Public method

Npgsql拡張API

GetHashCode

Public method

Npgsql拡張API

GetType

Public method

Npgsql拡張API

ToString

Public method

Npgsql拡張API

Finalize

Protect method

Npgsql拡張API

MemberwiseClone

Protect method

Npgsql拡張API

該当なし

NpgsqlEventLog

EchoMessages

Public Property

Npgsql拡張API

Level

Public Property

Npgsql拡張API

LogName

Public Property

Npgsql拡張API

Equals

Public method

Npgsql拡張API

GetHashCode

Public method

Npgsql拡張API

GetType

Public method

Npgsql拡張API

ToString

Public method

Npgsql拡張API

Finalize

Protect method

Npgsql拡張API

MemberwiseClone

Protect method

Npgsql拡張API

該当なし

NpgsqlCopyFormat

FieldCount

Public Property

Npgsql拡張API

IsBinary

Public Property

Npgsql拡張API

Equals

Public method

Npgsql拡張API

FieldIsBinary

Public method

Npgsql拡張API

GetHashCode

Public method

Npgsql拡張API

GetType

Public method

Npgsql拡張API

ToString

Public method

Npgsql拡張API

該当なし

NpgsqlCopyIn

CopyBufferSize

Public Property

Npgsql拡張API

CopyStream

Public Property

Npgsql拡張API

FieldCount

Public Property

Npgsql拡張API

IsActive

Public Property

Npgsql拡張API

IsBinary

Public Property

Npgsql拡張API

NpgsqlCommand

Public Property

Npgsql拡張API

Cancel

Public method

Npgsql拡張API

End

Public method

Npgsql拡張API

Equals

Public method

Npgsql拡張API

FieldIsBinary

Public method

Npgsql拡張API

GetHashCode

Public method

Npgsql拡張API

GetType

Public method

Npgsql拡張API

Start

Public method

Npgsql拡張API

ToString

Public method

Npgsql拡張API

Finalize

Protect method

Npgsql拡張API

MemberwiseClone

Protect method

Npgsql拡張API

該当なし

NpgsqlCopyOut

CopyStream

Public Property

Npgsql拡張API

FieldCount

Public Property

Npgsql拡張API

IsActive

Public Property

Npgsql拡張API

IsBinary

Public Property

Npgsql拡張API

NpgsqlCommand

Public Property

Npgsql拡張API

Read

Public Property

Npgsql拡張API

End

Public method

Npgsql拡張API

Equals

Public method

Npgsql拡張API

FieldIsBinary

Public method

Npgsql拡張API

GetHashCode

Public method

Npgsql拡張API

GetType

Public method

Npgsql拡張API

Start

Public method

Npgsql拡張API

ToString

Public method

Npgsql拡張API

Finalize

Protect method

Npgsql拡張API

MemberwiseClone

Protect method

Npgsql拡張API

該当なし

NpgsqlCopySerializer

DEFAULT_BUFFER_SIZE

Public field

Npgsql拡張API

DEFAULT_DELIMITER

Public field

Npgsql拡張API

DEFAULT_ESCAPE

Public field

Npgsql拡張API

DEFAULT_NULL

Public field

Npgsql拡張API

DEFAULT_QUOTE

Public field

Npgsql拡張API

DEFAULT_SEPARATOR

Public field

Npgsql拡張API

EscapeSequenceFor

Protect method

Npgsql拡張API

BufferSize

Public Property

Npgsql拡張API

Delimiter

Public Property

Npgsql拡張API

Escape

Public Property

Npgsql拡張API

IsActive

Public Property

Npgsql拡張API

Null

Public Property

Npgsql拡張API

Separator

Public Property

Npgsql拡張API

ToStream

Public Property

Npgsql拡張API

AddBool

Public method

Npgsql拡張API

AddDateTime

Public method

Npgsql拡張API

AddInt32

Public method

Npgsql拡張API

AddInt64

Public method

Npgsql拡張API

AddNull

Public method

Npgsql拡張API

AddNumber

Public method

Npgsql拡張API

AddString

Public method

Npgsql拡張API

Close

Public method

Npgsql拡張API

EndRow

Public method

Npgsql拡張API

Equals

Public method

Npgsql拡張API

Flush

Public method

Npgsql拡張API

FlushFields

Public method

Npgsql拡張API

FlushRows

Public method

Npgsql拡張API

GetHashCode

Public method

Npgsql拡張API

GetType

Public method

Npgsql拡張API

ToString

Public method

Npgsql拡張API

EscapeSequenceBytes

Protect Property

Npgsql拡張API

SpaceInBuffer

Protect Property

Npgsql拡張API

StringsToEscape

Protect Property

Npgsql拡張API

AddBytes

Protect method

Npgsql拡張API

FieldAdded

Protect method

Npgsql拡張API

Finalize

Protect method

Npgsql拡張API

MakeRoomForBytes

Protect method

Npgsql拡張API

MemberwiseClone

Protect method

Npgsql拡張API

PrefixField

Protect method

Npgsql拡張API

該当なし

NpgsqlNoticeEventArgs

Notice

Public field

Npgsql拡張API

Equals

Public method

Npgsql拡張API

GetHashCode

Public method

Npgsql拡張API

GetType

Public method

Npgsql拡張API

ToString

Public method

Npgsql拡張API

Finalize

Protect method

Npgsql拡張API

MemberwiseClone

Protect method

Npgsql拡張API

該当なし

ServerVersion

ProtocolVersion2

Public field

Npgsql拡張API

ProtocolVersion3

Public field

Npgsql拡張API

Equality Operator

Public

Npgsql拡張API

Greater Than Operator

Public

Npgsql拡張API

Greater Than Or Equal Operator

Public

Npgsql拡張API

Inequality Operator

Public

Npgsql拡張API

Less Than Operator

Public

Npgsql拡張API

Less Than Or Equal Operator

Public

Npgsql拡張API

Implicit ServerVersion to Version Conversion

Public

Npgsql拡張API

Implicit Version to ServerVersion Conversion

Public

Npgsql拡張API

Major

Public Property

Npgsql拡張API

Minor

Public Property

Npgsql拡張API

Patch

Public Property

Npgsql拡張API

Clone

Public method

Npgsql拡張API

CompareTo

Public method

Npgsql拡張API

Equals

Public method

Npgsql拡張API

GetHashCode

Public method

Npgsql拡張API

GetType

Public method

Npgsql拡張API

ToString

Public method

Npgsql拡張API

○: サポート
×: 未サポート