How to save a file to a field in SQL Server?

Question

I would like to know how to save a file within a SQL Server field com C#. Reading on some forums I realized that there is difference between image and binary files.

The type of file I want to save are Outlook emails. I’m making a system where the records need to have some evidence, and that evidence would be the emails I need to keep.

How do I do that? Thank you!

Answer 1

Using the column type FILESTREAM.

Here is a tutorial on how to configure your SQL Server to use FILESTREAM.

You can create tables with columns of files like this:

CREATE TABLE MinhaTabela
(
    [Id] [int] primary key identity, 
    [Arquivo] VARBINARY(MAX) FILESTREAM NULL
)
GO

Here is a step by step how to open a file and save it in the database.