Symptoms
Is it possible to upload attachments into a sql table using a K2 smartobject based on a sql stored procedure?
Diagnoses
1. K2 will store an attachment (from an attachment control/file property) as an XML structure with the file’s name and Base64 encoded file in the database.
2. As such the following datatype flow will apply:
Database (nvarchar(max) column) <-> Smartobject (File property) <-> Attachment Control
Using a stored procedure to insert this data in the nvarchar(max) column is possible, if the Smartobject Property is of a File type and the Attachment Control is used when passing the attachment to your custom Smartobject Method based of the SQL stored procedure.
Resolution
This can be implented.