Class DataParameter
Inheritance
System.Object
DataParameter
Assembly: linq2db.dll
Syntax
public class DataParameter : object
Constructors
|
Improve this Doc
View Source
DataParameter()
Declaration
|
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
|
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
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
Extension Methods