dotConnect for SQLite Documentation
Devart.Data.SQLite Namespace / SQLiteAuthorizerHandler Delegate
The action to authorize.
The first argument of the action, or a null reference (Nothing in Visual Basic). Its meaning depends on the action; see SQLiteAuthorizerActionCode.
The second argument of the action, or a null reference (Nothing in Visual Basic). Its meaning depends on the action; see SQLiteAuthorizerActionCode.
The name of the database the action applies to ("main", "temp", or the name of an attached database), or a null reference (Nothing in Visual Basic) if not applicable.
The name of the innermost trigger or view that caused the action, or a null reference (Nothing in Visual Basic) if the action comes directly from the SQL statement.

On this page
    SQLiteAuthorizerHandler Delegate
    On this page
    Represents the method that can be registered as an authorizer to allow, deny, or ignore actions of SQL statements when they are compiled.
    Syntax
    'Declaration
     
    Public Delegate Function SQLiteAuthorizerHandler( _
       ByVal action As SQLiteAuthorizerActionCode, _
       ByVal arg1 As String, _
       ByVal arg2 As String, _
       ByVal dbName As String, _
       ByVal innerMostTriggerOrView As String _
    ) As SQLiteAuthorizerReturnCode
    public delegate SQLiteAuthorizerReturnCode SQLiteAuthorizerHandler( 
       SQLiteAuthorizerActionCode action,
       string arg1,
       string arg2,
       string dbName,
       string innerMostTriggerOrView
    )

    Parameters

    action
    The action to authorize.
    arg1
    The first argument of the action, or a null reference (Nothing in Visual Basic). Its meaning depends on the action; see SQLiteAuthorizerActionCode.
    arg2
    The second argument of the action, or a null reference (Nothing in Visual Basic). Its meaning depends on the action; see SQLiteAuthorizerActionCode.
    dbName
    The name of the database the action applies to ("main", "temp", or the name of an attached database), or a null reference (Nothing in Visual Basic) if not applicable.
    innerMostTriggerOrView
    The name of the innermost trigger or view that caused the action, or a null reference (Nothing in Visual Basic) if the action comes directly from the SQL statement.
    Remarks

    If the handler throws an exception or returns a value that is not defined in SQLiteAuthorizerReturnCode, the statement is rejected with an SQLiteException, and the exception is available in the InnerException property.

    The handler must not do anything that will modify the connection it is registered in. This includes SQL statement preparation and execution, retrieving data, etc.

    Return Value

    Returns one of the SQLiteAuthorizerReturnCode values:

    • Ok – Allows the action.
    • Deny – Rejects the entire statement.
    • Ignore – Skips the action.
    See Also