Class SqlCmdParams
Holds the information about the type and value of the parameters passed to the command.
Inheritance
System.Object
SqlCmdParams
Namespace:
Assembly: Alachisoft.NCache.Runtime.dll
Syntax
public class SqlCmdParams
CompareInfo
Sets the CompareInfo object that defines how string comparisons should be performed for this parameter.
Declaration
public SqlCmpOptions CompareInfo { get; set; }
Property Value
Direction
Sets a value that indicates whether the parameter is input-only, output-only, bidirectional, or a stored procedure return value parameter.
Declaration
public SqlParamDirection Direction { get; set; }
Property Value
IsNullable
Sets a value that indicates whether the parameter accepts null values.
Declaration
public bool IsNullable { get; set; }
Property Value
| Type |
Description |
| System.Boolean |
|
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 |
|
Offset
Sets the offset to the Value property.
Declaration
public int Offset { get; set; }
Property Value
| Type |
Description |
| System.Int32 |
|
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 |
|
Scale
Sets the number of decimal places to which Value is resolved.
Declaration
public byte Scale { get; set; }
Property Value
| Type |
Description |
| System.Byte |
|
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 |
|
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 |
|
SourceColumnNullMapping
Sets a value which indicates whether the source column is nullable. This allows SqlCommandBuilder to correctly generate Update statements for nullable columns.
Declaration
public bool SourceColumnNullMapping { get; set; }
Property Value
| Type |
Description |
| System.Boolean |
|
SourceVersion
Sets the DataRowVersion to use when you load Value
Declaration
public SqlDataRowVersion SourceVersion { get; set; }
Property Value
SqlCmpInfo
Declaration
public SqlCompareOptions SqlCmpInfo { get; }
Property Value
| Type |
Description |
| System.Data.SqlTypes.SqlCompareOptions |
|
SqlParamDir
Declaration
public ParameterDirection SqlParamDir { get; set; }
Property Value
| Type |
Description |
| System.Data.ParameterDirection |
|
SqlParamType
Declaration
public SqlDbType SqlParamType { get; }
Property Value
| Type |
Description |
| System.Data.SqlDbType |
|
SqlValue
Sets the value of the parameter as an SQL type.
Declaration
public object SqlValue { get; set; }
Property Value
| Type |
Description |
| System.Object |
|
SrcVersion
Declaration
public DataRowVersion SrcVersion { get; }
Property Value
| Type |
Description |
| System.Data.DataRowVersion |
|
Type
Sets the SqlDbType of the passed parameter.
Declaration
public CmdParamsType Type { get; set; }
Property Value
TypeName
Sets the type name for a table-valued parameter.
Declaration
public string TypeName { get; set; }
Property Value
| Type |
Description |
| System.String |
|
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 |
|
Value
The value of the passed parameter.
Declaration
public object Value { get; set; }
Property Value
| Type |
Description |
| System.Object |
|