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);
Thanks
Jim