ToSqlParameter

ToSqlParameter

Docs
API
- CA.Blocks.SQLServerDataAccess
  - CA.Blocks.SQLServerDataAccess
    - CA.Blocks.SQLServerDataAccess.SqlServerParameterExtensions
      - WithParameters
      - WithParameter
      - WithReturnResult
      - GetReturnResult
      - AsOutput
      - AsInputOutput
      - ToValue
      - ToValueWithConvert
      - ToSqlParameter

ToSqlParameter Method

Class :CA.Blocks.SQLServerDataAccess.SqlServerParameterExtensions

Namespace :CA.Blocks.SQLServerDataAccess

Assembly : CA.Blocks.SQLServerDataAccess.dll

Overloads


	ToSqlParameter(System.Int64,System.String)
	ToSqlParameter(System.Nullable{System.Int64},System.String)
	ToSqlParameter(System.Byte[],System.String)
	ToSqlParameter(System.Boolean,System.String)
	ToSqlParameter(System.Nullable{System.Boolean},System.String)
	ToSqlParameter(System.Char,System.String,CA.Blocks.SQLServerDataAccess.SpecificSQLCharType)
	ToSqlParameter(System.Nullable{System.Char},System.String,CA.Blocks.SQLServerDataAccess.SpecificSQLCharType)
	ToSqlParameter(System.DateTime,System.String,CA.Blocks.SQLServerDataAccess.SpecificSQLDateTimeType)
	ToSqlParameter(System.Nullable{System.DateTime},System.String,CA.Blocks.SQLServerDataAccess.SpecificSQLDateTimeType)
	ToSqlParameter(System.Decimal,System.String,CA.Blocks.SQLServerDataAccess.SpecificSQLDecimalType)
	ToSqlParameter(System.Nullable{System.Decimal},System.String,CA.Blocks.SQLServerDataAccess.SpecificSQLDecimalType)
	ToSqlParameter(System.Double,System.String)
	ToSqlParameter(System.Nullable{System.Double},System.String)
	ToSqlParameter(System.Int32,System.String)
	ToSqlParameter(System.Nullable{System.Int32},System.String)
	ToSqlParameter(System.Int16,System.String)
	ToSqlParameter(System.Nullable{System.Int16},System.String)
	ToSqlParameter(System.TimeSpan,System.String)
	ToSqlParameter(System.Nullable{System.TimeSpan},System.String)
	ToSqlParameter(System.Byte,System.String)
	ToSqlParameter(System.Nullable{System.Byte},System.String)
	ToSqlParameter(System.Guid,System.String)
	ToSqlParameter(System.Nullable{System.Guid},System.String)
	ToSqlParameter(System.String,System.String,CA.Blocks.SQLServerDataAccess.SpecificSQLStringType,System.Boolean,System.Int32)

ToSqlParameter(System.Int64,System.String)

Parameters

Name	Type		Description
input	System.Int64
strParameterName	System.String

Returns

System.Data.SqlClient.SqlParameter

ToSqlParameter(System.Nullable{System.Int64},System.String)

Parameters

Name	Type		Description
input	System.Nullable{System.Int64}
strParameterName	System.String

Returns

System.Data.SqlClient.SqlParameter

ToSqlParameter(System.Byte[],System.String)

Parameters

Name	Type		Description
input	System.Byte[]
strParameterName	System.String

Returns

System.Data.SqlClient.SqlParameter

ToSqlParameter(System.Boolean,System.String)

Parameters

Name	Type		Description
input	System.Boolean
strParameterName	System.String

Returns

System.Data.SqlClient.SqlParameter

ToSqlParameter(System.Nullable{System.Boolean},System.String)

Parameters

Name	Type		Description
input	System.Nullable{System.Boolean}
strParameterName	System.String

Returns

System.Data.SqlClient.SqlParameter

ToSqlParameter(System.Char,System.String,CA.Blocks.SQLServerDataAccess.SpecificSQLCharType)

Parameters

Name	Type		Description
input	System.Char
strParameterName	System.String
dbType	CA.Blocks.SQLServerDataAccess.SpecificSQLCharType	Optional

Returns

System.Data.SqlClient.SqlParameter

ToSqlParameter(System.Nullable{System.Char},System.String,CA.Blocks.SQLServerDataAccess.SpecificSQLCharType)

Parameters

Name	Type		Description
input	System.Nullable{System.Char}
strParameterName	System.String
dbType	CA.Blocks.SQLServerDataAccess.SpecificSQLCharType	Optional

Returns

System.Data.SqlClient.SqlParameter

ToSqlParameter(System.DateTime,System.String,CA.Blocks.SQLServerDataAccess.SpecificSQLDateTimeType)

Parameters

Name	Type		Description
input	System.DateTime
strParameterName	System.String
dbType	CA.Blocks.SQLServerDataAccess.SpecificSQLDateTimeType	Optional

Returns

System.Data.SqlClient.SqlParameter

ToSqlParameter(System.Nullable{System.DateTime},System.String,CA.Blocks.SQLServerDataAccess.SpecificSQLDateTimeType)

Parameters

Name	Type		Description
input	System.Nullable{System.DateTime}
strParameterName	System.String
dbType	CA.Blocks.SQLServerDataAccess.SpecificSQLDateTimeType	Optional

Returns

System.Data.SqlClient.SqlParameter

ToSqlParameter(System.Decimal,System.String,CA.Blocks.SQLServerDataAccess.SpecificSQLDecimalType)

Parameters

Name	Type		Description
input	System.Decimal
strParameterName	System.String
dbType	CA.Blocks.SQLServerDataAccess.SpecificSQLDecimalType	Optional

Returns

System.Data.SqlClient.SqlParameter

ToSqlParameter(System.Nullable{System.Decimal},System.String,CA.Blocks.SQLServerDataAccess.SpecificSQLDecimalType)

Parameters

Name	Type		Description
input	System.Nullable{System.Decimal}
strParameterName	System.String
dbType	CA.Blocks.SQLServerDataAccess.SpecificSQLDecimalType	Optional

Returns

System.Data.SqlClient.SqlParameter

ToSqlParameter(System.Double,System.String)

Parameters

Name	Type		Description
input	System.Double
strParameterName	System.String

Returns

System.Data.SqlClient.SqlParameter

ToSqlParameter(System.Nullable{System.Double},System.String)

Parameters

Name	Type		Description
input	System.Nullable{System.Double}
strParameterName	System.String

Returns

System.Data.SqlClient.SqlParameter

ToSqlParameter(System.Int32,System.String)

Parameters

Name	Type		Description
input	System.Int32
strParameterName	System.String

Returns

System.Data.SqlClient.SqlParameter

ToSqlParameter(System.Nullable{System.Int32},System.String)

Parameters

Name	Type		Description
input	System.Nullable{System.Int32}
strParameterName	System.String

Returns

System.Data.SqlClient.SqlParameter

ToSqlParameter(System.Int16,System.String)

Parameters

Name	Type		Description
input	System.Int16
strParameterName	System.String

Returns

System.Data.SqlClient.SqlParameter

ToSqlParameter(System.Nullable{System.Int16},System.String)

Parameters

Name	Type		Description
input	System.Nullable{System.Int16}
strParameterName	System.String

Returns

System.Data.SqlClient.SqlParameter

ToSqlParameter(System.TimeSpan,System.String)

Parameters

Name	Type		Description
input	System.TimeSpan
strParameterName	System.String

Returns

System.Data.SqlClient.SqlParameter

ToSqlParameter(System.Nullable{System.TimeSpan},System.String)

Parameters

Name	Type		Description
input	System.Nullable{System.TimeSpan}
strParameterName	System.String

Returns

System.Data.SqlClient.SqlParameter

ToSqlParameter(System.Byte,System.String)

Parameters

Name	Type		Description
input	System.Byte
strParameterName	System.String

Returns

System.Data.SqlClient.SqlParameter

ToSqlParameter(System.Nullable{System.Byte},System.String)

Parameters

Name	Type		Description
input	System.Nullable{System.Byte}
strParameterName	System.String

Returns

System.Data.SqlClient.SqlParameter

ToSqlParameter(System.Guid,System.String)

Parameters

Name	Type		Description
input	System.Guid
strParameterName	System.String

Returns

System.Data.SqlClient.SqlParameter

ToSqlParameter(System.Nullable{System.Guid},System.String)

Parameters

Name	Type		Description
input	System.Nullable{System.Guid}
strParameterName	System.String

Returns

System.Data.SqlClient.SqlParameter

ToSqlParameter(System.String,System.String,CA.Blocks.SQLServerDataAccess.SpecificSQLStringType,System.Boolean,System.Int32)

Parameters

Name	Type		Description
input	System.String
strParameterName	System.String
dbType	CA.Blocks.SQLServerDataAccess.SpecificSQLStringType	Optional
useEmptyStringForNull	System.Boolean	Optional
trimInputTo	System.Int32	Optional

Returns

System.Data.SqlClient.SqlParameter