The C# Database Class Enums

For an overview see page C# Classes

Enum Definitions

    public enum TransactionType
    {
        ReadOnly, Update, ReadWrite, Exclusive
    }

    public enum TransactionPriority
    {
        Idle, Background, Foreground, AboveNormal, Highest
    }

    public enum IsolationLevel
    {
        Default, ReadCommitted, RepeatableRead, Serializable
    }

    public enum LogType
    {
        NoLog, RedoLog, UndoLog
    }

    public enum IndexType
    {
        Hashtable, BTree, Patricia, RTree, RTreeOfPoint, KDTree, Trigram
    }

    public enum EventType
    {
        OnNew, OnFieldUpdate, OnDelete, OnDeleteAll, OnCheckpoint, OnUpdate
    }

    public enum CommitPolicy
    {
        SyncFlush, Buffered, Delayed, NoSync
    }

    public enum TransSchedPolicy
    {
        Fifo, ReaderFavor, WriterFavor
    }

    public enum BackupType {
        Auto, Snapshot, Incremental
    }

Enum Descriptions

TransactionType
Types of transactions.
TransactionPriority
Priority levels for transactions.
IsolationLevel
Transaction isolation levels.
LogType
Types of transaction logs.
IndexType
Index types.
EventType
Database event trigger types used by EventAttribute:
  • OnNew - Triggered when a new object is created.
  • OnFieldUpdate - Triggered when a decorated field or property is updated.
  • OnDelete - Triggered when an object is deleted.
  • OnDeleteAll - Triggered when all objects of a class are deleted.
  • OnCheckpoint - Triggered when a checkpoint-related event occurs.
  • OnUpdate - Triggered when an object is updated.
CommitPolicy
Transaction commit policies (used only for on-disk databases):
  • SyncFlush - Waits until all changes are written to disk (default policy).
  • Buffered - Does not flush changes to disk immediately.
  • Delayed - Defers flushing changes to disk until the amount of modified data or the number of pending transactions exceeds a configured threshold.
  • NoSync - Flushes changes to disk asynchronously.
TransSchedPolicy
Scheduling policy for transactions with the same priority:
  • Fifo - First-in, first-out (fair queuing).
  • ReaderFavor - Prioritizes readers over writers in the queue.
  • WriterFavor - Prioritizes writers over readers in the queue.
BackupType
Types of database backups.