SqlParameter Properties
.NET Framework 4.5
The SqlParameter type exposes the following members.
| Name | Description | |
|---|---|---|
|
CompareInfo | Gets or sets the CompareInfo object that defines how string comparisons should be performed for this parameter. |
|
|
DbType | Gets or sets the SqlDbType of the parameter. (Overrides DbParameter.DbType.) |
|
|
Direction | Gets or sets a value that indicates whether the parameter is input-only, output-only, bidirectional, or a stored procedure return value parameter. (Overrides DbParameter.Direction.) |
|
|
IsNullable | Gets or sets a value that indicates whether the parameter accepts null values. IsNullable is not used to validate the parameter’s value and will not prevent sending or receiving a null value when executing a command. (Overrides DbParameter.IsNullable.) |
|
|
LocaleId | Gets or sets the locale identifier that determines conventions and language for a particular region. |
|
|
Offset | Gets or sets the offset to the Value property. |
|
|
ParameterName | Gets or sets the name of the SqlParameter. (Overrides DbParameter.ParameterName.) |
|
|
Precision | Gets or sets the maximum number of digits used to represent the Value property. |
|
|
Scale | Gets or sets the number of decimal places to which Value is resolved. |
|
|
Size | Gets or sets the maximum size, in bytes, of the data within the column. (Overrides DbParameter.Size.) |
|
|
SourceColumn | Gets or sets the name of the source column mapped to the DataSet and used for loading or returning the Value (Overrides DbParameter.SourceColumn.) |
|
|
SourceColumnNullMapping | Sets or gets a value which indicates whether the source column is nullable. This allows SqlCommandBuilder to correctly generate Update statements for nullable columns. (Overrides DbParameter.SourceColumnNullMapping.) |
|
|
SourceVersion | Gets or sets the DataRowVersion to use when you load Value (Overrides DbParameter.SourceVersion.) |
|
|
SqlDbType | Gets or sets the SqlDbType of the parameter. |
|
|
SqlValue | Gets or sets the value of the parameter as an SQL type. |
|
|
TypeName | Gets or sets the type name for a table-valued parameter. |
|
|
UdtTypeName | Gets or sets a string that represents a user-defined type as a parameter. |
|
|
Value | Gets or sets the value of the parameter. (Overrides DbParameter.Value.) |
|
|
XmlSchemaCollectionDatabase | Gets the name of the database where the schema collection for this XML instance is located. |
|
|
XmlSchemaCollectionName | Gets the name of the schema collection for this XML instance. |
|
|
XmlSchemaCollectionOwningSchema | The owning relational schema where the schema collection for this XML instance is located. |
| Name | Description | |
|---|---|---|
|
IDbDataParameter.Precision | Indicates the precision of numeric parameters. (Inherited from DbParameter.) |
|
|
IDbDataParameter.Scale | For a description of this member, see IDbDataParameter.Scale. (Inherited from DbParameter.) |
