Visual Studio.NET Implementation Reference
Show this topic in Library frames
This section lists the properties and methods supported by Pervasive.SQL with regards to .NET.
OleDbCommand Methods
Cancel
CreateParameter
CreateParameter
Dispose
ExecuteNonQuery
Note
This method is expected to return -1 when execute DDL statements; The Pervasive.SQL OLE DB provider returns 0.
ExecuteReader
CloseConnection
KeyInfo
Default
SingleResutl
SingleRow
ExecuteScalar
Prepare
OleDbCommand Properties
Connection
CommandText
CommandTimeout
Transaction
CommandType
Text
Stored Procedure
TableDirect
CommandUpdatedRowSource
OleDbCommandBuilder
All are supported
OleDbConnection Methods
Open
CreateCommand
Close
DatabaseChange
Note
PervasiveOLEDB does not support modifying the current catalog
BeginTransaction
GetOleDbSchemaTable
Columns
Indexes
ProviderTypes
Tables
OleDbConnection Properties
ConnectionString
DataBase
DataSource
Provider
ServerVersion
State
OleDbDataAdapter Methods
CreateTableMappings
CloneInternals
Fill
FillSchema
GetFillParameters
OnRowUpdated
OleDbDataAdapter Properties
MissingMappingsAction
MissingSchemaAction
AcceptChangesDuringFill
DeleteCommand
InsertCommand
SelectCommand
UpdateCommand
TableMappings
Columns
Table
DataColumn Properties tested with Pervasive OLE DB Provider
AllowDBNull
AutoIncrement
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
|
MaxLength
ReadOnly
Unique
OleDbDataReader Methods
Close
Read
GetBoolean
GetByte (Workaround: Use GetInt16)
GetChar (NOT supported)
GetDateTime
GetDecimal
GetDouble
GetFloat (Workaround: Use GetDouble)
GetInt16
GetInt32
GetInt64 (Workaround: Use GetDecimal)
GetName
GetSchemaTable
GetString
GetTimeSpan
GetValue
GetValues
IsDBNull:
NextResult
OleDbDataReader Properties
Depth
Item
FieldCount
IsClosed
RecordsAffected
DataSet Methods Tested with Pervasive OLE DB Provider
AcceptChanges
GetChanges
Merge
HasChanges
RejectChanges
Reset
DataSet Properties Tested with Pervasive OLE DB Provider
CaseSensitive
DataSetName
DefaultViewManager
EnforceConstraints
HasErrors
Locale
Table
DataTable Methods Tested with Pervasive OLE DB Provider
AcceptChanges
Clear
NewRow
DataTable Properties Tested with Pervasive OLE DB Provider
ChildRelations
Columns
DataSet
Rows
TableName
DataRow Methods Tested with Pervasive OLE DB Provider
AcceptChanges
RejectChanges
Delete
IsNull
