SqlParameter Properties

SqlParameter Properties

 

Namespace:   System.Data.SqlClient
Assembly:  System.Data (in System.Data.dll)

NameDescription
System_CAPS_pubpropertyCompareInfo

Gets or sets the CompareInfo object that defines how string comparisons should be performed for this parameter.

System_CAPS_pubpropertyDbType

Gets or sets the SqlDbType of the parameter.(Overrides DbParameter.DbType.)

System_CAPS_pubpropertyDirection

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.)

System_CAPS_pubpropertyForceColumnEncryption

Enforces encryption of a parameter when using Always Encrypted. If SQL Server informs the driver that the parameter does not need to be encrypted, the query using the parameter will fail. This property provides additional protection against security attacks that involve a compromised SQL Server providing incorrect encryption metadata to the client, which may lead to data disclosure.

System_CAPS_pubpropertyIsNullable

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.)

System_CAPS_pubpropertyLocaleId

Gets or sets the locale identifier that determines conventions and language for a particular region.

System_CAPS_pubpropertyOffset

Gets or sets the offset to the Value property.

System_CAPS_pubpropertyParameterName

Gets or sets the name of the SqlParameter.(Overrides DbParameter.ParameterName.)

System_CAPS_pubpropertyPrecision

Gets or sets the maximum number of digits used to represent the Value property.

System_CAPS_pubpropertyScale

Gets or sets the number of decimal places to which Value is resolved.

System_CAPS_pubpropertySize

Gets or sets the maximum size, in bytes, of the data within the column.(Overrides DbParameter.Size.)

System_CAPS_pubpropertySourceColumn

Gets or sets the name of the source column mapped to the DataSet and used for loading or returning the Value(Overrides DbParameter.SourceColumn.)

System_CAPS_pubpropertySourceColumnNullMapping

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.)

System_CAPS_pubpropertySourceVersion

Gets or sets the DataRowVersion to use when you load Value(Overrides DbParameter.SourceVersion.)

System_CAPS_pubpropertySqlDbType

Gets or sets the SqlDbType of the parameter.

System_CAPS_pubpropertySqlValue

Gets or sets the value of the parameter as an SQL type.

System_CAPS_pubpropertyTypeName

Gets or sets the type name for a table-valued parameter.

System_CAPS_pubpropertyUdtTypeName

Gets or sets a string that represents a user-defined type as a parameter.

System_CAPS_pubpropertyValue

Gets or sets the value of the parameter.(Overrides DbParameter.Value.)

System_CAPS_pubpropertyXmlSchemaCollectionDatabase

Gets the name of the database where the schema collection for this XML instance is located.

System_CAPS_pubpropertyXmlSchemaCollectionName

Gets the name of the schema collection for this XML instance.

System_CAPS_pubpropertyXmlSchemaCollectionOwningSchema

The owning relational schema where the schema collection for this XML instance is located.

NameDescription
System_CAPS_pubinterfaceSystem_CAPS_privpropertyIDbDataParameter.Precision

Indicates the precision of numeric parameters.(Inherited from DbParameter.)

System_CAPS_pubinterfaceSystem_CAPS_privpropertyIDbDataParameter.Scale

For a description of this member, see IDbDataParameter.Scale.(Inherited from DbParameter.)

Return to top
Show:
© 2016 Microsoft