store PDF file in DB as byte

Question

Hi:

    I am using Asp.Net MVC. in my project while uploading PDF file we convert the PDF   file into byte then store it in DB. but i got  the following exception.

" String or binary data would be truncated. The statement has been terminated."

Can any one solve this issue.I got the exception righ here

context.SubmitChanges();

Thanks: Suresh

Answer 1

This is most probably because the code attempted to insert more data/bytes in your database column than its defined size.

Answer 2

Just change the size of your field, try varbinary(MAX).