visual studio 2017 how can i store a pdf document in sql server?

[salsa31]

hey,
i know there is a way to store pdf document in sql server i just dont know the method.
i need the customer to download this file from the server.
this file will be stored in a host through api.
is there somebody that did this before?
any help will be appreciated.
salsa 31

[jmcilhinney]

You need to get the file contents as a Byte array and then you save the data to the database in exactly the same way as you do any other data, using a varbinary column. How you get that Byte array depends on exactly what you're starting with. If you have a stream of some sort then you get the binary data out like you would any other stream. If you have a file then you can call File.ReadAllBytes. Etc.

[ChrisE]

to get the file something along the lines

"varFilePath" is for the File you want

 Dim file() As Byte
        Using stream = New FileStream(varFilePath, FileMode.Open, FileAccess.Read)
            Using reader = New BinaryReader(stream)
                file = reader.ReadBytes(CInt(stream.Length))
            End Using
        End Using

now pass "File" to the Database

[jmcilhinney]

to get the file something along the lines

"varFilePath" is for the File you want

 Dim file() As Byte
        Using stream = New FileStream(varFilePath, FileMode.Open, FileAccess.Read)
            Using reader = New BinaryReader(stream)
                file = reader.ReadBytes(CInt(stream.Length))
            End Using
        End Using

now pass "File" to the Database

Why not just call File.ReadAllBytes?