C# Класс Microsoft.Isam.Esent.Interop.Api

Managed versions of the ESENT Api. This class contains static methods corresponding with the unmanaged ESENT Api. These methods throw exceptions when errors are returned.
Показать файл Открыть проект Примеры использования класса

Private Properties

Свойство Тип Описание
Api System
Check JET_wrn
CheckEncodingIsValid void
Fail void
JetEnumerateColumns JET_wrn
JetGetVersion void
MakeKey void
MakeKey void
MakeKey void
SetColumn void
SetColumn void
SetColumn void

Открытые методы

Метод Описание
EscrowUpdate ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, int delta ) : int

Perform atomic addition on one column. The column must be of type JET_coltyp.Long. This function allows multiple sessions to update the same record concurrently without conflicts.

This method wraps JetEscrowUpdate.

JetAddColumn ( JET_SESID sesid, JET_TABLEID tableid, string column, JET_COLUMNDEF columndef, byte defaultValue, int defaultValueSize, JET_COLUMNID &columnid ) : void

Add a new column to an existing table.

JetAttachDatabase ( JET_SESID sesid, string database, AttachDatabaseGrbit grbit ) : JET_wrn

Attaches a database file for use with a database instance. In order to use the database, it will need to be subsequently opened with JetOpenDatabase.

JetAttachDatabase2 ( JET_SESID sesid, string database, int maxPages, AttachDatabaseGrbit grbit ) : JET_wrn

Attaches a database file for use with a database instance. In order to use the database, it will need to be subsequently opened with JetOpenDatabase.

JetBackupInstance ( JET_INSTANCE instance, string destination, BackupGrbit grbit, JET_PFNSTATUS statusCallback ) : void

Performs a streaming backup of an instance, including all the attached databases, to a directory. With multiple backup methods supported by the engine, this is the simplest and most encapsulated function.

JetBeginExternalBackupInstance ( JET_INSTANCE instance, BeginExternalBackupGrbit grbit ) : void

Initiates an external backup while the engine and database are online and active.

JetBeginSession ( JET_INSTANCE instance, JET_SESID &sesid, string username, string password ) : void

Initialize a new ESENT session.

JetBeginTransaction ( JET_SESID sesid ) : void

Causes a session to enter a transaction or create a new save point in an existing transaction.

JetBeginTransaction2 ( JET_SESID sesid, BeginTransactionGrbit grbit ) : void

Causes a session to enter a transaction or create a new save point in an existing transaction.

JetCloseDatabase ( JET_SESID sesid, JET_DBID dbid, CloseDatabaseGrbit grbit ) : void

Closes a database file that was previously opened with JetOpenDatabase or created with JetCreateDatabase.

JetCloseFileInstance ( JET_INSTANCE instance, JET_HANDLE handle ) : void

Closes a file that was opened with JetOpenFileInstance after the data from that file has been extracted using JetReadFileInstance.

JetCloseTable ( JET_SESID sesid, JET_TABLEID tableid ) : void

Close an open table.

JetCommitTransaction ( JET_SESID sesid, CommitTransactionGrbit grbit ) : void

Commits the changes made to the state of the database during the current save point and migrates them to the previous save point. If the outermost save point is committed then the changes made during that save point will be committed to the state of the database and the session will exit the transaction.

JetCompact ( JET_SESID sesid, string sourceDatabase, string destinationDatabase, JET_PFNSTATUS statusCallback, JET_CONVERT ignored, CompactGrbit grbit ) : void

Makes a copy of an existing database. The copy is compacted to a state optimal for usage. Data in the copied data will be packed according to the measures chosen for the indexes at index create. In this way, compacted data may be stored as densely as possible. Alternatively, compacted data may reserve space for subsequent record growth or index insertions.

JetComputeStats ( JET_SESID sesid, JET_TABLEID tableid ) : void

Walks each index of a table to exactly compute the number of entries in an index, and the number of distinct keys in an index. This information, together with the number of database pages allocated for an index and the current time of the computation is stored in index metadata in the database. This data can be subsequently retrieved with information operations.

JetCreateDatabase ( JET_SESID sesid, string database, string connect, JET_DBID &dbid, CreateDatabaseGrbit grbit ) : void

Creates and attaches a database file.

JetCreateDatabase2 ( JET_SESID sesid, string database, int maxPages, JET_DBID &dbid, CreateDatabaseGrbit grbit ) : void

Creates and attaches a database file with a maximum database size specified. JetAttachDatabase2.

JetCreateIndex ( JET_SESID sesid, JET_TABLEID tableid, string indexName, CreateIndexGrbit grbit, string keyDescription, int keyDescriptionLength, int density ) : void

Creates an index over data in an ESE database. An index can be used to locate specific data quickly.

JetCreateIndex2 ( JET_SESID sesid, JET_TABLEID tableid, Microsoft.Isam.Esent.Interop.JET_INDEXCREATE indexcreates, int numIndexCreates ) : void

Creates indexes over data in an ESE database.

When creating multiple indexes (i.e. with numIndexCreates greater than 1) this method MUST be called outside of any transactions and with exclusive access to the table. The JET_TABLEID returned by JetCreateTable will have exlusive access or the table can be opened for exclusive access by passing OpenTableGrbit.DenyRead to JetOpenTable.

JetCreateInstance ( JET_INSTANCE &instance, string name ) : void

Allocates a new instance of the database engine.

JetCreateInstance2 ( JET_INSTANCE &instance, string name, string displayName, CreateInstanceGrbit grbit ) : void

Allocate a new instance of the database engine for use in a single process, with a display name specified.

JetCreateTable ( JET_SESID sesid, JET_DBID dbid, string table, int pages, int density, JET_TABLEID &tableid ) : void

Create an empty table. The newly created table is opened exclusively.

JetDefragment ( JET_SESID sesid, JET_DBID dbid, string tableName, int &passes, int &seconds, DefragGrbit grbit ) : JET_wrn

Starts and stops database defragmentation tasks that improves data organization within a database.

JetDefragment2 ( JET_SESID sesid, JET_DBID dbid, string tableName, int &passes, int &seconds, JET_CALLBACK callback, DefragGrbit grbit ) : JET_wrn

Starts and stops database defragmentation tasks that improves data organization within a database.

The callback passed to JetDefragment2 can be executed asynchronously. The GC doesn't know that the unmanaged code has a reference to the callback so it is important to make sure the callback isn't collected.

JetDelete ( JET_SESID sesid, JET_TABLEID tableid ) : void

Deletes the current record in a database table.

JetDeleteColumn ( JET_SESID sesid, JET_TABLEID tableid, string column ) : void

Deletes a column from a database table.

JetDeleteColumn2 ( JET_SESID sesid, JET_TABLEID tableid, string column, DeleteColumnGrbit grbit ) : void

Deletes a column from a database table.

JetDeleteIndex ( JET_SESID sesid, JET_TABLEID tableid, string index ) : void

Deletes an index from a database table.

JetDeleteTable ( JET_SESID sesid, JET_DBID dbid, string table ) : void

Deletes a table from a database.

JetDetachDatabase ( JET_SESID sesid, string database ) : void

Releases a database file that was previously attached to a database session.

JetDupCursor ( JET_SESID sesid, JET_TABLEID tableid, JET_TABLEID &newTableid, DupCursorGrbit grbit ) : void

Duplicates an open cursor and returns a handle to the duplicated cursor. If the cursor that was duplicated was a read-only cursor then the duplicated cursor is also a read-only cursor. Any state related to constructing a search key or updating a record is not copied into the duplicated cursor. In addition, the location of the original cursor is not duplicated into the duplicated cursor. The duplicated cursor is always opened on the clustered index and its location is always on the first row of the table.

JetDupSession ( JET_SESID sesid, JET_SESID &newSesid ) : void

Initialize a new ESE session in the same instance as the given sesid.

JetEndExternalBackupInstance ( JET_INSTANCE instance ) : void

Ends an external backup session. This API is the last API in a series of APIs that must be called to execute a successful online (non-VSS based) backup.

JetEndExternalBackupInstance2 ( JET_INSTANCE instance, EndExternalBackupGrbit grbit ) : void

Ends an external backup session. This API is the last API in a series of APIs that must be called to execute a successful online (non-VSS based) backup.

JetEndSession ( JET_SESID sesid, EndSessionGrbit grbit ) : void

Ends a session.

JetEscrowUpdate ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, byte delta, int deltaSize, byte previousValue, int previousValueLength, int &actualPreviousValueLength, EscrowUpdateGrbit grbit ) : void

Performs an atomic addition operation on one column. This function allows multiple sessions to update the same record concurrently without conflicts. Also see EscrowUpdate.

JetFreeBuffer ( IntPtr buffer ) : void

Frees memory that was allocated by a database engine call.

This method is internal because we never expose the memory allocated by ESENT to our callers.

JetGetBookmark ( JET_SESID sesid, JET_TABLEID tableid, byte bookmark, int bookmarkSize, int &actualBookmarkSize ) : void

Retrieves the bookmark for the record that is associated with the index entry at the current position of a cursor. This bookmark can then be used to reposition that cursor back to the same record using JetGotoBookmark. The bookmark will be no longer than SystemParameters.BookmarkMost bytes. Also see GetBookmark.

JetGetColumnInfo ( JET_SESID sesid, JET_DBID dbid, string tablename, string columnName, JET_COLUMNDEF &columndef ) : void

Retrieves information about a table column.

JetGetColumnInfo ( JET_SESID sesid, JET_DBID dbid, string tablename, string columnName, JET_COLUMNLIST &columnlist ) : void

Retrieves information about all columns in a table.

JetGetCurrentIndex ( JET_SESID sesid, JET_TABLEID tableid, string &indexName, int maxNameLength ) : void

Ddetermines the name of the current index of a given cursor. This name is also used to later re-select that index as the current index using JetSetCurrentIndex. It can also be used to discover the properties of that index using JetGetTableIndexInfo.

JetGetIndexInfo ( JET_SESID sesid, JET_DBID dbid, string tablename, string ignored, JET_INDEXLIST &indexlist ) : void

Retrieves information about indexes on a table.

JetGetInstanceInfo ( int &numInstances, JET_INSTANCE_INFO &instances ) : void

Retrieves information about the instances that are running.

JetGetLS ( JET_SESID sesid, JET_TABLEID tableid, JET_LS &ls, LsGrbit grbit ) : void

Enables the application to retrieve the context handle known as Local Storage that is associated with a cursor or the table associated with that cursor. This context handle must have been previously set using JetSetLS. JetGetLS can also be used to simultaneously fetch the current context handle for a cursor or table and reset that context handle.

JetGetLock ( JET_SESID sesid, JET_TABLEID tableid, GetLockGrbit grbit ) : void

Explicitly reserve the ability to update a row, write lock, or to explicitly prevent a row from being updated by any other session, read lock. Normally, row write locks are acquired implicitly as a result of updating rows. Read locks are usually not required because of record versioning. However, in some cases a transaction may desire to explicitly lock a row to enforce serialization, or to ensure that a subsequent operation will succeed.

JetGetObjectInfo ( JET_SESID sesid, JET_DBID dbid, JET_OBJECTLIST &objectlist ) : void

Retrieves information about database objects.

JetGetRecordPosition ( JET_SESID sesid, JET_TABLEID tableid, JET_RECPOS &recpos ) : void

Returns the fractional position of the current record in the current index in the form of a JET_RECPOS structure. Also see JetGotoPosition.

JetGetRecordSize ( JET_SESID sesid, JET_TABLEID tableid, JET_RECSIZE &recsize, GetRecordSizeGrbit grbit ) : void

Retrieves record size information from the desired location.

JetGetSecondaryIndexBookmark ( JET_SESID sesid, JET_TABLEID tableid, byte secondaryKey, int secondaryKeySize, int &actualSecondaryKeySize, byte primaryKey, int primaryKeySize, int &actualPrimaryKeySize, GetSecondaryIndexBookmarkGrbit grbit ) : void

Retrieves a special bookmark for the secondary index entry at the current position of a cursor. This bookmark can then be used to efficiently reposition that cursor back to the same index entry using JetGotoSecondaryIndexBookmark. This is most useful when repositioning on a secondary index that contains duplicate keys or that contains multiple index entries for the same record.

JetGetSystemParameter ( JET_INSTANCE instance, JET_SESID sesid, JET_param paramid, int &paramValue, string &paramString, int maxParam ) : JET_wrn

Gets database configuration options.

JET_param.ErrorToString passes in the error number in the paramValue, which is why it is a ref parameter and not an out parameter.

JetGetTableColumnInfo ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, JET_COLUMNDEF &columndef ) : void

Retrieves information about a table column.

JetGetTableColumnInfo ( JET_SESID sesid, JET_TABLEID tableid, string columnName, JET_COLUMNDEF &columndef ) : void

Retrieves information about a table column.

JetGetTableColumnInfo ( JET_SESID sesid, JET_TABLEID tableid, string columnName, JET_COLUMNLIST &columnlist ) : void

Retrieves information about all columns in the table.

JetGetTableIndexInfo ( JET_SESID sesid, JET_TABLEID tableid, string ignored, JET_INDEXLIST &indexlist ) : void

Retrieves information about indexes on a table.

JetGotoBookmark ( JET_SESID sesid, JET_TABLEID tableid, byte bookmark, int bookmarkSize ) : void

Positions a cursor to an index entry for the record that is associated with the specified bookmark. The bookmark can be used with any index defined over a table. The bookmark for a record can be retrieved using JetGetBookmark.

JetGotoPosition ( JET_SESID sesid, JET_TABLEID tableid, JET_RECPOS recpos ) : void

Moves a cursor to a new location that is a fraction of the way through the current index. Also see JetGetRecordPosition.

JetGotoSecondaryIndexBookmark ( JET_SESID sesid, JET_TABLEID tableid, byte secondaryKey, int secondaryKeySize, byte primaryKey, int primaryKeySize, GotoSecondaryIndexBookmarkGrbit grbit ) : void

Positions a cursor to an index entry that is associated with the specified secondary index bookmark. The secondary index bookmark must be used with the same index over the same table from which it was originally retrieved. The secondary index bookmark for an index entry can be retrieved using JetGotoSecondaryIndexBookmark.

JetGrowDatabase ( JET_SESID sesid, JET_DBID dbid, int desiredPages, int &actualPages ) : void

Extends the size of a database that is currently open.

JetIdle ( JET_SESID sesid, IdleGrbit grbit ) : JET_wrn

Performs idle cleanup tasks or checks the version store status in ESE.

JetIndexRecordCount ( JET_SESID sesid, JET_TABLEID tableid, int &numRecords, int maxRecordsToCount ) : void

Counts the number of entries in the current index from the current position forward. The current position is included in the count. The count can be greater than the total number of records in the table if the current index is over a multi-valued column and instances of the column have multiple-values. If the table is empty, then 0 will be returned for the count.

JetInit ( JET_INSTANCE &instance ) : void

Initialize the ESENT database engine.

JetInit2 ( JET_INSTANCE &instance, InitGrbit grbit ) : JET_wrn

Initialize the ESENT database engine.

JetIntersectIndexes ( JET_SESID sesid, JET_INDEXRANGE ranges, int numRanges, JET_RECORDLIST &recordlist, IntersectIndexesGrbit grbit ) : void

Computes the intersection between multiple sets of index entries from different secondary indices over the same table. This operation is useful for finding the set of records in a table that match two or more criteria that can be expressed using index ranges. Also see IntersectIndexes.

JetMakeKey ( JET_SESID sesid, JET_TABLEID tableid, byte data, int dataSize, MakeKeyGrbit grbit ) : void

Constructs search keys that may then be used by JetSeek and JetSetIndexRange.

The MakeKey functions provide datatype-specific make key functionality.

JetMove ( JET_SESID sesid, JET_TABLEID tableid, JET_Move numRows, MoveGrbit grbit ) : void

Navigate through an index. The cursor can be positioned at the start or end of the index and moved backwards and forwards by a specified number of index entries. Also see TryMoveFirst, TryMoveLast, TryMoveNext, TryMovePrevious.

JetMove ( JET_SESID sesid, JET_TABLEID tableid, int numRows, MoveGrbit grbit ) : void

Navigate through an index. The cursor can be positioned at the start or end of the index and moved backwards and forwards by a specified number of index entries. Also see TryMoveFirst, TryMoveLast, TryMoveNext, TryMovePrevious.

JetOSSnapshotFreeze ( JET_OSSNAPID snapshot, int &numInstances, JET_INSTANCE_INFO &instances, SnapshotFreezeGrbit grbit ) : void

Starts a snapshot. While the snapshot is in progress, no write-to-disk activity by the engine can take place.

JetOSSnapshotPrepare ( JET_OSSNAPID &snapshot, SnapshotPrepareGrbit grbit ) : void

Begins the preparations for a snapshot session. A snapshot session is a short time interval in which the engine does not issue any write IOs to disk, so that the engine can participate in a volume snapshot session (when driven by a snapshot writer).

JetOSSnapshotThaw ( JET_OSSNAPID snapshot, SnapshotThawGrbit grbit ) : void

Notifies the engine that it can resume normal IO operations after a freeze period and a successful snapshot.

JetOpenDatabase ( JET_SESID sesid, string database, string connect, JET_DBID &dbid, OpenDatabaseGrbit grbit ) : JET_wrn

Opens a database previously attached with JetAttachDatabase, for use with a database session. This function can be called multiple times for the same database.

JetOpenFileInstance ( JET_INSTANCE instance, string file, JET_HANDLE &handle, long &fileSizeLow, long &fileSizeHigh ) : void

Opens an attached database, database patch file, or transaction log file of an active instance for the purpose of performing a streaming fuzzy backup. The data from these files can subsequently be read through the returned handle using JetReadFileInstance. The returned handle must be closed using JetCloseFileInstance. An external backup of the instance must have been previously initiated using JetBeginExternalBackupInstance.

JetOpenTable ( JET_SESID sesid, JET_DBID dbid, string tablename, byte parameters, int parametersSize, OpenTableGrbit grbit, JET_TABLEID &tableid ) : void

Opens a cursor on a previously created table.

JetOpenTempTable ( JET_SESID sesid, JET_COLUMNDEF columns, int numColumns, TempTableGrbit grbit, JET_TABLEID &tableid, JET_COLUMNID columnids ) : void

Creates a temporary table with a single index. A temporary table stores and retrieves records just like an ordinary table created using JetCreateTableColumnIndex. However, temporary tables are much faster than ordinary tables due to their volatile nature. They can also be used to very quickly sort and perform duplicate removal on record sets when accessed in a purely sequential manner. Also see Api.JetOpenTempTable2, Api.JetOpenTempTable3. VistaApi.JetOpenTemporaryTable.

JetOpenTempTable2 ( JET_SESID sesid, JET_COLUMNDEF columns, int numColumns, int lcid, TempTableGrbit grbit, JET_TABLEID &tableid, JET_COLUMNID columnids ) : void

Creates a temporary table with a single index. A temporary table stores and retrieves records just like an ordinary table created using JetCreateTableColumnIndex. However, temporary tables are much faster than ordinary tables due to their volatile nature. They can also be used to very quickly sort and perform duplicate removal on record sets when accessed in a purely sequential manner. Also see Api.JetOpenTempTable, Api.JetOpenTempTable3. VistaApi.JetOpenTemporaryTable.

JetOpenTempTable3 ( JET_SESID sesid, JET_COLUMNDEF columns, int numColumns, JET_UNICODEINDEX unicodeindex, TempTableGrbit grbit, JET_TABLEID &tableid, JET_COLUMNID columnids ) : void

Creates a temporary table with a single index. A temporary table stores and retrieves records just like an ordinary table created using JetCreateTableColumnIndex. However, temporary tables are much faster than ordinary tables due to their volatile nature. They can also be used to very quickly sort and perform duplicate removal on record sets when accessed in a purely sequential manner. Also see Api.JetOpenTempTable, Api.JetOpenTempTable2, VistaApi.JetOpenTemporaryTable.

JetPrepareUpdate ( JET_SESID sesid, JET_TABLEID tableid, JET_prep prep ) : void

Prepare a cursor for update.

JetReadFileInstance ( JET_INSTANCE instance, JET_HANDLE file, byte buffer, int bufferSize, int &bytesRead ) : void

Retrieves the contents of a file opened with Api.JetOpenFileInstance.

JetRegisterCallback ( JET_SESID sesid, JET_TABLEID tableid, JET_cbtyp cbtyp, JET_CALLBACK callback, IntPtr context, JET_HANDLE &callbackId ) : void

Allows the application to configure the database engine to issue notifications to the application for specific events. These notifications are associated with a specific table and remain in effect only until the instance containing the table is shut down using JetTerm.

JetRenameColumn ( JET_SESID sesid, JET_TABLEID tableid, string name, string newName, RenameColumnGrbit grbit ) : void

Changes the name of an existing column.

JetRenameTable ( JET_SESID sesid, JET_DBID dbid, string tableName, string newTableName ) : void

Changes the name of an existing table.

JetResetSessionContext ( JET_SESID sesid ) : void

Disassociates a session from the current thread. This should be used in conjunction with JetSetSessionContext.

JetResetTableSequential ( JET_SESID sesid, JET_TABLEID tableid, ResetTableSequentialGrbit grbit ) : void

Notifies the database engine that the application is no longer scanning the entire index the cursor is positioned on. This call reverses a notification sent by JetSetTableSequential.

JetRestoreInstance ( JET_INSTANCE instance, string source, string destination, JET_PFNSTATUS statusCallback ) : void

Restores and recovers a streaming backup of an instance including all the attached databases. It is designed to work with a backup created with the Api.JetBackupInstance function. This is the simplest and most encapsulated restore function.

JetRetrieveColumn ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, byte data, int dataSize, int &actualDataSize, RetrieveColumnGrbit grbit, JET_RETINFO retinfo ) : JET_wrn

Retrieves a single column value from the current record. The record is that record associated with the index entry at the current position of the cursor. Alternatively, this function can retrieve a column from a record being created in the cursor copy buffer. This function can also retrieve column data from an index entry that references the current record. In addition to retrieving the actual column value, JetRetrieveColumn can also be used to retrieve the size of a column, before retrieving the column data itself so that application buffers can be sized appropriately.

The RetrieveColumnAs functions provide datatype-specific retrieval functions.

JetRetrieveColumns ( JET_SESID sesid, JET_TABLEID tableid, JET_RETRIEVECOLUMN retrievecolumns, int numColumns ) : JET_wrn

Retrieves multiple column values from the current record in a single operation. An array of JET_RETRIEVECOLUMN structures is used to describe the set of column values to be retrieved, and to describe output buffers for each column value to be retrieved.

JetRetrieveKey ( JET_SESID sesid, JET_TABLEID tableid, byte data, int dataSize, int &actualDataSize, RetrieveKeyGrbit grbit ) : void

Retrieves the key for the index entry at the current position of a cursor. Also see RetrieveKey.

JetRollback ( JET_SESID sesid, RollbackTransactionGrbit grbit ) : void

Undoes the changes made to the state of the database and returns to the last save point. JetRollback will also close any cursors opened during the save point. If the outermost save point is undone, the session will exit the transaction.

JetSeek ( JET_SESID sesid, JET_TABLEID tableid, SeekGrbit grbit ) : JET_wrn

Efficiently positions a cursor to an index entry that matches the search criteria specified by the search key in that cursor and the specified inequality. A search key must have been previously constructed using JetMakeKey(JET_SESID,JET_TABLEID,byte[],int,MakeKeyGrbit). Also see TrySeek.

JetSetColumn ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, byte data, int dataSize, SetColumnGrbit grbit, JET_SETINFO setinfo ) : void

The JetSetColumn function modifies a single column value in a modified record to be inserted or to update the current record. It can overwrite an existing value, add a new value to a sequence of values in a multi-valued column, remove a value from a sequence of values in a multi-valued column, or update all or part of a long value (a column of type JET_coltyp.LongText or JET_coltyp.LongBinary).

The SetColumn methods provide datatype-specific overrides which may be more efficient.

JetSetColumnDefaultValue ( JET_SESID sesid, JET_DBID dbid, string tableName, string columnName, byte data, int dataSize, SetColumnDefaultValueGrbit grbit ) : void

Changes the default value of an existing column.

JetSetColumns ( JET_SESID sesid, JET_TABLEID tableid, JET_SETCOLUMN setcolumns, int numColumns ) : JET_wrn

Allows an application to set multiple column values in a single operation. An array of JET_SETCOLUMN structures is used to describe the set of column values to be set, and to describe input buffers for each column value to be set.

JetSetCurrentIndex ( JET_SESID sesid, JET_TABLEID tableid, string index ) : void

Set the current index of a cursor.

JetSetCurrentIndex2 ( JET_SESID sesid, JET_TABLEID tableid, string index, SetCurrentIndexGrbit grbit ) : void

Set the current index of a cursor.

JetSetCurrentIndex3 ( JET_SESID sesid, JET_TABLEID tableid, string index, SetCurrentIndexGrbit grbit, int itagSequence ) : void

Set the current index of a cursor.

JetSetDatabaseSize ( JET_SESID sesid, string database, int desiredPages, int &actualPages ) : void

Sets the size of an unopened database file.

JetSetIndexRange ( JET_SESID sesid, JET_TABLEID tableid, SetIndexRangeGrbit grbit ) : void

Temporarily limits the set of index entries that the cursor can walk using JetMove(JET_SESID,JET_TABLEID,int,MoveGrbit) to those starting from the current index entry and ending at the index entry that matches the search criteria specified by the search key in that cursor and the specified bound criteria. A search key must have been previously constructed using JetMakeKey(JET_SESID,JET_TABLEID,byte[],int,MakeKeyGrbit). Also see TrySetIndexRange.

JetSetLS ( JET_SESID sesid, JET_TABLEID tableid, JET_LS ls, LsGrbit grbit ) : void

Enables the application to associate a context handle known as Local Storage with a cursor or the table associated with that cursor. This context handle can be used by the application to store auxiliary data that is associated with a cursor or table. The application is later notified using a runtime callback when the context handle must be released. This makes it possible to associate dynamically allocated state with a cursor or table.

JetSetSessionContext ( JET_SESID sesid, IntPtr context ) : void

Associates a session with the current thread using the given context handle. This association overrides the default engine requirement that a transaction for a given session must occur entirely on the same thread. Use JetResetSessionContext to remove the association.

JetSetSystemParameter ( JET_INSTANCE instance, JET_SESID sesid, JET_param paramid, JET_CALLBACK paramValue, string paramString ) : JET_wrn

Sets database configuration options.

JetSetSystemParameter ( JET_INSTANCE instance, JET_SESID sesid, JET_param paramid, int paramValue, string paramString ) : JET_wrn

Sets database configuration options.

JetSetTableSequential ( JET_SESID sesid, JET_TABLEID tableid, SetTableSequentialGrbit grbit ) : void

Notifies the database engine that the application is scanning the entire index that the cursor is positioned on. Consequently, the methods that are used to access the index data will be tuned to make this scenario as fast as possible. Also see JetResetTableSequential.

JetStopBackupInstance ( JET_INSTANCE instance ) : void

Prevents streaming backup-related activity from continuing on a specific running instance, thus ending the streaming backup in a predictable way.

JetStopServiceInstance ( JET_INSTANCE instance ) : void

Prepares an instance for termination.

JetTerm ( JET_INSTANCE instance ) : void

Terminate an instance that was created with JetInit or JetCreateInstance.

JetTerm2 ( JET_INSTANCE instance, TermGrbit grbit ) : void

Terminate an instance that was created with JetInit or JetCreateInstance.

JetTruncateLogInstance ( JET_INSTANCE instance ) : void

Used during a backup initiated by JetBeginExternalBackup to delete any transaction log files that will no longer be needed once the current backup completes successfully.

JetUnregisterCallback ( JET_SESID sesid, JET_TABLEID tableid, JET_cbtyp cbtyp, JET_HANDLE callbackId ) : void

Configures the database engine to stop issuing notifications to the application as previously requested through JetRegisterCallback.

JetUpdate ( JET_SESID sesid, JET_TABLEID tableid ) : void

The JetUpdate function performs an update operation including inserting a new row into a table or updating an existing row. Deleting a table row is performed by calling JetDelete.

JetUpdate is the final step in performing an insert or an update. The update is begun by calling JetPrepareUpdate and then by calling JetSetColumn(JET_SESID,JET_TABLEID,JET_COLUMNID,byte[],int,SetColumnGrbit,JET_SETINFO) one or more times to set the record state. Finally, JetUpdate(JET_SESID,JET_TABLEID,byte[],int,out int) is called to complete the update operation. Indexes are updated only by JetUpdate or and not during JetSetColumn.

JetUpdate ( JET_SESID sesid, JET_TABLEID tableid, byte bookmark, int bookmarkSize, int &actualBookmarkSize ) : void

The JetUpdate function performs an update operation including inserting a new row into a table or updating an existing row. Deleting a table row is performed by calling JetDelete.

JetUpdate is the final step in performing an insert or an update. The update is begun by calling JetPrepareUpdate and then by calling JetSetColumn(JET_SESID,JET_TABLEID,JET_COLUMNID,byte[],int,SetColumnGrbit,JET_SETINFO) one or more times to set the record state. Finally, JetUpdate(JET_SESID,JET_TABLEID,byte[],int,out int) is called to complete the update operation. Indexes are updated only by JetUpdate or and not during JetSetColumn.

MakeKey ( JET_SESID sesid, JET_TABLEID tableid, DateTime data, MakeKeyGrbit grbit ) : void

Constructs a search key that may then be used by JetSeek and JetSetIndexRange.

MakeKey ( JET_SESID sesid, JET_TABLEID tableid, Guid data, MakeKeyGrbit grbit ) : void

Constructs a search key that may then be used by JetSeek and JetSetIndexRange.

MakeKey ( JET_SESID sesid, JET_TABLEID tableid, bool data, MakeKeyGrbit grbit ) : void

Constructs a search key that may then be used by JetSeek and JetSetIndexRange.

MakeKey ( JET_SESID sesid, JET_TABLEID tableid, byte data, MakeKeyGrbit grbit ) : void

Constructs a search key that may then be used by JetSeek and JetSetIndexRange.

MakeKey ( JET_SESID sesid, JET_TABLEID tableid, double data, MakeKeyGrbit grbit ) : void

Constructs a search key that may then be used by JetSeek and JetSetIndexRange.

MakeKey ( JET_SESID sesid, JET_TABLEID tableid, float data, MakeKeyGrbit grbit ) : void

Constructs a search key that may then be used by JetSeek and JetSetIndexRange.

MakeKey ( JET_SESID sesid, JET_TABLEID tableid, int data, MakeKeyGrbit grbit ) : void

Constructs a search key that may then be used by JetSeek and JetSetIndexRange.

MakeKey ( JET_SESID sesid, JET_TABLEID tableid, long data, MakeKeyGrbit grbit ) : void

Constructs a search key that may then be used by JetSeek and JetSetIndexRange.

MakeKey ( JET_SESID sesid, JET_TABLEID tableid, short data, MakeKeyGrbit grbit ) : void

Constructs a search key that may then be used by JetSeek and JetSetIndexRange.

MakeKey ( JET_SESID sesid, JET_TABLEID tableid, string data, Encoding encoding, MakeKeyGrbit grbit ) : void

Constructs a search key that may then be used by JetSeek and JetSetIndexRange.

SerializeObjectToColumn ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, object value ) : void

Write a serialized form of an object to a column.

SetColumn ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, DateTime data ) : void

Modifies a single column value in a modified record to be inserted or to update the current record.

SetColumn ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, Guid data ) : void

Modifies a single column value in a modified record to be inserted or to update the current record.

SetColumn ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, bool data ) : void

Modifies a single column value in a modified record to be inserted or to update the current record.

SetColumn ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, byte data ) : void

Modifies a single column value in a modified record to be inserted or to update the current record.

SetColumn ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, double data ) : void

Modifies a single column value in a modified record to be inserted or to update the current record.

SetColumn ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, float data ) : void

Modifies a single column value in a modified record to be inserted or to update the current record.

SetColumn ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, int data ) : void

Modifies a single column value in a modified record to be inserted or to update the current record.

SetColumn ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, long data ) : void

Modifies a single column value in a modified record to be inserted or to update the current record.

SetColumn ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, short data ) : void

Modifies a single column value in a modified record to be inserted or to update the current record.

SetColumn ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, string data, Encoding encoding ) : void

Modifies a single column value in a modified record to be inserted or to update the current record.

SetColumn ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, string data, Encoding encoding, SetColumnGrbit grbit ) : void

Modifies a single column value in a modified record to be inserted or to update the current record.

SetColumns ( JET_SESID sesid, JET_TABLEID tableid ) : void

Sets columns from ColumnValue objects.

Приватные методы

Метод Описание
Api ( ) : System

Initializes static members of the Api class.

Check ( int err ) : JET_wrn

Throw an exception if the parameter is an ESE error, returns a JET_wrn otherwise.

CheckEncodingIsValid ( Encoding encoding ) : void

Verifies that the given encoding is valid for setting/retrieving data. Only the ASCII and Unicode encodings are allowed. An ArgumentOutOfRangeException is thrown if the encoding isn't valid.

Fail ( int err ) : void

Called to throw an exception with a failing error code.

JetEnumerateColumns ( JET_SESID sesid, JET_TABLEID tableid, int numColumnids, JET_ENUMCOLUMNID columnids, int &numColumnValues, JET_ENUMCOLUMN &columnValues, JET_PFNREALLOC allocator, IntPtr allocatorContext, int maxDataSize, EnumerateColumnsGrbit grbit ) : JET_wrn
JetGetVersion ( JET_SESID sesid, uint &version ) : void
MakeKey ( JET_SESID sesid, JET_TABLEID tableid, uint data, MakeKeyGrbit grbit ) : void
MakeKey ( JET_SESID sesid, JET_TABLEID tableid, ulong data, MakeKeyGrbit grbit ) : void
MakeKey ( JET_SESID sesid, JET_TABLEID tableid, ushort data, MakeKeyGrbit grbit ) : void
SetColumn ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, uint data ) : void
SetColumn ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, ulong data ) : void
SetColumn ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, ushort data ) : void

Описание методов

EscrowUpdate() публичный статический Метод

Perform atomic addition on one column. The column must be of type JET_coltyp.Long. This function allows multiple sessions to update the same record concurrently without conflicts.
This method wraps JetEscrowUpdate.
public static EscrowUpdate ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, int delta ) : int
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to update.
columnid JET_COLUMNID The column to update. This must be an escrow-updatable column.
delta int The delta to apply to the column.
Результат int

JetAddColumn() публичный статический Метод

Add a new column to an existing table.
public static JetAddColumn ( JET_SESID sesid, JET_TABLEID tableid, string column, JET_COLUMNDEF columndef, byte defaultValue, int defaultValueSize, JET_COLUMNID &columnid ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The table to add the column to.
column string The name of the column.
columndef JET_COLUMNDEF The definition of the column.
defaultValue byte The default value of the column.
defaultValueSize int The size of the default value.
columnid JET_COLUMNID Returns the columnid of the new column.
Результат void

JetAttachDatabase() публичный статический Метод

Attaches a database file for use with a database instance. In order to use the database, it will need to be subsequently opened with JetOpenDatabase.
public static JetAttachDatabase ( JET_SESID sesid, string database, AttachDatabaseGrbit grbit ) : JET_wrn
sesid JET_SESID The session to use.
database string The database to attach.
grbit AttachDatabaseGrbit Attach options.
Результат JET_wrn

JetAttachDatabase2() публичный статический Метод

Attaches a database file for use with a database instance. In order to use the database, it will need to be subsequently opened with JetOpenDatabase.
public static JetAttachDatabase2 ( JET_SESID sesid, string database, int maxPages, AttachDatabaseGrbit grbit ) : JET_wrn
sesid JET_SESID The session to use.
database string The database to attach.
maxPages int /// The maximum size, in database pages, of the database. Passing 0 means there is /// no enforced maximum. ///
grbit AttachDatabaseGrbit Attach options.
Результат JET_wrn

JetBackupInstance() публичный статический Метод

Performs a streaming backup of an instance, including all the attached databases, to a directory. With multiple backup methods supported by the engine, this is the simplest and most encapsulated function.
public static JetBackupInstance ( JET_INSTANCE instance, string destination, BackupGrbit grbit, JET_PFNSTATUS statusCallback ) : void
instance JET_INSTANCE The instance to backup.
destination string /// The directory where the backup is to be stored. If the backup path is /// null to use the function will truncate the logs, if possible. ///
grbit BackupGrbit Backup options.
statusCallback JET_PFNSTATUS /// Optional status notification callback. ///
Результат void

JetBeginExternalBackupInstance() публичный статический Метод

Initiates an external backup while the engine and database are online and active.
public static JetBeginExternalBackupInstance ( JET_INSTANCE instance, BeginExternalBackupGrbit grbit ) : void
instance JET_INSTANCE The instance prepare for backup.
grbit BeginExternalBackupGrbit Backup options.
Результат void

JetBeginSession() публичный статический Метод

Initialize a new ESENT session.
public static JetBeginSession ( JET_INSTANCE instance, JET_SESID &sesid, string username, string password ) : void
instance JET_INSTANCE The initialized instance to create the session in.
sesid JET_SESID Returns the created session.
username string The parameter is not used.
password string The parameter is not used.
Результат void

JetBeginTransaction() публичный статический Метод

Causes a session to enter a transaction or create a new save point in an existing transaction.
public static JetBeginTransaction ( JET_SESID sesid ) : void
sesid JET_SESID The session to begin the transaction for.
Результат void

JetBeginTransaction2() публичный статический Метод

Causes a session to enter a transaction or create a new save point in an existing transaction.
public static JetBeginTransaction2 ( JET_SESID sesid, BeginTransactionGrbit grbit ) : void
sesid JET_SESID The session to begin the transaction for.
grbit BeginTransactionGrbit Transaction options.
Результат void

JetCloseDatabase() публичный статический Метод

Closes a database file that was previously opened with JetOpenDatabase or created with JetCreateDatabase.
public static JetCloseDatabase ( JET_SESID sesid, JET_DBID dbid, CloseDatabaseGrbit grbit ) : void
sesid JET_SESID The session to use.
dbid JET_DBID The database to close.
grbit CloseDatabaseGrbit Close options.
Результат void

JetCloseFileInstance() публичный статический Метод

Closes a file that was opened with JetOpenFileInstance after the data from that file has been extracted using JetReadFileInstance.
public static JetCloseFileInstance ( JET_INSTANCE instance, JET_HANDLE handle ) : void
instance JET_INSTANCE The instance to use.
handle JET_HANDLE The handle to close.
Результат void

JetCloseTable() публичный статический Метод

Close an open table.
public static JetCloseTable ( JET_SESID sesid, JET_TABLEID tableid ) : void
sesid JET_SESID The session which opened the table.
tableid JET_TABLEID The table to close.
Результат void

JetCommitTransaction() публичный статический Метод

Commits the changes made to the state of the database during the current save point and migrates them to the previous save point. If the outermost save point is committed then the changes made during that save point will be committed to the state of the database and the session will exit the transaction.
public static JetCommitTransaction ( JET_SESID sesid, CommitTransactionGrbit grbit ) : void
sesid JET_SESID The session to commit the transaction for.
grbit CommitTransactionGrbit Commit options.
Результат void

JetCompact() публичный статический Метод

Makes a copy of an existing database. The copy is compacted to a state optimal for usage. Data in the copied data will be packed according to the measures chosen for the indexes at index create. In this way, compacted data may be stored as densely as possible. Alternatively, compacted data may reserve space for subsequent record growth or index insertions.
public static JetCompact ( JET_SESID sesid, string sourceDatabase, string destinationDatabase, JET_PFNSTATUS statusCallback, JET_CONVERT ignored, CompactGrbit grbit ) : void
sesid JET_SESID The session to use for the call.
sourceDatabase string The source database that will be compacted.
destinationDatabase string The name to use for the compacted database.
statusCallback JET_PFNSTATUS /// A callback function that can be called periodically through the /// database compact operation to report progress. ///
ignored JET_CONVERT /// This parameter is ignored and should be null. ///
grbit CompactGrbit Compact options.
Результат void

JetComputeStats() публичный статический Метод

Walks each index of a table to exactly compute the number of entries in an index, and the number of distinct keys in an index. This information, together with the number of database pages allocated for an index and the current time of the computation is stored in index metadata in the database. This data can be subsequently retrieved with information operations.
public static JetComputeStats ( JET_SESID sesid, JET_TABLEID tableid ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The table that the statistics will be computed on.
Результат void

JetCreateDatabase() публичный статический Метод

Creates and attaches a database file.
public static JetCreateDatabase ( JET_SESID sesid, string database, string connect, JET_DBID &dbid, CreateDatabaseGrbit grbit ) : void
sesid JET_SESID The session to use.
database string The path to the database file to create.
connect string The parameter is not used.
dbid JET_DBID Returns the dbid of the new database.
grbit CreateDatabaseGrbit Database creation options.
Результат void

JetCreateDatabase2() публичный статический Метод

Creates and attaches a database file with a maximum database size specified. JetAttachDatabase2.
public static JetCreateDatabase2 ( JET_SESID sesid, string database, int maxPages, JET_DBID &dbid, CreateDatabaseGrbit grbit ) : void
sesid JET_SESID The session to use.
database string The path to the database file to create.
maxPages int /// The maximum size, in database pages, of the database. Passing 0 means there is /// no enforced maximum. ///
dbid JET_DBID Returns the dbid of the new database.
grbit CreateDatabaseGrbit Database creation options.
Результат void

JetCreateIndex() публичный статический Метод

Creates an index over data in an ESE database. An index can be used to locate specific data quickly.
public static JetCreateIndex ( JET_SESID sesid, JET_TABLEID tableid, string indexName, CreateIndexGrbit grbit, string keyDescription, int keyDescriptionLength, int density ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The table to create the index on.
indexName string /// Pointer to a null-terminated string that specifies the name of the index to create. ///
grbit CreateIndexGrbit Index creation options.
keyDescription string /// Pointer to a double null-terminated string of null-delimited tokens. ///
keyDescriptionLength int /// The length, in characters, of szKey including the two terminating nulls. ///
density int Initial B+ tree density.
Результат void

JetCreateIndex2() публичный статический Метод

Creates indexes over data in an ESE database.
When creating multiple indexes (i.e. with numIndexCreates greater than 1) this method MUST be called outside of any transactions and with exclusive access to the table. The JET_TABLEID returned by JetCreateTable will have exlusive access or the table can be opened for exclusive access by passing OpenTableGrbit.DenyRead to JetOpenTable.
public static JetCreateIndex2 ( JET_SESID sesid, JET_TABLEID tableid, Microsoft.Isam.Esent.Interop.JET_INDEXCREATE indexcreates, int numIndexCreates ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The table to create the index on.
indexcreates Microsoft.Isam.Esent.Interop.JET_INDEXCREATE Array of objects describing the indexes to be created.
numIndexCreates int Number of index description objects.
Результат void

JetCreateInstance() публичный статический Метод

Allocates a new instance of the database engine.
public static JetCreateInstance ( JET_INSTANCE &instance, string name ) : void
instance JET_INSTANCE Returns the new instance.
name string The name of the instance. Names must be unique.
Результат void

JetCreateInstance2() публичный статический Метод

Allocate a new instance of the database engine for use in a single process, with a display name specified.
public static JetCreateInstance2 ( JET_INSTANCE &instance, string name, string displayName, CreateInstanceGrbit grbit ) : void
instance JET_INSTANCE Returns the newly create instance.
name string /// Specifies a unique string identifier for the instance to be created. /// This string must be unique within a given process hosting the /// database engine. ///
displayName string /// A display name for the instance to be created. This will be used /// in eventlog entries. ///
grbit CreateInstanceGrbit Creation options.
Результат void

JetCreateTable() публичный статический Метод

Create an empty table. The newly created table is opened exclusively.
public static JetCreateTable ( JET_SESID sesid, JET_DBID dbid, string table, int pages, int density, JET_TABLEID &tableid ) : void
sesid JET_SESID The session to use.
dbid JET_DBID The database to create the table in.
table string The name of the table to create.
pages int Initial number of pages in the table.
density int /// The default density of the table. This is used when doing sequential inserts. ///
tableid JET_TABLEID Returns the tableid of the new table.
Результат void

JetDefragment() публичный статический Метод

Starts and stops database defragmentation tasks that improves data organization within a database.
public static JetDefragment ( JET_SESID sesid, JET_DBID dbid, string tableName, int &passes, int &seconds, DefragGrbit grbit ) : JET_wrn
sesid JET_SESID The session to use for the call.
dbid JET_DBID The database to be defragmented.
tableName string /// Unused parameter. Defragmentation is performed for the entire database described by the given database ID. ///
passes int /// When starting an online defragmentation task, this parameter sets the maximum number of defragmentation /// passes. When stopping an online defragmentation task, this parameter is set to the number of passes /// performed. ///
seconds int /// When starting an online defragmentation task, this parameter sets /// the maximum time for defragmentation. When stopping an online /// defragmentation task, this output buffer is set to the length of /// time used for defragmentation. ///
grbit DefragGrbit Defragmentation options.
Результат JET_wrn

JetDefragment2() публичный статический Метод

Starts and stops database defragmentation tasks that improves data organization within a database.
The callback passed to JetDefragment2 can be executed asynchronously. The GC doesn't know that the unmanaged code has a reference to the callback so it is important to make sure the callback isn't collected.
public static JetDefragment2 ( JET_SESID sesid, JET_DBID dbid, string tableName, int &passes, int &seconds, JET_CALLBACK callback, DefragGrbit grbit ) : JET_wrn
sesid JET_SESID The session to use for the call.
dbid JET_DBID The database to be defragmented.
tableName string /// Unused parameter. Defragmentation is performed for the entire database described by the given database ID. ///
passes int /// When starting an online defragmentation task, this parameter sets the maximum number of defragmentation /// passes. When stopping an online defragmentation task, this parameter is set to the number of passes /// performed. ///
seconds int /// When starting an online defragmentation task, this parameter sets /// the maximum time for defragmentation. When stopping an online /// defragmentation task, this output buffer is set to the length of /// time used for defragmentation. ///
callback JET_CALLBACK Callback function that defrag uses to report progress.
grbit DefragGrbit Defragmentation options.
Результат JET_wrn

JetDelete() публичный статический Метод

Deletes the current record in a database table.
public static JetDelete ( JET_SESID sesid, JET_TABLEID tableid ) : void
sesid JET_SESID The session that opened the cursor.
tableid JET_TABLEID The cursor on a database table. The current row will be deleted.
Результат void

JetDeleteColumn() публичный статический Метод

Deletes a column from a database table.
public static JetDeleteColumn ( JET_SESID sesid, JET_TABLEID tableid, string column ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID A cursor on the table to delete the column from.
column string The name of the column to be deleted.
Результат void

JetDeleteColumn2() публичный статический Метод

Deletes a column from a database table.
public static JetDeleteColumn2 ( JET_SESID sesid, JET_TABLEID tableid, string column, DeleteColumnGrbit grbit ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID A cursor on the table to delete the column from.
column string The name of the column to be deleted.
grbit DeleteColumnGrbit Column deletion options.
Результат void

JetDeleteIndex() публичный статический Метод

Deletes an index from a database table.
public static JetDeleteIndex ( JET_SESID sesid, JET_TABLEID tableid, string index ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID A cursor on the table to delete the index from.
index string The name of the index to be deleted.
Результат void

JetDeleteTable() публичный статический Метод

Deletes a table from a database.
public static JetDeleteTable ( JET_SESID sesid, JET_DBID dbid, string table ) : void
sesid JET_SESID The session to use.
dbid JET_DBID The database to delete the table from.
table string The name of the table to delete.
Результат void

JetDetachDatabase() публичный статический Метод

Releases a database file that was previously attached to a database session.
public static JetDetachDatabase ( JET_SESID sesid, string database ) : void
sesid JET_SESID The database session to use.
database string The database to detach.
Результат void

JetDupCursor() публичный статический Метод

Duplicates an open cursor and returns a handle to the duplicated cursor. If the cursor that was duplicated was a read-only cursor then the duplicated cursor is also a read-only cursor. Any state related to constructing a search key or updating a record is not copied into the duplicated cursor. In addition, the location of the original cursor is not duplicated into the duplicated cursor. The duplicated cursor is always opened on the clustered index and its location is always on the first row of the table.
public static JetDupCursor ( JET_SESID sesid, JET_TABLEID tableid, JET_TABLEID &newTableid, DupCursorGrbit grbit ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to duplicate.
newTableid JET_TABLEID The duplicated cursor.
grbit DupCursorGrbit Reserved for future use.
Результат void

JetDupSession() публичный статический Метод

Initialize a new ESE session in the same instance as the given sesid.
public static JetDupSession ( JET_SESID sesid, JET_SESID &newSesid ) : void
sesid JET_SESID The session to duplicate.
newSesid JET_SESID Returns the new session.
Результат void

JetEndExternalBackupInstance() публичный статический Метод

Ends an external backup session. This API is the last API in a series of APIs that must be called to execute a successful online (non-VSS based) backup.
public static JetEndExternalBackupInstance ( JET_INSTANCE instance ) : void
instance JET_INSTANCE The instance to end the backup for.
Результат void

JetEndExternalBackupInstance2() публичный статический Метод

Ends an external backup session. This API is the last API in a series of APIs that must be called to execute a successful online (non-VSS based) backup.
public static JetEndExternalBackupInstance2 ( JET_INSTANCE instance, EndExternalBackupGrbit grbit ) : void
instance JET_INSTANCE The instance to end the backup for.
grbit EndExternalBackupGrbit Options that specify how the backup ended.
Результат void

JetEndSession() публичный статический Метод

Ends a session.
public static JetEndSession ( JET_SESID sesid, EndSessionGrbit grbit ) : void
sesid JET_SESID The session to end.
grbit EndSessionGrbit This parameter is not used.
Результат void

JetEscrowUpdate() публичный статический Метод

Performs an atomic addition operation on one column. This function allows multiple sessions to update the same record concurrently without conflicts. Also see EscrowUpdate.
public static JetEscrowUpdate ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, byte delta, int deltaSize, byte previousValue, int previousValueLength, int &actualPreviousValueLength, EscrowUpdateGrbit grbit ) : void
sesid JET_SESID /// The session to use. The session must be in a transaction. ///
tableid JET_TABLEID The cursor to update.
columnid JET_COLUMNID /// The column to update. This must be an escrow updatable column. ///
delta byte The buffer containing the addend.
deltaSize int The size of the addend.
previousValue byte /// An output buffer that will recieve the current value of the column. This buffer /// can be null. ///
previousValueLength int The size of the previousValue buffer.
actualPreviousValueLength int Returns the actual size of the previousValue.
grbit EscrowUpdateGrbit Escrow update options.
Результат void

JetFreeBuffer() публичный статический Метод

Frees memory that was allocated by a database engine call.
This method is internal because we never expose the memory allocated by ESENT to our callers.
public static JetFreeBuffer ( IntPtr buffer ) : void
buffer System.IntPtr /// The buffer allocated by a call to the database engine. /// is acceptable, and will be ignored. ///
Результат void

JetGetBookmark() публичный статический Метод

Retrieves the bookmark for the record that is associated with the index entry at the current position of a cursor. This bookmark can then be used to reposition that cursor back to the same record using JetGotoBookmark. The bookmark will be no longer than SystemParameters.BookmarkMost bytes. Also see GetBookmark.
public static JetGetBookmark ( JET_SESID sesid, JET_TABLEID tableid, byte bookmark, int bookmarkSize, int &actualBookmarkSize ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to retrieve the bookmark from.
bookmark byte Buffer to contain the bookmark.
bookmarkSize int Size of the bookmark buffer.
actualBookmarkSize int Returns the actual size of the bookmark.
Результат void

JetGetColumnInfo() публичный статический Метод

Retrieves information about a table column.
public static JetGetColumnInfo ( JET_SESID sesid, JET_DBID dbid, string tablename, string columnName, JET_COLUMNDEF &columndef ) : void
sesid JET_SESID The session to use.
dbid JET_DBID The database that contains the table.
tablename string The name of the table containing the column.
columnName string The name of the column.
columndef JET_COLUMNDEF Filled in with information about the column.
Результат void

JetGetColumnInfo() публичный статический Метод

Retrieves information about all columns in a table.
public static JetGetColumnInfo ( JET_SESID sesid, JET_DBID dbid, string tablename, string columnName, JET_COLUMNLIST &columnlist ) : void
sesid JET_SESID The session to use.
dbid JET_DBID The database that contains the table.
tablename string The name of the table containing the column.
columnName string This parameter is ignored.
columnlist JET_COLUMNLIST Filled in with information about the columns in the table.
Результат void

JetGetCurrentIndex() публичный статический Метод

Ddetermines the name of the current index of a given cursor. This name is also used to later re-select that index as the current index using JetSetCurrentIndex. It can also be used to discover the properties of that index using JetGetTableIndexInfo.
public static JetGetCurrentIndex ( JET_SESID sesid, JET_TABLEID tableid, string &indexName, int maxNameLength ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to get the index name for.
indexName string Returns the name of the index.
maxNameLength int /// The maximum length of the index name. Index names are no more than /// characters. ///
Результат void

JetGetIndexInfo() публичный статический Метод

Retrieves information about indexes on a table.
public static JetGetIndexInfo ( JET_SESID sesid, JET_DBID dbid, string tablename, string ignored, JET_INDEXLIST &indexlist ) : void
sesid JET_SESID The session to use.
dbid JET_DBID The database to use.
tablename string The name of the table to retrieve index information about.
ignored string This parameter is ignored.
indexlist JET_INDEXLIST Filled in with information about indexes on the table.
Результат void

JetGetInstanceInfo() публичный статический Метод

Retrieves information about the instances that are running.
public static JetGetInstanceInfo ( int &numInstances, JET_INSTANCE_INFO &instances ) : void
numInstances int /// Returns the number of instances. ///
instances JET_INSTANCE_INFO /// Returns an array of instance info objects, one for each running /// instance. ///
Результат void

JetGetLS() публичный статический Метод

Enables the application to retrieve the context handle known as Local Storage that is associated with a cursor or the table associated with that cursor. This context handle must have been previously set using JetSetLS. JetGetLS can also be used to simultaneously fetch the current context handle for a cursor or table and reset that context handle.
public static JetGetLS ( JET_SESID sesid, JET_TABLEID tableid, JET_LS &ls, LsGrbit grbit ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to use.
ls JET_LS Returns the retrieved context handle.
grbit LsGrbit Retrieve options.
Результат void

JetGetLock() публичный статический Метод

Explicitly reserve the ability to update a row, write lock, or to explicitly prevent a row from being updated by any other session, read lock. Normally, row write locks are acquired implicitly as a result of updating rows. Read locks are usually not required because of record versioning. However, in some cases a transaction may desire to explicitly lock a row to enforce serialization, or to ensure that a subsequent operation will succeed.
public static JetGetLock ( JET_SESID sesid, JET_TABLEID tableid, GetLockGrbit grbit ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to use. A lock will be acquired on the current record.
grbit GetLockGrbit Lock options, use this to specify which type of lock to obtain.
Результат void

JetGetObjectInfo() публичный статический Метод

Retrieves information about database objects.
public static JetGetObjectInfo ( JET_SESID sesid, JET_DBID dbid, JET_OBJECTLIST &objectlist ) : void
sesid JET_SESID The session to use.
dbid JET_DBID The database to use.
objectlist JET_OBJECTLIST Filled in with information about the objects in the database.
Результат void

JetGetRecordPosition() публичный статический Метод

Returns the fractional position of the current record in the current index in the form of a JET_RECPOS structure. Also see JetGotoPosition.
public static JetGetRecordPosition ( JET_SESID sesid, JET_TABLEID tableid, JET_RECPOS &recpos ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor positioned on the record.
recpos JET_RECPOS Returns the approximate fractional position of the record.
Результат void

JetGetRecordSize() публичный статический Метод

Retrieves record size information from the desired location.
public static JetGetRecordSize ( JET_SESID sesid, JET_TABLEID tableid, JET_RECSIZE &recsize, GetRecordSizeGrbit grbit ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID /// The cursor that will be used for the API call. The cursor must be /// positioned on a record, or have an update prepared. ///
recsize JET_RECSIZE Returns the size of the record.
grbit GetRecordSizeGrbit Call options.
Результат void

JetGetSecondaryIndexBookmark() публичный статический Метод

Retrieves a special bookmark for the secondary index entry at the current position of a cursor. This bookmark can then be used to efficiently reposition that cursor back to the same index entry using JetGotoSecondaryIndexBookmark. This is most useful when repositioning on a secondary index that contains duplicate keys or that contains multiple index entries for the same record.
public static JetGetSecondaryIndexBookmark ( JET_SESID sesid, JET_TABLEID tableid, byte secondaryKey, int secondaryKeySize, int &actualSecondaryKeySize, byte primaryKey, int primaryKeySize, int &actualPrimaryKeySize, GetSecondaryIndexBookmarkGrbit grbit ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to retrieve the bookmark from.
secondaryKey byte Output buffer for the secondary key.
secondaryKeySize int Size of the secondary key buffer.
actualSecondaryKeySize int Returns the size of the secondary key.
primaryKey byte Output buffer for the primary key.
primaryKeySize int Size of the primary key buffer.
actualPrimaryKeySize int Returns the size of the primary key.
grbit GetSecondaryIndexBookmarkGrbit Options for the call.
Результат void

JetGetSystemParameter() публичный статический Метод

Gets database configuration options.
JET_param.ErrorToString passes in the error number in the paramValue, which is why it is a ref parameter and not an out parameter.
public static JetGetSystemParameter ( JET_INSTANCE instance, JET_SESID sesid, JET_param paramid, int &paramValue, string &paramString, int maxParam ) : JET_wrn
instance JET_INSTANCE The instance to retrieve the options from.
sesid JET_SESID The session to use.
paramid JET_param The parameter to get.
paramValue int Returns the value of the parameter, if the value is an integer.
paramString string Returns the value of the parameter, if the value is a string.
maxParam int The maximum size of the parameter string.
Результат JET_wrn

JetGetTableColumnInfo() публичный статический Метод

Retrieves information about a table column.
public static JetGetTableColumnInfo ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, JET_COLUMNDEF &columndef ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The table containing the column.
columnid JET_COLUMNID The columnid of the column.
columndef JET_COLUMNDEF Filled in with information about the column.
Результат void

JetGetTableColumnInfo() публичный статический Метод

Retrieves information about a table column.
public static JetGetTableColumnInfo ( JET_SESID sesid, JET_TABLEID tableid, string columnName, JET_COLUMNDEF &columndef ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The table containing the column.
columnName string The name of the column.
columndef JET_COLUMNDEF Filled in with information about the column.
Результат void

JetGetTableColumnInfo() публичный статический Метод

Retrieves information about all columns in the table.
public static JetGetTableColumnInfo ( JET_SESID sesid, JET_TABLEID tableid, string columnName, JET_COLUMNLIST &columnlist ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The table containing the column.
columnName string The parameter is ignored.
columnlist JET_COLUMNLIST Filled in with information about the columns in the table.
Результат void

JetGetTableIndexInfo() публичный статический Метод

Retrieves information about indexes on a table.
public static JetGetTableIndexInfo ( JET_SESID sesid, JET_TABLEID tableid, string ignored, JET_INDEXLIST &indexlist ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The table to retrieve index information about.
ignored string This parameter is ignored.
indexlist JET_INDEXLIST Filled in with information about indexes on the table.
Результат void

JetGotoBookmark() публичный статический Метод

Positions a cursor to an index entry for the record that is associated with the specified bookmark. The bookmark can be used with any index defined over a table. The bookmark for a record can be retrieved using JetGetBookmark.
public static JetGotoBookmark ( JET_SESID sesid, JET_TABLEID tableid, byte bookmark, int bookmarkSize ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to position.
bookmark byte The bookmark used to position the cursor.
bookmarkSize int The size of the bookmark.
Результат void

JetGotoPosition() публичный статический Метод

Moves a cursor to a new location that is a fraction of the way through the current index. Also see JetGetRecordPosition.
public static JetGotoPosition ( JET_SESID sesid, JET_TABLEID tableid, JET_RECPOS recpos ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to position.
recpos JET_RECPOS The approximate position to move to.
Результат void

JetGotoSecondaryIndexBookmark() публичный статический Метод

Positions a cursor to an index entry that is associated with the specified secondary index bookmark. The secondary index bookmark must be used with the same index over the same table from which it was originally retrieved. The secondary index bookmark for an index entry can be retrieved using JetGotoSecondaryIndexBookmark.
public static JetGotoSecondaryIndexBookmark ( JET_SESID sesid, JET_TABLEID tableid, byte secondaryKey, int secondaryKeySize, byte primaryKey, int primaryKeySize, GotoSecondaryIndexBookmarkGrbit grbit ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The table cursor to position.
secondaryKey byte The buffer that contains the secondary key.
secondaryKeySize int The size of the secondary key.
primaryKey byte The buffer that contains the primary key.
primaryKeySize int The size of the primary key.
grbit GotoSecondaryIndexBookmarkGrbit Options for positioning the bookmark.
Результат void

JetGrowDatabase() публичный статический Метод

Extends the size of a database that is currently open.
public static JetGrowDatabase ( JET_SESID sesid, JET_DBID dbid, int desiredPages, int &actualPages ) : void
sesid JET_SESID The session to use.
dbid JET_DBID The database to grow.
desiredPages int The desired size of the database, in pages.
actualPages int /// The size of the database, in pages, after the call. ///
Результат void

JetIdle() публичный статический Метод

Performs idle cleanup tasks or checks the version store status in ESE.
public static JetIdle ( JET_SESID sesid, IdleGrbit grbit ) : JET_wrn
sesid JET_SESID The session to use.
grbit IdleGrbit A combination of JetIdleGrbit flags.
Результат JET_wrn

JetIndexRecordCount() публичный статический Метод

Counts the number of entries in the current index from the current position forward. The current position is included in the count. The count can be greater than the total number of records in the table if the current index is over a multi-valued column and instances of the column have multiple-values. If the table is empty, then 0 will be returned for the count.
public static JetIndexRecordCount ( JET_SESID sesid, JET_TABLEID tableid, int &numRecords, int maxRecordsToCount ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to count the records in.
numRecords int Returns the number of records.
maxRecordsToCount int /// The maximum number of records to count. A value of 0 indicates that the count /// is unlimited. ///
Результат void

JetInit() публичный статический Метод

Initialize the ESENT database engine.
public static JetInit ( JET_INSTANCE &instance ) : void
instance JET_INSTANCE /// The instance to initialize. If an instance hasn't been /// allocated then a new one is created and the engine /// will operate in single-instance mode. ///
Результат void

JetInit2() публичный статический Метод

Initialize the ESENT database engine.
public static JetInit2 ( JET_INSTANCE &instance, InitGrbit grbit ) : JET_wrn
instance JET_INSTANCE /// The instance to initialize. If an instance hasn't been /// allocated then a new one is created and the engine /// will operate in single-instance mode. ///
grbit InitGrbit /// Initialization options. ///
Результат JET_wrn

JetIntersectIndexes() публичный статический Метод

Computes the intersection between multiple sets of index entries from different secondary indices over the same table. This operation is useful for finding the set of records in a table that match two or more criteria that can be expressed using index ranges. Also see IntersectIndexes.
public static JetIntersectIndexes ( JET_SESID sesid, JET_INDEXRANGE ranges, int numRanges, JET_RECORDLIST &recordlist, IntersectIndexesGrbit grbit ) : void
sesid JET_SESID The session to use.
ranges JET_INDEXRANGE /// An the index ranges to intersect. The tableids in the ranges /// must have index ranges set on them. Use /// to create an index range. ///
numRanges int /// The number of index ranges. ///
recordlist JET_RECORDLIST /// Returns information about the temporary table containing the intersection results. ///
grbit IntersectIndexesGrbit Intersection options.
Результат void

JetMakeKey() публичный статический Метод

Constructs search keys that may then be used by JetSeek and JetSetIndexRange.
The MakeKey functions provide datatype-specific make key functionality.
public static JetMakeKey ( JET_SESID sesid, JET_TABLEID tableid, byte data, int dataSize, MakeKeyGrbit grbit ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to create the key on.
data byte Column data for the current key column of the current index.
dataSize int Size of the data.
grbit MakeKeyGrbit Key options.
Результат void

JetMove() публичный статический Метод

Navigate through an index. The cursor can be positioned at the start or end of the index and moved backwards and forwards by a specified number of index entries. Also see TryMoveFirst, TryMoveLast, TryMoveNext, TryMovePrevious.
public static JetMove ( JET_SESID sesid, JET_TABLEID tableid, JET_Move numRows, MoveGrbit grbit ) : void
sesid JET_SESID The session to use for the call.
tableid JET_TABLEID The cursor to position.
numRows JET_Move An offset which indicates how far to move the cursor.
grbit MoveGrbit Move options.
Результат void

JetMove() публичный статический Метод

Navigate through an index. The cursor can be positioned at the start or end of the index and moved backwards and forwards by a specified number of index entries. Also see TryMoveFirst, TryMoveLast, TryMoveNext, TryMovePrevious.
public static JetMove ( JET_SESID sesid, JET_TABLEID tableid, int numRows, MoveGrbit grbit ) : void
sesid JET_SESID The session to use for the call.
tableid JET_TABLEID The cursor to position.
numRows int An offset which indicates how far to move the cursor.
grbit MoveGrbit Move options.
Результат void

JetOSSnapshotFreeze() публичный статический Метод

Starts a snapshot. While the snapshot is in progress, no write-to-disk activity by the engine can take place.
public static JetOSSnapshotFreeze ( JET_OSSNAPID snapshot, int &numInstances, JET_INSTANCE_INFO &instances, SnapshotFreezeGrbit grbit ) : void
snapshot JET_OSSNAPID The snapshot session.
numInstances int /// Returns the number of instances that are part of the snapshot session. ///
instances JET_INSTANCE_INFO /// Returns information about the instances that are part of the snapshot session. ///
grbit SnapshotFreezeGrbit /// Snapshot freeze options. ///
Результат void

JetOSSnapshotPrepare() публичный статический Метод

Begins the preparations for a snapshot session. A snapshot session is a short time interval in which the engine does not issue any write IOs to disk, so that the engine can participate in a volume snapshot session (when driven by a snapshot writer).
public static JetOSSnapshotPrepare ( JET_OSSNAPID &snapshot, SnapshotPrepareGrbit grbit ) : void
snapshot JET_OSSNAPID Returns the ID of the snapshot session.
grbit SnapshotPrepareGrbit Snapshot options.
Результат void

JetOSSnapshotThaw() публичный статический Метод

Notifies the engine that it can resume normal IO operations after a freeze period and a successful snapshot.
public static JetOSSnapshotThaw ( JET_OSSNAPID snapshot, SnapshotThawGrbit grbit ) : void
snapshot JET_OSSNAPID The ID of the snapshot.
grbit SnapshotThawGrbit Thaw options.
Результат void

JetOpenDatabase() публичный статический Метод

Opens a database previously attached with JetAttachDatabase, for use with a database session. This function can be called multiple times for the same database.
public static JetOpenDatabase ( JET_SESID sesid, string database, string connect, JET_DBID &dbid, OpenDatabaseGrbit grbit ) : JET_wrn
sesid JET_SESID The session that is opening the database.
database string The database to open.
connect string Reserved for future use.
dbid JET_DBID Returns the dbid of the attached database.
grbit OpenDatabaseGrbit Open database options.
Результат JET_wrn

JetOpenFileInstance() публичный статический Метод

Opens an attached database, database patch file, or transaction log file of an active instance for the purpose of performing a streaming fuzzy backup. The data from these files can subsequently be read through the returned handle using JetReadFileInstance. The returned handle must be closed using JetCloseFileInstance. An external backup of the instance must have been previously initiated using JetBeginExternalBackupInstance.
public static JetOpenFileInstance ( JET_INSTANCE instance, string file, JET_HANDLE &handle, long &fileSizeLow, long &fileSizeHigh ) : void
instance JET_INSTANCE The instance to use.
file string The file to open.
handle JET_HANDLE Returns a handle to the file.
fileSizeLow long Returns the least significant 32 bits of the file size.
fileSizeHigh long Returns the most significant 32 bits of the file size.
Результат void

JetOpenTable() публичный статический Метод

Opens a cursor on a previously created table.
public static JetOpenTable ( JET_SESID sesid, JET_DBID dbid, string tablename, byte parameters, int parametersSize, OpenTableGrbit grbit, JET_TABLEID &tableid ) : void
sesid JET_SESID The database session to use.
dbid JET_DBID The database to open the table in.
tablename string The name of the table to open.
parameters byte The parameter is not used.
parametersSize int The parameter is not used.
grbit OpenTableGrbit Table open options.
tableid JET_TABLEID Returns the opened table.
Результат void

JetOpenTempTable() публичный статический Метод

Creates a temporary table with a single index. A temporary table stores and retrieves records just like an ordinary table created using JetCreateTableColumnIndex. However, temporary tables are much faster than ordinary tables due to their volatile nature. They can also be used to very quickly sort and perform duplicate removal on record sets when accessed in a purely sequential manner. Also see Api.JetOpenTempTable2, Api.JetOpenTempTable3. VistaApi.JetOpenTemporaryTable.
public static JetOpenTempTable ( JET_SESID sesid, JET_COLUMNDEF columns, int numColumns, TempTableGrbit grbit, JET_TABLEID &tableid, JET_COLUMNID columnids ) : void
sesid JET_SESID The session to use.
columns JET_COLUMNDEF /// Column definitions for the columns created in the temporary table. ///
numColumns int Number of column definitions.
grbit TempTableGrbit Table creation options.
tableid JET_TABLEID /// Returns the tableid of the temporary table. Closing this tableid /// with frees the resources associated /// with the temporary table. ///
columnids JET_COLUMNID /// The output buffer that receives the array of column IDs generated /// during the creation of the temporary table. The column IDs in this /// array will exactly correspond to the input array of column definitions. /// As a result, the size of this buffer must correspond to the size of /// the input array. ///
Результат void

JetOpenTempTable2() публичный статический Метод

Creates a temporary table with a single index. A temporary table stores and retrieves records just like an ordinary table created using JetCreateTableColumnIndex. However, temporary tables are much faster than ordinary tables due to their volatile nature. They can also be used to very quickly sort and perform duplicate removal on record sets when accessed in a purely sequential manner. Also see Api.JetOpenTempTable, Api.JetOpenTempTable3. VistaApi.JetOpenTemporaryTable.
public static JetOpenTempTable2 ( JET_SESID sesid, JET_COLUMNDEF columns, int numColumns, int lcid, TempTableGrbit grbit, JET_TABLEID &tableid, JET_COLUMNID columnids ) : void
sesid JET_SESID The session to use.
columns JET_COLUMNDEF /// Column definitions for the columns created in the temporary table. ///
numColumns int Number of column definitions.
lcid int /// The locale ID to use to compare any Unicode key column data in the temporary table. /// Any locale may be used as long as the appropriate language pack has been installed /// on the machine. ///
grbit TempTableGrbit Table creation options.
tableid JET_TABLEID /// Returns the tableid of the temporary table. Closing this tableid /// with frees the resources associated /// with the temporary table. ///
columnids JET_COLUMNID /// The output buffer that receives the array of column IDs generated /// during the creation of the temporary table. The column IDs in this /// array will exactly correspond to the input array of column definitions. /// As a result, the size of this buffer must correspond to the size of /// the input array. ///
Результат void

JetOpenTempTable3() публичный статический Метод

Creates a temporary table with a single index. A temporary table stores and retrieves records just like an ordinary table created using JetCreateTableColumnIndex. However, temporary tables are much faster than ordinary tables due to their volatile nature. They can also be used to very quickly sort and perform duplicate removal on record sets when accessed in a purely sequential manner. Also see Api.JetOpenTempTable, Api.JetOpenTempTable2, VistaApi.JetOpenTemporaryTable.
public static JetOpenTempTable3 ( JET_SESID sesid, JET_COLUMNDEF columns, int numColumns, JET_UNICODEINDEX unicodeindex, TempTableGrbit grbit, JET_TABLEID &tableid, JET_COLUMNID columnids ) : void
sesid JET_SESID The session to use.
columns JET_COLUMNDEF /// Column definitions for the columns created in the temporary table. ///
numColumns int Number of column definitions.
unicodeindex JET_UNICODEINDEX /// The Locale ID and normalization flags that will be used to compare /// any Unicode key column data in the temporary table. When this /// is not present then the default options are used. ///
grbit TempTableGrbit Table creation options.
tableid JET_TABLEID /// Returns the tableid of the temporary table. Closing this tableid /// with frees the resources associated /// with the temporary table. ///
columnids JET_COLUMNID /// The output buffer that receives the array of column IDs generated /// during the creation of the temporary table. The column IDs in this /// array will exactly correspond to the input array of column definitions. /// As a result, the size of this buffer must correspond to the size of /// the input array. ///
Результат void

JetPrepareUpdate() публичный статический Метод

Prepare a cursor for update.
public static JetPrepareUpdate ( JET_SESID sesid, JET_TABLEID tableid, JET_prep prep ) : void
sesid JET_SESID The session which is starting the update.
tableid JET_TABLEID The cursor to start the update for.
prep JET_prep The type of update to prepare.
Результат void

JetReadFileInstance() публичный статический Метод

Retrieves the contents of a file opened with Api.JetOpenFileInstance.
public static JetReadFileInstance ( JET_INSTANCE instance, JET_HANDLE file, byte buffer, int bufferSize, int &bytesRead ) : void
instance JET_INSTANCE The instance to use.
file JET_HANDLE The file to read from.
buffer byte The buffer to read into.
bufferSize int The size of the buffer.
bytesRead int Returns the amount of data read into the buffer.
Результат void

JetRegisterCallback() публичный статический Метод

Allows the application to configure the database engine to issue notifications to the application for specific events. These notifications are associated with a specific table and remain in effect only until the instance containing the table is shut down using JetTerm.
public static JetRegisterCallback ( JET_SESID sesid, JET_TABLEID tableid, JET_cbtyp cbtyp, JET_CALLBACK callback, IntPtr context, JET_HANDLE &callbackId ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID /// A cursor opened on the table that the callback should be /// registered on. ///
cbtyp JET_cbtyp /// The callback reasons for which the application wishes to receive notifications. ///
callback JET_CALLBACK The callback function.
context IntPtr A context that will be given to the callback.
callbackId JET_HANDLE /// A handle that can later be used to cancel the registration of the given /// callback function using . ///
Результат void

JetRenameColumn() публичный статический Метод

Changes the name of an existing column.
public static JetRenameColumn ( JET_SESID sesid, JET_TABLEID tableid, string name, string newName, RenameColumnGrbit grbit ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The table containing the column.
name string The name of the column.
newName string The new name of the column.
grbit RenameColumnGrbit Column rename options.
Результат void

JetRenameTable() публичный статический Метод

Changes the name of an existing table.
public static JetRenameTable ( JET_SESID sesid, JET_DBID dbid, string tableName, string newTableName ) : void
sesid JET_SESID The session to use.
dbid JET_DBID The database containing the table.
tableName string The name of the table.
newTableName string The new name of the table.
Результат void

JetResetSessionContext() публичный статический Метод

Disassociates a session from the current thread. This should be used in conjunction with JetSetSessionContext.
public static JetResetSessionContext ( JET_SESID sesid ) : void
sesid JET_SESID The session to use.
Результат void

JetResetTableSequential() публичный статический Метод

Notifies the database engine that the application is no longer scanning the entire index the cursor is positioned on. This call reverses a notification sent by JetSetTableSequential.
public static JetResetTableSequential ( JET_SESID sesid, JET_TABLEID tableid, ResetTableSequentialGrbit grbit ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor that was accessing the data.
grbit ResetTableSequentialGrbit Reserved for future use.
Результат void

JetRestoreInstance() публичный статический Метод

Restores and recovers a streaming backup of an instance including all the attached databases. It is designed to work with a backup created with the Api.JetBackupInstance function. This is the simplest and most encapsulated restore function.
public static JetRestoreInstance ( JET_INSTANCE instance, string source, string destination, JET_PFNSTATUS statusCallback ) : void
instance JET_INSTANCE /// The instance to use. The instance should not be initialized. /// Restoring the files will initialize the instance. ///
source string /// Location of the backup. The backup should have been created with /// . ///
destination string /// Name of the folder where the database files from the backup set will /// be copied and recovered. If this is set to null, the database files /// will be copied and recovered to their original location. ///
statusCallback JET_PFNSTATUS /// Optional status notification callback. ///
Результат void

JetRetrieveColumn() публичный статический Метод

Retrieves a single column value from the current record. The record is that record associated with the index entry at the current position of the cursor. Alternatively, this function can retrieve a column from a record being created in the cursor copy buffer. This function can also retrieve column data from an index entry that references the current record. In addition to retrieving the actual column value, JetRetrieveColumn can also be used to retrieve the size of a column, before retrieving the column data itself so that application buffers can be sized appropriately.
The RetrieveColumnAs functions provide datatype-specific retrieval functions.
public static JetRetrieveColumn ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, byte data, int dataSize, int &actualDataSize, RetrieveColumnGrbit grbit, JET_RETINFO retinfo ) : JET_wrn
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to retrieve the column from.
columnid JET_COLUMNID The columnid to retrieve.
data byte The data buffer to be retrieved into.
dataSize int The size of the data buffer.
actualDataSize int Returns the actual size of the data buffer.
grbit RetrieveColumnGrbit Retrieve column options.
retinfo JET_RETINFO /// If pretinfo is give as NULL then the function behaves as though an itagSequence /// of 1 and an ibLongValue of 0 (zero) were given. This causes column retrieval to /// retrieve the first value of a multi-valued column, and to retrieve long data at /// offset 0 (zero). ///
Результат JET_wrn

JetRetrieveColumns() публичный статический Метод

Retrieves multiple column values from the current record in a single operation. An array of JET_RETRIEVECOLUMN structures is used to describe the set of column values to be retrieved, and to describe output buffers for each column value to be retrieved.
public static JetRetrieveColumns ( JET_SESID sesid, JET_TABLEID tableid, JET_RETRIEVECOLUMN retrievecolumns, int numColumns ) : JET_wrn
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to retrieve the data from.
retrievecolumns JET_RETRIEVECOLUMN /// An array of one or more objects /// describing the data to be retrieved. ///
numColumns int /// The number of entries in the columns array. ///
Результат JET_wrn

JetRetrieveKey() публичный статический Метод

Retrieves the key for the index entry at the current position of a cursor. Also see RetrieveKey.
public static JetRetrieveKey ( JET_SESID sesid, JET_TABLEID tableid, byte data, int dataSize, int &actualDataSize, RetrieveKeyGrbit grbit ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to retrieve the key from.
data byte The buffer to retrieve the key into.
dataSize int The size of the buffer.
actualDataSize int Returns the actual size of the data.
grbit RetrieveKeyGrbit Retrieve key options.
Результат void

JetRollback() публичный статический Метод

Undoes the changes made to the state of the database and returns to the last save point. JetRollback will also close any cursors opened during the save point. If the outermost save point is undone, the session will exit the transaction.
public static JetRollback ( JET_SESID sesid, RollbackTransactionGrbit grbit ) : void
sesid JET_SESID The session to rollback the transaction for.
grbit RollbackTransactionGrbit Rollback options.
Результат void

JetSeek() публичный статический Метод

Efficiently positions a cursor to an index entry that matches the search criteria specified by the search key in that cursor and the specified inequality. A search key must have been previously constructed using JetMakeKey(JET_SESID,JET_TABLEID,byte[],int,MakeKeyGrbit). Also see TrySeek.
public static JetSeek ( JET_SESID sesid, JET_TABLEID tableid, SeekGrbit grbit ) : JET_wrn
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to position.
grbit SeekGrbit Seek options.
Результат JET_wrn

JetSetColumn() публичный статический Метод

The JetSetColumn function modifies a single column value in a modified record to be inserted or to update the current record. It can overwrite an existing value, add a new value to a sequence of values in a multi-valued column, remove a value from a sequence of values in a multi-valued column, or update all or part of a long value (a column of type JET_coltyp.LongText or JET_coltyp.LongBinary).
The SetColumn methods provide datatype-specific overrides which may be more efficient.
public static JetSetColumn ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, byte data, int dataSize, SetColumnGrbit grbit, JET_SETINFO setinfo ) : void
sesid JET_SESID The session which is performing the update.
tableid JET_TABLEID The cursor to update. An update should be prepared.
columnid JET_COLUMNID The columnid to set.
data byte The data to set.
dataSize int The size of data to set.
grbit SetColumnGrbit SetColumn options.
setinfo JET_SETINFO Used to specify itag or long-value offset.
Результат void

JetSetColumnDefaultValue() публичный статический Метод

Changes the default value of an existing column.
public static JetSetColumnDefaultValue ( JET_SESID sesid, JET_DBID dbid, string tableName, string columnName, byte data, int dataSize, SetColumnDefaultValueGrbit grbit ) : void
sesid JET_SESID The session to use.
dbid JET_DBID The database containing the column.
tableName string The name of the table containing the column.
columnName string The name of the column.
data byte The new default value.
dataSize int Size of the new default value.
grbit SetColumnDefaultValueGrbit Column default value options.
Результат void

JetSetColumns() публичный статический Метод

Allows an application to set multiple column values in a single operation. An array of JET_SETCOLUMN structures is used to describe the set of column values to be set, and to describe input buffers for each column value to be set.
public static JetSetColumns ( JET_SESID sesid, JET_TABLEID tableid, JET_SETCOLUMN setcolumns, int numColumns ) : JET_wrn
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to set the columns on.
setcolumns JET_SETCOLUMN /// An array of structures describing the /// data to set. ///
numColumns int /// Number of entries in the setcolumns parameter. ///
Результат JET_wrn

JetSetCurrentIndex() публичный статический Метод

Set the current index of a cursor.
public static JetSetCurrentIndex ( JET_SESID sesid, JET_TABLEID tableid, string index ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to set the index on.
index string /// The name of the index to be selected. If this is null or empty the primary /// index will be selected. ///
Результат void

JetSetCurrentIndex2() публичный статический Метод

Set the current index of a cursor.
public static JetSetCurrentIndex2 ( JET_SESID sesid, JET_TABLEID tableid, string index, SetCurrentIndexGrbit grbit ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to set the index on.
index string /// The name of the index to be selected. If this is null or empty the primary /// index will be selected. ///
grbit SetCurrentIndexGrbit /// Set index options. ///
Результат void

JetSetCurrentIndex3() публичный статический Метод

Set the current index of a cursor.
public static JetSetCurrentIndex3 ( JET_SESID sesid, JET_TABLEID tableid, string index, SetCurrentIndexGrbit grbit, int itagSequence ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to set the index on.
index string /// The name of the index to be selected. If this is null or empty the primary /// index will be selected. ///
grbit SetCurrentIndexGrbit /// Set index options. ///
itagSequence int /// Sequence number of the multi-valued column value which will be used /// to position the cursor on the new index. This parameter is only used /// in conjunction with . When /// this parameter is not present or is set to zero, its value is presumed /// to be 1. ///
Результат void

JetSetDatabaseSize() публичный статический Метод

Sets the size of an unopened database file.
public static JetSetDatabaseSize ( JET_SESID sesid, string database, int desiredPages, int &actualPages ) : void
sesid JET_SESID The session to use.
database string The name of the database.
desiredPages int The desired size of the database, in pages.
actualPages int /// The size of the database, in pages, after the call. ///
Результат void

JetSetIndexRange() публичный статический Метод

Temporarily limits the set of index entries that the cursor can walk using JetMove(JET_SESID,JET_TABLEID,int,MoveGrbit) to those starting from the current index entry and ending at the index entry that matches the search criteria specified by the search key in that cursor and the specified bound criteria. A search key must have been previously constructed using JetMakeKey(JET_SESID,JET_TABLEID,byte[],int,MakeKeyGrbit). Also see TrySetIndexRange.
public static JetSetIndexRange ( JET_SESID sesid, JET_TABLEID tableid, SetIndexRangeGrbit grbit ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to set the index range on.
grbit SetIndexRangeGrbit Index range options.
Результат void

JetSetLS() публичный статический Метод

Enables the application to associate a context handle known as Local Storage with a cursor or the table associated with that cursor. This context handle can be used by the application to store auxiliary data that is associated with a cursor or table. The application is later notified using a runtime callback when the context handle must be released. This makes it possible to associate dynamically allocated state with a cursor or table.
public static JetSetLS ( JET_SESID sesid, JET_TABLEID tableid, JET_LS ls, LsGrbit grbit ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to use.
ls JET_LS The context handle to be associated with the session or cursor.
grbit LsGrbit Set options.
Результат void

JetSetSessionContext() публичный статический Метод

Associates a session with the current thread using the given context handle. This association overrides the default engine requirement that a transaction for a given session must occur entirely on the same thread. Use JetResetSessionContext to remove the association.
public static JetSetSessionContext ( JET_SESID sesid, IntPtr context ) : void
sesid JET_SESID The session to set the context on.
context IntPtr The context to set.
Результат void

JetSetSystemParameter() публичный статический Метод

Sets database configuration options.
public static JetSetSystemParameter ( JET_INSTANCE instance, JET_SESID sesid, JET_param paramid, JET_CALLBACK paramValue, string paramString ) : JET_wrn
instance JET_INSTANCE /// The instance to set the option on or /// to set the option on all instances. ///
sesid JET_SESID The session to use.
paramid JET_param The parameter to set.
paramValue JET_CALLBACK The value of the parameter to set, if the parameter is an integer type.
paramString string The value of the parameter to set, if the parameter is a string type.
Результат JET_wrn

JetSetSystemParameter() публичный статический Метод

Sets database configuration options.
public static JetSetSystemParameter ( JET_INSTANCE instance, JET_SESID sesid, JET_param paramid, int paramValue, string paramString ) : JET_wrn
instance JET_INSTANCE /// The instance to set the option on or /// to set the option on all instances. ///
sesid JET_SESID The session to use.
paramid JET_param The parameter to set.
paramValue int The value of the parameter to set, if the parameter is an integer type.
paramString string The value of the parameter to set, if the parameter is a string type.
Результат JET_wrn

JetSetTableSequential() публичный статический Метод

Notifies the database engine that the application is scanning the entire index that the cursor is positioned on. Consequently, the methods that are used to access the index data will be tuned to make this scenario as fast as possible. Also see JetResetTableSequential.
public static JetSetTableSequential ( JET_SESID sesid, JET_TABLEID tableid, SetTableSequentialGrbit grbit ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor that will be accessing the data.
grbit SetTableSequentialGrbit Reserved for future use.
Результат void

JetStopBackupInstance() публичный статический Метод

Prevents streaming backup-related activity from continuing on a specific running instance, thus ending the streaming backup in a predictable way.
public static JetStopBackupInstance ( JET_INSTANCE instance ) : void
instance JET_INSTANCE The instance to use.
Результат void

JetStopServiceInstance() публичный статический Метод

Prepares an instance for termination.
public static JetStopServiceInstance ( JET_INSTANCE instance ) : void
instance JET_INSTANCE The (running) instance to use.
Результат void

JetTerm() публичный статический Метод

Terminate an instance that was created with JetInit or JetCreateInstance.
public static JetTerm ( JET_INSTANCE instance ) : void
instance JET_INSTANCE The instance to terminate.
Результат void

JetTerm2() публичный статический Метод

Terminate an instance that was created with JetInit or JetCreateInstance.
public static JetTerm2 ( JET_INSTANCE instance, TermGrbit grbit ) : void
instance JET_INSTANCE The instance to terminate.
grbit TermGrbit Termination options.
Результат void

JetTruncateLogInstance() публичный статический Метод

Used during a backup initiated by JetBeginExternalBackup to delete any transaction log files that will no longer be needed once the current backup completes successfully.
public static JetTruncateLogInstance ( JET_INSTANCE instance ) : void
instance JET_INSTANCE The instance to truncate.
Результат void

JetUnregisterCallback() публичный статический Метод

Configures the database engine to stop issuing notifications to the application as previously requested through JetRegisterCallback.
public static JetUnregisterCallback ( JET_SESID sesid, JET_TABLEID tableid, JET_cbtyp cbtyp, JET_HANDLE callbackId ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID /// A cursor opened on the table that the callback should be /// registered on. ///
cbtyp JET_cbtyp /// The callback reasons for which the application no longer wishes to receive notifications. ///
callbackId JET_HANDLE /// The handle of the registered callback that was returned by . ///
Результат void

JetUpdate() публичный статический Метод

The JetUpdate function performs an update operation including inserting a new row into a table or updating an existing row. Deleting a table row is performed by calling JetDelete.
JetUpdate is the final step in performing an insert or an update. The update is begun by calling JetPrepareUpdate and then by calling JetSetColumn(JET_SESID,JET_TABLEID,JET_COLUMNID,byte[],int,SetColumnGrbit,JET_SETINFO) one or more times to set the record state. Finally, JetUpdate(JET_SESID,JET_TABLEID,byte[],int,out int) is called to complete the update operation. Indexes are updated only by JetUpdate or and not during JetSetColumn.
public static JetUpdate ( JET_SESID sesid, JET_TABLEID tableid ) : void
sesid JET_SESID The session which started the update.
tableid JET_TABLEID The cursor to update. An update should be prepared.
Результат void

JetUpdate() публичный статический Метод

The JetUpdate function performs an update operation including inserting a new row into a table or updating an existing row. Deleting a table row is performed by calling JetDelete.
JetUpdate is the final step in performing an insert or an update. The update is begun by calling JetPrepareUpdate and then by calling JetSetColumn(JET_SESID,JET_TABLEID,JET_COLUMNID,byte[],int,SetColumnGrbit,JET_SETINFO) one or more times to set the record state. Finally, JetUpdate(JET_SESID,JET_TABLEID,byte[],int,out int) is called to complete the update operation. Indexes are updated only by JetUpdate or and not during JetSetColumn.
public static JetUpdate ( JET_SESID sesid, JET_TABLEID tableid, byte bookmark, int bookmarkSize, int &actualBookmarkSize ) : void
sesid JET_SESID The session which started the update.
tableid JET_TABLEID The cursor to update. An update should be prepared.
bookmark byte Returns the bookmark of the updated record. This can be null.
bookmarkSize int The size of the bookmark buffer.
actualBookmarkSize int Returns the actual size of the bookmark.
Результат void

MakeKey() публичный статический Метод

Constructs a search key that may then be used by JetSeek and JetSetIndexRange.
public static MakeKey ( JET_SESID sesid, JET_TABLEID tableid, DateTime data, MakeKeyGrbit grbit ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to create the key on.
data DateTime Column data for the current key column of the current index.
grbit MakeKeyGrbit Key options.
Результат void

MakeKey() публичный статический Метод

Constructs a search key that may then be used by JetSeek and JetSetIndexRange.
public static MakeKey ( JET_SESID sesid, JET_TABLEID tableid, Guid data, MakeKeyGrbit grbit ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to create the key on.
data Guid Column data for the current key column of the current index.
grbit MakeKeyGrbit Key options.
Результат void

MakeKey() публичный статический Метод

Constructs a search key that may then be used by JetSeek and JetSetIndexRange.
public static MakeKey ( JET_SESID sesid, JET_TABLEID tableid, bool data, MakeKeyGrbit grbit ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to create the key on.
data bool Column data for the current key column of the current index.
grbit MakeKeyGrbit Key options.
Результат void

MakeKey() публичный статический Метод

Constructs a search key that may then be used by JetSeek and JetSetIndexRange.
public static MakeKey ( JET_SESID sesid, JET_TABLEID tableid, byte data, MakeKeyGrbit grbit ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to create the key on.
data byte Column data for the current key column of the current index.
grbit MakeKeyGrbit Key options.
Результат void

MakeKey() публичный статический Метод

Constructs a search key that may then be used by JetSeek and JetSetIndexRange.
public static MakeKey ( JET_SESID sesid, JET_TABLEID tableid, double data, MakeKeyGrbit grbit ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to create the key on.
data double Column data for the current key column of the current index.
grbit MakeKeyGrbit Key options.
Результат void

MakeKey() публичный статический Метод

Constructs a search key that may then be used by JetSeek and JetSetIndexRange.
public static MakeKey ( JET_SESID sesid, JET_TABLEID tableid, float data, MakeKeyGrbit grbit ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to create the key on.
data float Column data for the current key column of the current index.
grbit MakeKeyGrbit Key options.
Результат void

MakeKey() публичный статический Метод

Constructs a search key that may then be used by JetSeek and JetSetIndexRange.
public static MakeKey ( JET_SESID sesid, JET_TABLEID tableid, int data, MakeKeyGrbit grbit ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to create the key on.
data int Column data for the current key column of the current index.
grbit MakeKeyGrbit Key options.
Результат void

MakeKey() публичный статический Метод

Constructs a search key that may then be used by JetSeek and JetSetIndexRange.
public static MakeKey ( JET_SESID sesid, JET_TABLEID tableid, long data, MakeKeyGrbit grbit ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to create the key on.
data long Column data for the current key column of the current index.
grbit MakeKeyGrbit Key options.
Результат void

MakeKey() публичный статический Метод

Constructs a search key that may then be used by JetSeek and JetSetIndexRange.
public static MakeKey ( JET_SESID sesid, JET_TABLEID tableid, short data, MakeKeyGrbit grbit ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to create the key on.
data short Column data for the current key column of the current index.
grbit MakeKeyGrbit Key options.
Результат void

MakeKey() публичный статический Метод

Constructs a search key that may then be used by JetSeek and JetSetIndexRange.
public static MakeKey ( JET_SESID sesid, JET_TABLEID tableid, string data, Encoding encoding, MakeKeyGrbit grbit ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to create the key on.
data string Column data for the current key column of the current index.
encoding Encoding The encoding used to convert the string.
grbit MakeKeyGrbit Key options.
Результат void

SerializeObjectToColumn() публичный статический Метод

Write a serialized form of an object to a column.
public static SerializeObjectToColumn ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, object value ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The table to write to. An update should be prepared.
columnid JET_COLUMNID The column to write to.
value object The object to write. The object must be serializable.
Результат void

SetColumn() публичный статический Метод

Modifies a single column value in a modified record to be inserted or to update the current record.
public static SetColumn ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, DateTime data ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to update. An update should be prepared.
columnid JET_COLUMNID The columnid to set.
data DateTime The data to set.
Результат void

SetColumn() публичный статический Метод

Modifies a single column value in a modified record to be inserted or to update the current record.
public static SetColumn ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, Guid data ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to update. An update should be prepared.
columnid JET_COLUMNID The columnid to set.
data Guid The data to set.
Результат void

SetColumn() публичный статический Метод

Modifies a single column value in a modified record to be inserted or to update the current record.
public static SetColumn ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, bool data ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to update. An update should be prepared.
columnid JET_COLUMNID The columnid to set.
data bool The data to set.
Результат void

SetColumn() публичный статический Метод

Modifies a single column value in a modified record to be inserted or to update the current record.
public static SetColumn ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, byte data ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to update. An update should be prepared.
columnid JET_COLUMNID The columnid to set.
data byte The data to set.
Результат void

SetColumn() публичный статический Метод

Modifies a single column value in a modified record to be inserted or to update the current record.
public static SetColumn ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, double data ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to update. An update should be prepared.
columnid JET_COLUMNID The columnid to set.
data double The data to set.
Результат void

SetColumn() публичный статический Метод

Modifies a single column value in a modified record to be inserted or to update the current record.
public static SetColumn ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, float data ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to update. An update should be prepared.
columnid JET_COLUMNID The columnid to set.
data float The data to set.
Результат void

SetColumn() публичный статический Метод

Modifies a single column value in a modified record to be inserted or to update the current record.
public static SetColumn ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, int data ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to update. An update should be prepared.
columnid JET_COLUMNID The columnid to set.
data int The data to set.
Результат void

SetColumn() публичный статический Метод

Modifies a single column value in a modified record to be inserted or to update the current record.
public static SetColumn ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, long data ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to update. An update should be prepared.
columnid JET_COLUMNID The columnid to set.
data long The data to set.
Результат void

SetColumn() публичный статический Метод

Modifies a single column value in a modified record to be inserted or to update the current record.
public static SetColumn ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, short data ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to update. An update should be prepared.
columnid JET_COLUMNID The columnid to set.
data short The data to set.
Результат void

SetColumn() публичный статический Метод

Modifies a single column value in a modified record to be inserted or to update the current record.
public static SetColumn ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, string data, Encoding encoding ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to update. An update should be prepared.
columnid JET_COLUMNID The columnid to set.
data string The data to set.
encoding Encoding The encoding used to convert the string.
Результат void

SetColumn() публичный статический Метод

Modifies a single column value in a modified record to be inserted or to update the current record.
public static SetColumn ( JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, string data, Encoding encoding, SetColumnGrbit grbit ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to update. An update should be prepared.
columnid JET_COLUMNID The columnid to set.
data string The data to set.
encoding Encoding The encoding used to convert the string.
grbit SetColumnGrbit SetColumn options.
Результат void

SetColumns() публичный статический Метод

Sets columns from ColumnValue objects.
public static SetColumns ( JET_SESID sesid, JET_TABLEID tableid ) : void
sesid JET_SESID The session to use.
tableid JET_TABLEID The cursor to update. An update should be prepared.
Результат void