Does SqlCommandParameter need SqlType to be set as SqlImage if value is bigger then 8KB?

Question

Long time back in past I had read somewhere that if we want to enter data in "image" typed field of table whose value is more then 8kb, then we must explicitly specify parameter type to SqlImage. Is this true? I don't find any such documentation about it anymore.

I tried to use Reflector to reverse engineer the SqlClient in order to see if it's required or not, but I didn't get any hint about it. If anyone can give me any confirmed statement that it's not necessary it will be of great help.

I am using SQL 2008 and I am using Image data type not varbinary or binary.

Answer 1

What version of SQL Server are you working with?

Image is a soon to be deprecated data type. Use varbinary(max) instead.

From SQL Server Books Online:

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use varchar(max), nvarchar(max) and varbinary(max) data types instead. For more information, see Using Large-Value Data Types.