Class SqlCmdParams

Holds the information about the type and value of the parameters passed to the command.

Inheritance
System.Object
SqlCmdParams
Assembly: Alachisoft.NCache.Runtime.dll
Syntax
public class SqlCmdParams : IBinaryProtocolSerializable

Properties

CompareInfo

Sets the CompareInfo object that defines how string comparisons should be performed for this parameter.

Declaration
public SqlCmpOptions CompareInfo { get; set; }
Property Value
Type Description
Alachisoft.NCache.Runtime.Dependencies.SqlCmpOptions

CompareInfo object of class SqlCmpOptions.

Direction

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

Declaration
public SqlParamDirection Direction { get; set; }
Property Value
Type Description
SqlParamDirection

Direction of parameter.

IsNullable

Sets a value that indicates whether the parameter accepts null values.

Declaration
public bool IsNullable { get; set; }
Property Value
Type Description
System.Boolean

Boolean value, either true or false.

LocaleID

Sets the locale identifier that determines conventions and language for a particular region.

Declaration
public int LocaleID { get; set; }
Property Value
Type Description
System.Int32

Locale identifier that determines conventions and language for a particular region.

Offset

Sets the Offset to the Value property.

Declaration
public int Offset { get; set; }
Property Value
Type Description
System.Int32

Offset to the Value property.

Precision

Sets the maximum number of digits used to represent the Value property.

Declaration
public byte Precision { get; set; }
Property Value
Type Description
System.Byte

Number of digits.

Scale

Sets the number of decimal places to which a value is resolved.

Declaration
public byte Scale { get; set; }
Property Value
Type Description
System.Byte

Number of decimal places.

Size

Sets the maximum size, in bytes, of the data within the column.

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

Size of data within the column.

SourceColumn

Sets the name of the source column mapped to the dataset and used for loading or returning the value.

Declaration
public string SourceColumn { get; set; }
Property Value
Type Description
System.String

Name of source column.

SourceColumnNullMapping

Sets a value which indicates whether the source column is nullable. This allows SqlCommandBuilder to correctly generate and update statements for nullable columns.

Declaration
public bool SourceColumnNullMapping { get; set; }
Property Value
Type Description
System.Boolean

Boolean value, either true or false.

SourceVersion

Sets the DataRowVersion to use when you load value.

Declaration
public SqlDataRowVersion SourceVersion { get; set; }
Property Value
Type Description
SqlDataRowVersion

The DataRowVersion to use when you load value.

SqlCmpInfo

Specifies the SQL compare options.

Declaration
public SqlCompareOptions SqlCmpInfo { get; }
Property Value
Type Description
System.Data.SqlTypes.SqlCompareOptions

SQL compare options.

SqlParamDir

Specifies the parameters direction.

Declaration
public ParameterDirection SqlParamDir { get; set; }
Property Value
Type Description
System.Data.ParameterDirection

Direction of the parameters.

SqlParamType

Specifies the parameter type.

Declaration
public SqlDbType SqlParamType { get; }
Property Value
Type Description
System.Data.SqlDbType

Type of parameter.

SqlValue

Sets the value of the parameter as an SQL type.

Declaration
public object SqlValue { get; set; }
Property Value
Type Description
System.Object

SQL type value of parameter.

SrcVersion

Returns the version of a System.Data.DataRow.

Declaration
public DataRowVersion SrcVersion { get; }
Property Value
Type Description
System.Data.DataRowVersion

Version of a System.Data.DataRow.

TotalSize

Declaration
public int TotalSize { get; }
Property Value
Type Description
System.Int32

Type

Sets the SqlDbType of the passed parameter.

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

The type of parameters passed to the command.

TypeName

Sets the TypeName for a table-valued parameter.

Declaration
public string TypeName { get; set; }
Property Value
Type Description
System.String

Name for a table-valued parameter.

UdtTypeName

Sets a string that represents a user-defined type as a parameter.

Declaration
public string UdtTypeName { get; set; }
Property Value
Type Description
System.String

String that represents a user-defined type as a parameter.

Value

This property gets and sets the value of the passed parameter.

Declaration
public object Value { get; set; }
Property Value
Type Description
System.Object

The value of parameter.

Methods

Deserialize(ref Span<Byte>)

Declaration
public void Deserialize(ref Span<byte> buffer)
Parameters
Type Name Description
Span<System.Byte> buffer

Serialize(ref Span<Byte>)

Declaration
public void Serialize(ref Span<byte> buffer)
Parameters
Type Name Description
Span<System.Byte> buffer