Class DuckDBParameter

Namespace

DuckDB.NET.Data

Assembly

DuckDB.NET.Data.dll

public class DuckDBParameter : DbParameter, IDbDataParameter, IDataParameter

Inheritance

object

MarshalByRefObject

DbParameter

DuckDBParameter

Implements

IDbDataParameter

IDataParameter

Inherited Members

DbParameter.Precision

DbParameter.Scale

DbParameter.SourceVersion

MarshalByRefObject.GetLifetimeService()

MarshalByRefObject.InitializeLifetimeService()

MarshalByRefObject.MemberwiseClone(bool)

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Constructors

DuckDBParameter()

public DuckDBParameter()

DuckDBParameter(DbType, object?)

public DuckDBParameter(DbType type, object? value)

Parameters

type DbType

value object

DuckDBParameter(object)

public DuckDBParameter(object value)

Parameters

value object

DuckDBParameter(string, DbType, object?)

public DuckDBParameter(string name, DbType type, object? value)

Parameters

name string

type DbType

value object

DuckDBParameter(string, object?)

public DuckDBParameter(string name, object? value)

Parameters

name string

value object

Properties

DbType

Gets or sets the DbType of the parameter.

public override DbType DbType { get; set; }

Property Value

DbType

One of the DbType values. The default is String.

Exceptions

ArgumentException

The property is not set to a valid DbType.

Direction

Gets or sets a value that indicates whether the parameter is input-only, output-only, bidirectional, or a stored procedure return value parameter.

public override ParameterDirection Direction { get; set; }

Property Value

ParameterDirection

One of the ParameterDirection values. The default is Input.

Exceptions

ArgumentException

The property is not set to one of the valid ParameterDirection values.

IsNullable

Gets or sets a value that indicates whether the parameter accepts null values.

public override bool IsNullable { get; set; }

Property Value

bool

true if null values are accepted; otherwise false. The default is false.

ParameterName

Gets or sets the name of the DbParameter.

public override string ParameterName { get; set; }

Property Value

string

The name of the DbParameter. The default is an empty string ("").

Size

Gets or sets the maximum size, in bytes, of the data within the column.

public override int Size { get; set; }

Property Value

int

The maximum size, in bytes, of the data within the column. The default value is inferred from the parameter value.

SourceColumn

Gets or sets the name of the source column mapped to the DataSet and used for loading or returning the Value.

public override string SourceColumn { get; set; }

Property Value

string

The name of the source column mapped to the DataSet. The default is an empty string.

SourceColumnNullMapping

Gets or sets a value which indicates whether the source column is nullable. This allows DbCommandBuilder to correctly generate Update statements for nullable columns.

public override bool SourceColumnNullMapping { get; set; }

Property Value

bool

true if the source column is nullable; false if it is not.

Value

Gets or sets the value of the parameter.

public override object? Value { get; set; }

Property Value

object

An object that is the value of the parameter. The default value is null.

Methods

ResetDbType()

Resets the DbType property to its original settings.

public override void ResetDbType()