Jim,
I'm assuming that you tried this and it didn't work? Or were you just asking based on the fact that Intellisense says it's only for binary data between 1 and 8000 bytes? The documentation implies (or rather, I *infer* from the documentation), that it should be ok. Here's what it says:
A variable-length stream of binary data ranging between 1 and 8,000 bytes.
ADO.NET cannot correctly infer the type if the byte array is larger than 8,000 bytes. Explicitly specify the DbType when working with byte arrays larger than 8,000 bytes.~~Bonnie
>All,
>
> I have a field in a table called attachment of VarBinary(Max) type. From a C# program that uses enterprise library, I am adding an in Parameter. The AddInParameter requires a data type parameter(dbType). What should I use to pass the attachment parameter? The length is usually more than 8,000. I've included my code below. Please help.
>
>
> DbCommand command = database.GetStoredProcCommand(spName);
> database.AddOutParameter(command, "@MessageDeliveryDocumentId", DbType.Int32, 0);
> database.AddInParameter(command, "@MessageDeliveryId", DbType.Int32, messageDeliveryId);
> database.AddInParameter(command, "@Attachment", DbType.Binary, attachment);
> database.AddInParameter(command, "@FileName", DbType.String, fileName);
> database.AddInParameter(command, "@FileType", DbType.String, fileType);
>