This topic has not yet been rated - Rate this topic

Handling Large Object (LOB) Parameters in the CLR

SQL Server 2012

SQL Server 2008 R2
SQL Server 2008
SQL Server 2005

Use SqlBytes and SqlChars to pass large object (LOB) binary type (varbinary(max)) and LOB character type (nvarchar(max)) 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. SqlBinary and SqlString should be used only for small binary and character string values.

Other Resources

SQL Server Data Types in the .NET Framework

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD