Handling Large Object (LOB) Parameters in the CLR
Collapse the table of content
Expand the table of content

Handling Large Object (LOB) Parameters in the CLR

 

Applies To: SQL Server 2016 Preview

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.

SQL Server Data Types in the .NET Framework

Community Additions

ADD
Show:
© 2016 Microsoft