Zen OLE DB Provider Implementation
Reference of Supported Properties, Methods, and Events
The following topics provide reference material for implementing Zen OLE DB Provider:
OLE DB Provider Implementation Reference
This topic lists specifics for the Zen implementation of the OLE DB Provider.
Note No Asynchronous operations are supported.
Command
Methods
Supported
•CreateParameter
•Execute
Unsupported
•Cancel
Properties
Supported
•ActiveConnection
•CommandText
•CommandType
•Name
•Parameters
•Prepared
•Properties
•State
Connection
Methods
Supported
•BeginTrans (including nested transactions)
•Close
•CommitTrans
•Execute
•Open
•adConnectUnspecified
•OpenSchema
•RollbackTrans
Unsupported
•Cancel
Properties
Supported
•Attributes
•ConnectionString
•CursorLocation
•adUseClient, based on Microsoft Cursor Service
•Errors
•IsolationLevels
•adXactRepeatableRead and adXactSerializable
•Mode
•adModeReadWrite
•Properties
•Provider
•Version
Unsupported
•CommandTimeout
•ConnectionTimeout
•DefaultDatabase
Events
Supported
•CommitTransComplete
•ConnectComplete
•Disconnect
•ExecuteComplete
•EndOfRecordset
•FieldChangeComplete
•MoveComplete
•RollbackTransComplete
•WillExecute
•WillChangeField
•WillConnect
•WillMove
Unsupported
•InfoMessage
Field
Methods
Supported
•AppendChunk
•GetChunk
Properties
Supported
•ActualSize
•Gives the size held in the database
•Accurate only to 65 KB on LongVarBinary and LongVarChar, after which the length can be found only using GetChunk
•Attributes
•DataFormat
•DefinedSize
•Name
•NumericScale
•OriginalValue
•Precision
•Properties
•Status
•Type
•Value
Unsupported
•UnderlyingValue
Fields
Methods
Unsupported
•Append
•CancelUpdate
•Delete
•Refresh
•Resynch
•Update
Properties
Supported
•Count
•Item
Parameter
Methods
Supported
•AppendChunk
Properties
Supported
•Attributes
•Direction
•Name
•NumericScale
•Precision
•Properties
•Size
•Type
•Value
Record
Not Supported
Recordset
Methods
Supported
•AddNew
•Cancel
•CancelBatch
•CancelUpdate
•Clone
•Close
•CompareBookmark
•Delete
•Find
•GetRows
•GetString
•Move
•MoveFirst
•MoveLast
•MoveNext
•MovePrevious
•Open
•Resync
•Save
•Seek
•supported when using adCmdTableDirect
•Supports
•Update
•UpdateBatch
Unsupported
•Requery
Properties
Supported
•AbsolutePage
•AbsolutePosition
•ActiveCommand
•ActiveConnection
•BOF
•Bookmark
•CacheSize
•CursorLocation
•CursorType
•adOpenStatic, adOpenDynamic, and adOpenForwardOnly
•DataSource
•EditMode
•EOF
•Fields
•Filter
•Do not support views
•Index
•With adCmdTableDirect
•LockType
•adLockOptimistic, adLockBatchOptimistic, and adLockReadOnly
•MarshalOptions
•MaxRecords
•PageCount
•PageSize
•Properties
•RecordCount
•Sort
•Source
•State
•Status
•StayInSync
Stream
Not Supported
ADOX Implementation Reference
This section documents Zen support of ADOX.
Catalog
Methods
Unsupported
•Create
•GetObjectOwner
•SetObjectOwner
Properties
Supported
•ActiveConnection
•Tables
Unsupported
•Groups
•Procedures
•Users
•Views
•Properties
Columns
Methods
Supported
•Append
•Delete
Unsupported
•Refresh
Properties
Supported
•Count
•Item
Column
Properties
Supported
•Attributes
•DefinedSize
•Name
•NumericScale
•ParentCatalog
•Precision
•Properties
•Type
Unsupported
•RelatedColumn
•SortOrder
Group
Not Supported
Index
Properties
Supported
•Columns
•IndexNulls
•Name
•Properties
•Unique
Unsupported
•Clustered
•PrimaryKey
Indexes
Methods
Supported
•Append
•Delete
Unsupported
•Refresh
Properties
Supported
•Count
•Item
Connection
Unsupported
Procedure
Unsupported
Tables
Methods
Supported
•Append
•Delete
Unsupported
•Refresh
Properties
Supported
•Count
•Item
Table
Properties
Supported
•Indexes
•Name
•ParentCatalog
•Type
Unsupported
•DateCreated
•DateModified
•Keys
Visual Studio.NET Implementation Reference
This section lists the properties and methods supported by Zen with regards to .NET.
OleDbCommand Methods
•Cancel
•CreateParameter
•CreateParameter
•Dispose
•ExecuteNonQuery
Note This method is expected to return -1 when execute DDL statements; The Zen OLE DB provider returns 0.
•ExecuteReader
•CloseConnection
•KeyInfo
•Default
•SingleResult
•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 Zen OLE DB 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 Zen 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 OLE DB Provider
•AcceptChanges
•GetChanges
•Merge
•HasChanges
•RejectChanges
•Reset
DataSet Properties Tested with OLE DB Provider
•CaseSensitive
•DataSetName
•DefaultViewManager
•EnforceConstraints
•HasErrors
•Locale
•Table
DataTable Methods Tested with OLE DB Provider
•AcceptChanges
•Clear
•NewRow
DataTable Properties Tested with OLE DB Provider
•ChildRelations
•Columns
•DataSet
•Rows
•TableName
DataRow Methods Tested with OLE DB Provider
•AcceptChanges
•RejectChanges
•Delete
•IsNull