SqliteParameter Class

Definition

Namespace:

Microsoft.Data.Sqlite

Assembly:

Microsoft.Data.Sqlite.dll

Package:

Microsoft.Data.Sqlite.Core v7.0.0

Represents a parameter and its value in a SqliteCommand.

public class SqliteParameter : System.Data.Common.DbParameter

type SqliteParameter = class
    inherit DbParameter

Public Class SqliteParameter
Inherits DbParameter

Inheritance

DbParameter

SqliteParameter

Remarks

Due to SQLite's dynamic type system, parameter values are not converted.

Constructors

SqliteParameter()	Initializes a new instance of the SqliteParameter class.
SqliteParameter(String, Object)	Initializes a new instance of the SqliteParameter class.
SqliteParameter(String, SqliteType)	Initializes a new instance of the SqliteParameter class.
SqliteParameter(String, SqliteType, Int32)	Initializes a new instance of the SqliteParameter class.
SqliteParameter(String, SqliteType, Int32, String)	Initializes a new instance of the SqliteParameter class.

Properties

DbType	Gets or sets the type of the parameter.
Direction	Gets or sets the direction of the parameter. Only Input is supported.
IsNullable	Gets or sets a value indicating whether the parameter is nullable.
ParameterName	Gets or sets the name of the parameter.
Size	Gets or sets the maximum size, in bytes, of the parameter.
SourceColumn	Gets or sets the source column used for loading the value.
SourceColumnNullMapping	Gets or sets a value indicating whether the source column is nullable.
SqliteType	Gets or sets the SQLite type of the parameter.
Value	Gets or sets the value of the parameter.

Methods

ResetDbType()	Resets the DbType property to its original value.
ResetSqliteType()	Resets the SqliteType property to its original value.