Large object (LOB) parameters

Use and to pass large object (LOB) binary type ( ) and LOB character type ( ) parameters, respectively.

Use

and

to pass large object (LOB) binary type (

) and LOB

character type (

) parameters, respectively. These types allow streaming the LOB

values from the database to the common language runtime (CLR) routine, instead of copying

the entire value into managed space.

and

should be used only for small

binary and character string values.

data types in the.NET Framework

SqlBytes
SqlChars
SqlBinary
SqlString