Visual Studio.NET Implementation Reference

Visual Studio.NET Implementation Reference

This section lists the properties and methods supported by PSQL with regards to .NET.

OleDbCommand Methods

CreateParameter

CreateParameter

ExecuteNonQuery

Note: This method is expected to return -1 when execute DDL statements; The PSQL OLE DB provider returns 0.

CloseConnection

OleDbCommand Properties

Stored Procedure

CommandUpdatedRowSource

OleDbCommandBuilder

All are supported

OleDbConnection Methods

Note: PSQL OLE DB does not support modifying the current catalog.

BeginTransaction

GetOleDbSchemaTable

OleDbConnection Properties

ConnectionString

OleDbDataAdapter Methods

CreateTableMappings

GetFillParameters

OleDbDataAdapter Properties

MissingMappingsAction

MissingSchemaAction

AcceptChangesDuringFill

DataColumn Properties tested with PSQL OLE DB Provider

AutoIncrementSeed

AutoIncrementStep


ColumnName	DataType
Bit	System.Boolean
Tinyint	System.Int16
Utinyint	System.Byte
Blob	System.Byte[]
Binary(8)	System.Byte[]
Clob	System.String
Char	System.String
Numeric	System.Decimal
BigInt	System.Decimal
UBigInt	System.Decimal
Currency	System.Decimal
Decimal	System.Decimal
Int	System.Int32
UInt	System.Int64
SmallInt	System.Int16
USmallInt	System.Int32
Double	System.Double
Real	System.Single
Double	System.Double
Date	System.DateTime
Time	System.TimeSpan
TimeStamp	System.DateTime
VarChar	System.String
Identity	System.Int32
SmallIdentity	System.Int16

OleDbDataReader Methods

GetByte(Workaround: Use GetInt16)

GetChar (NOT supported)

GetFloat(Workaround: Use GetDouble)

GetInt64(Workaround: Use GetDecimal)

OleDbDataReader Properties

RecordsAffected

DataSet Methods Tested with OLE DB Provider

DataSet Properties Tested with OLE DB Provider

DefaultViewManager

EnforceConstraints

DataTable Methods Tested with OLE DB Provider

DataTable Properties Tested with OLE DB Provider

DataRow Methods Tested with OLE DB Provider