Class DataParameter

Inheritance
System.Object
DataParameter
Namespace: LinqToDB.Data
Assembly: linq2db.dll
Syntax
public class DataParameter : object

Constructors

| Improve this Doc View Source

DataParameter()

Declaration
public DataParameter()
| Improve this Doc View Source

DataParameter(Nullable<String>, Nullable<Object>)

Declaration
public DataParameter(string? name, object? value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Nullable<System.Object> value
| Improve this Doc View Source

DataParameter(Nullable<String>, Nullable<Object>, DataType)

Declaration
public DataParameter(string? name, object? value, DataType dataType)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Nullable<System.Object> value
DataType dataType
| Improve this Doc View Source

DataParameter(Nullable<String>, Nullable<Object>, DataType, Nullable<String>)

Declaration
public DataParameter(string? name, object? value, DataType dataType, string? dbType)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Nullable<System.Object> value
DataType dataType
System.Nullable<System.String> dbType
| Improve this Doc View Source

DataParameter(Nullable<String>, Nullable<Object>, String)

Declaration
public DataParameter(string? name, object? value, string dbType)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Nullable<System.Object> value
System.String dbType

Properties

| Improve this Doc View Source

DataType

Gets or sets the DataType of the parameter.

Declaration
public DataType DataType { get; set; }
Property Value
Type Description
DataType

One of the DataType values. The default is Undefined.
| Improve this Doc View Source

DbType

Gets or sets Database Type name of the parameter.

Declaration
public string? DbType { get; set; }
Property Value
Type Description
System.Nullable<System.String>

Name of Database Type or empty string.
| Improve this Doc View Source

Direction

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

Declaration
public ParameterDirection? Direction { get; set; }
Property Value
Type Description
System.Nullable<ParameterDirection>

One of the values. The default is Input.
| Improve this Doc View Source

IsArray

Declaration
public bool IsArray { get; set; }
Property Value
Type Description
System.Boolean
| Improve this Doc View Source

Name

Gets or sets the name of the DataParameter.

Declaration
public string? Name { get; set; }
Property Value
Type Description
System.Nullable<System.String>

The name of the DataParameter. The default is an empty string.
| Improve this Doc View Source

Output

Provider's parameter instance for out, in-out, return parameters. Could be used to read parameter value for complex types like Oracle's BFile.

Declaration
public DbParameter? Output { get; }
Property Value
Type Description
System.Nullable<DbParameter>
| Improve this Doc View Source

Precision

Gets or sets precision for parameter type.

Declaration
public int? Precision { get; set; }
Property Value
Type Description
System.Nullable<System.Int32>
| Improve this Doc View Source

Scale

Gets or sets scale for parameter type.

Declaration
public int? Scale { get; set; }
Property Value
Type Description
System.Nullable<System.Int32>
| Improve this Doc View Source

Size

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

Declaration
public int? Size { get; set; }
Property Value
Type Description
System.Nullable<System.Int32>

The maximum size, in bytes, of the data within the column. The default value is inferred from the parameter value.
| Improve this Doc View Source

Value

Gets or sets the value of the parameter.

Declaration
public object? Value { get; set; }
Property Value
Type Description
System.Nullable<System.Object>

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

Methods

| Improve this Doc View Source

Binary(Nullable<String>, Byte[])

Declaration
public static DataParameter Binary(string? name, byte[] value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Byte[] value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Binary(Nullable<String>, Nullable<Binary>)

Declaration
public static DataParameter Binary(string? name, Binary? value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Nullable<Binary> value
Returns
Type Description
DataParameter
| Improve this Doc View Source

BinaryJson(Nullable<String>, Nullable<String>)

Declaration
public static DataParameter BinaryJson(string? name, string? value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Nullable<System.String> value
Returns
Type Description
DataParameter
| Improve this Doc View Source

BitArray(Nullable<String>, Nullable<BitArray>)

Declaration
public static DataParameter BitArray(string? name, BitArray? value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Nullable<BitArray> value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Blob(Nullable<String>, Byte[])

Declaration
public static DataParameter Blob(string? name, byte[] value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Byte[] value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Boolean(Nullable<String>, Boolean)

Declaration
public static DataParameter Boolean(string? name, bool value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Boolean value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Byte(Nullable<String>, Byte)

Declaration
public static DataParameter Byte(string? name, byte value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Byte value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Char(Nullable<String>, Char)

Declaration
public static DataParameter Char(string? name, char value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Char value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Char(Nullable<String>, Nullable<String>)

Declaration
public static DataParameter Char(string? name, string? value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Nullable<System.String> value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Create(Nullable<String>, DateTime)

Declaration
public static DataParameter Create(string? name, DateTime value)
Parameters
Type Name Description
System.Nullable<System.String> name
DateTime value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Create(Nullable<String>, DateTimeOffset)

Declaration
public static DataParameter Create(string? name, DateTimeOffset value)
Parameters
Type Name Description
System.Nullable<System.String> name
DateTimeOffset value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Create(Nullable<String>, Guid)

Declaration
public static DataParameter Create(string? name, Guid value)
Parameters
Type Name Description
System.Nullable<System.String> name
Guid value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Create(Nullable<String>, Boolean)

Declaration
public static DataParameter Create(string? name, bool value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Boolean value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Create(Nullable<String>, Byte)

Declaration
public static DataParameter Create(string? name, byte value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Byte value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Create(Nullable<String>, Byte[])

Declaration
public static DataParameter Create(string? name, byte[] value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Byte[] value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Create(Nullable<String>, Char)

Declaration
public static DataParameter Create(string? name, char value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Char value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Create(Nullable<String>, Decimal)

Declaration
public static DataParameter Create(string? name, decimal value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Decimal value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Create(Nullable<String>, Double)

Declaration
public static DataParameter Create(string? name, double value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Double value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Create(Nullable<String>, Int16)

Declaration
public static DataParameter Create(string? name, short value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Int16 value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Create(Nullable<String>, Int32)

Declaration
public static DataParameter Create(string? name, int value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Int32 value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Create(Nullable<String>, Int64)

Declaration
public static DataParameter Create(string? name, long value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Int64 value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Create(Nullable<String>, Nullable<Binary>)

Declaration
public static DataParameter Create(string? name, Binary? value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Nullable<Binary> value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Create(Nullable<String>, Nullable<BitArray>)

Declaration
public static DataParameter Create(string? name, BitArray? value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Nullable<BitArray> value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Create(Nullable<String>, Nullable<Dictionary<String, String>>)

Declaration
public static DataParameter Create(string? name, Dictionary<string, string>? value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Nullable<Dictionary<System.String, System.String>> value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Create(Nullable<String>, Nullable<String>)

Declaration
public static DataParameter Create(string? name, string? value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Nullable<System.String> value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Create(Nullable<String>, Nullable<XDocument>)

Declaration
public static DataParameter Create(string? name, XDocument? value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Nullable<XDocument> value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Create(Nullable<String>, Nullable<XmlDocument>)

Declaration
public static DataParameter Create(string? name, XmlDocument? value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Nullable<XmlDocument> value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Create(Nullable<String>, SByte)

Declaration
public static DataParameter Create(string? name, sbyte value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.SByte value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Create(Nullable<String>, Single)

Declaration
public static DataParameter Create(string? name, float value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Single value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Create(Nullable<String>, UInt16)

Declaration
public static DataParameter Create(string? name, ushort value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.UInt16 value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Create(Nullable<String>, UInt32)

Declaration
public static DataParameter Create(string? name, uint value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.UInt32 value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Create(Nullable<String>, UInt64)

Declaration
public static DataParameter Create(string? name, ulong value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.UInt64 value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Create(Nullable<String>, TimeSpan)

Declaration
public static DataParameter Create(string? name, TimeSpan value)
Parameters
Type Name Description
System.Nullable<System.String> name
TimeSpan value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Date(Nullable<String>, DateTime)

Declaration
public static DataParameter Date(string? name, DateTime value)
Parameters
Type Name Description
System.Nullable<System.String> name
DateTime value
Returns
Type Description
DataParameter
| Improve this Doc View Source

DateTime(Nullable<String>, DateTime)

Declaration
public static DataParameter DateTime(string? name, DateTime value)
Parameters
Type Name Description
System.Nullable<System.String> name
DateTime value
Returns
Type Description
DataParameter
| Improve this Doc View Source

DateTime2(Nullable<String>, DateTime)

Declaration
public static DataParameter DateTime2(string? name, DateTime value)
Parameters
Type Name Description
System.Nullable<System.String> name
DateTime value
Returns
Type Description
DataParameter
| Improve this Doc View Source

DateTimeOffset(Nullable<String>, DateTimeOffset)

Declaration
public static DataParameter DateTimeOffset(string? name, DateTimeOffset value)
Parameters
Type Name Description
System.Nullable<System.String> name
DateTimeOffset value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Decimal(Nullable<String>, Decimal)

Declaration
public static DataParameter Decimal(string? name, decimal value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Decimal value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Dictionary(Nullable<String>, Nullable<IDictionary>)

Declaration
public static DataParameter Dictionary(string? name, IDictionary? value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Nullable<IDictionary> value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Double(Nullable<String>, Double)

Declaration
public static DataParameter Double(string? name, double value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Double value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Guid(Nullable<String>, Guid)

Declaration
public static DataParameter Guid(string? name, Guid value)
Parameters
Type Name Description
System.Nullable<System.String> name
Guid value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Image(Nullable<String>, Byte[])

Declaration
public static DataParameter Image(string? name, byte[] value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Byte[] value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Int16(Nullable<String>, Int16)

Declaration
public static DataParameter Int16(string? name, short value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Int16 value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Int32(Nullable<String>, Int32)

Declaration
public static DataParameter Int32(string? name, int value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Int32 value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Int64(Nullable<String>, Int64)

Declaration
public static DataParameter Int64(string? name, long value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Int64 value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Json(Nullable<String>, Nullable<String>)

Declaration
public static DataParameter Json(string? name, string? value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Nullable<System.String> value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Money(Nullable<String>, Decimal)

Declaration
public static DataParameter Money(string? name, decimal value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Decimal value
Returns
Type Description
DataParameter
| Improve this Doc View Source

NChar(Nullable<String>, Char)

Declaration
public static DataParameter NChar(string? name, char value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Char value
Returns
Type Description
DataParameter
| Improve this Doc View Source

NChar(Nullable<String>, Nullable<String>)

Declaration
public static DataParameter NChar(string? name, string? value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Nullable<System.String> value
Returns
Type Description
DataParameter
| Improve this Doc View Source

NText(Nullable<String>, Nullable<String>)

Declaration
public static DataParameter NText(string? name, string? value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Nullable<System.String> value
Returns
Type Description
DataParameter
| Improve this Doc View Source

NVarChar(Nullable<String>, Char)

Declaration
public static DataParameter NVarChar(string? name, char value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Char value
Returns
Type Description
DataParameter
| Improve this Doc View Source

NVarChar(Nullable<String>, Nullable<String>)

Declaration
public static DataParameter NVarChar(string? name, string? value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Nullable<System.String> value
Returns
Type Description
DataParameter
| Improve this Doc View Source

SByte(Nullable<String>, SByte)

Declaration
public static DataParameter SByte(string? name, sbyte value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.SByte value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Single(Nullable<String>, Single)

Declaration
public static DataParameter Single(string? name, float value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Single value
Returns
Type Description
DataParameter
| Improve this Doc View Source

SmallDateTime(Nullable<String>, DateTime)

Declaration
public static DataParameter SmallDateTime(string? name, DateTime value)
Parameters
Type Name Description
System.Nullable<System.String> name
DateTime value
Returns
Type Description
DataParameter
| Improve this Doc View Source

SmallMoney(Nullable<String>, Decimal)

Declaration
public static DataParameter SmallMoney(string? name, decimal value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Decimal value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Text(Nullable<String>, Nullable<String>)

Declaration
public static DataParameter Text(string? name, string? value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Nullable<System.String> value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Time(Nullable<String>, TimeSpan)

Declaration
public static DataParameter Time(string? name, TimeSpan value)
Parameters
Type Name Description
System.Nullable<System.String> name
TimeSpan value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Timestamp(Nullable<String>, Byte[])

Declaration
public static DataParameter Timestamp(string? name, byte[] value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Byte[] value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Udt(Nullable<String>, Nullable<Object>)

Declaration
public static DataParameter Udt(string? name, object? value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Nullable<System.Object> value
Returns
Type Description
DataParameter
| Improve this Doc View Source

UInt16(Nullable<String>, UInt16)

Declaration
public static DataParameter UInt16(string? name, ushort value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.UInt16 value
Returns
Type Description
DataParameter
| Improve this Doc View Source

UInt32(Nullable<String>, UInt32)

Declaration
public static DataParameter UInt32(string? name, uint value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.UInt32 value
Returns
Type Description
DataParameter
| Improve this Doc View Source

UInt64(Nullable<String>, UInt64)

Declaration
public static DataParameter UInt64(string? name, ulong value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.UInt64 value
Returns
Type Description
DataParameter
| Improve this Doc View Source

VarBinary(Nullable<String>, Byte[])

Declaration
public static DataParameter VarBinary(string? name, byte[] value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Byte[] value
Returns
Type Description
DataParameter
| Improve this Doc View Source

VarBinary(Nullable<String>, Nullable<Binary>)

Declaration
public static DataParameter VarBinary(string? name, Binary? value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Nullable<Binary> value
Returns
Type Description
DataParameter
| Improve this Doc View Source

VarChar(Nullable<String>, Char)

Declaration
public static DataParameter VarChar(string? name, char value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Char value
Returns
Type Description
DataParameter
| Improve this Doc View Source

VarChar(Nullable<String>, Nullable<String>)

Declaration
public static DataParameter VarChar(string? name, string? value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Nullable<System.String> value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Variant(Nullable<String>, Nullable<Object>)

Declaration
public static DataParameter Variant(string? name, object? value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Nullable<System.Object> value
Returns
Type Description
DataParameter
| Improve this Doc View Source

VarNumeric(Nullable<String>, Decimal)

Declaration
public static DataParameter VarNumeric(string? name, decimal value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Decimal value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Xml(Nullable<String>, Nullable<String>)

Declaration
public static DataParameter Xml(string? name, string? value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Nullable<System.String> value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Xml(Nullable<String>, Nullable<XDocument>)

Declaration
public static DataParameter Xml(string? name, XDocument? value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Nullable<XDocument> value
Returns
Type Description
DataParameter
| Improve this Doc View Source

Xml(Nullable<String>, Nullable<XmlDocument>)

Declaration
public static DataParameter Xml(string? name, XmlDocument? value)
Parameters
Type Name Description
System.Nullable<System.String> name
System.Nullable<XmlDocument> value
Returns
Type Description
DataParameter

Extension Methods