Mallard
Search Results for

    Show / Hide Table of Contents

    Struct DuckDbStatement.Parameter

    A formal parameter in a prepared statement from DuckDB.

    Implements
    ISettableDuckDbValue
    Inherited Members
    ValueType.Equals(object)
    ValueType.GetHashCode()
    ValueType.ToString()
    object.Equals(object, object)
    object.GetType()
    object.ReferenceEquals(object, object)
    Namespace: Mallard
    Assembly: Mallard.dll
    Syntax
    public readonly struct DuckDbStatement.Parameter : ISettableDuckDbValue
    Remarks

    The value of the parameter can be set with any of the methods from DuckDbValue.

    Properties

    | Edit this page View Source

    Index

    The index/position of this formal parameter within the prepared statement.

    Declaration
    public int Index { get; }
    Property Value
    Type Description
    int

    Index of the parameter, ranging from 1 to the total number of parameters.

    | Edit this page View Source

    Name

    The name of this formal parameter within the prepared statement.

    Declaration
    public string Name { get; }
    Property Value
    Type Description
    string

    The name of the parameter as a string. For positional parameters in the SQL statement, the name is the decimal representation of the ordinal (in ASCII digits, no leading zeros). Note the returned string is not cached.

    Exceptions
    Type Condition
    ObjectDisposedException

    The containing prepared statement of this parameter has already been disposed. (Retrieving the name requires querying the native prepared statement object from DuckDB.)

    | Edit this page View Source

    ValueKind

    The DuckDB type of this parameter.

    Declaration
    public DuckDbValueKind ValueKind { get; }
    Property Value
    Type Description
    DuckDbValueKind

    The DuckDB type of value that this parameter accepts.

    Exceptions
    Type Condition
    ObjectDisposedException

    The containing prepared statement of this parameter has already been disposed. (This method internally requires querying the native prepared statement object from DuckDB.)

    Implements

    ISettableDuckDbValue

    Extension Methods

    DuckDbValue.SetBitString<TReceiver>(TReceiver, ReadOnlySpan<byte>, int)
    DuckDbValue.SetBlob<TReceiver>(TReceiver, ReadOnlySpan<byte>)
    DuckDbValue.SetGeneric<TReceiver, TInput>(TReceiver, TInput)
    DuckDbValue.SetNull<TReceiver>(TReceiver)
    DuckDbValue.SetObject<TReceiver>(TReceiver, object?)
    DuckDbValue.SetStringUtf16<TReceiver>(TReceiver, ReadOnlySpan<char>)
    DuckDbValue.SetStringUtf8<TReceiver>(TReceiver, ReadOnlySpan<byte>)
    DuckDbValue.Set<TReceiver>(TReceiver, DuckDbDate)
    DuckDbValue.Set<TReceiver>(TReceiver, DuckDbDecimal)
    DuckDbValue.Set<TReceiver>(TReceiver, DuckDbInterval)
    DuckDbValue.Set<TReceiver>(TReceiver, DuckDbTimestamp)
    DuckDbValue.Set<TReceiver>(TReceiver, bool)
    DuckDbValue.Set<TReceiver>(TReceiver, byte)
    DuckDbValue.Set<TReceiver>(TReceiver, BitArray)
    DuckDbValue.Set<TReceiver>(TReceiver, double)
    DuckDbValue.Set<TReceiver>(TReceiver, Int128)
    DuckDbValue.Set<TReceiver>(TReceiver, short)
    DuckDbValue.Set<TReceiver>(TReceiver, int)
    DuckDbValue.Set<TReceiver>(TReceiver, long)
    DuckDbValue.Set<TReceiver>(TReceiver, BigInteger)
    DuckDbValue.Set<TReceiver>(TReceiver, sbyte)
    DuckDbValue.Set<TReceiver>(TReceiver, float)
    DuckDbValue.Set<TReceiver>(TReceiver, string)
    DuckDbValue.Set<TReceiver>(TReceiver, UInt128)
    DuckDbValue.Set<TReceiver>(TReceiver, ushort)
    DuckDbValue.Set<TReceiver>(TReceiver, uint)
    DuckDbValue.Set<TReceiver>(TReceiver, ulong)
    DuckDbValue.TrySetGeneric<TReceiver, TInput>(TReceiver, TInput)
    DuckDbValue.TrySetObject<TReceiver>(TReceiver, object?)
    • Edit this page
    • View Source
    In this article
    Back to top Generated by DocFX