Using FileStream in SQL with code first in ASP.NET Core

Question

I need to create a table and use FileStream in that table. In the SQL Server table, I need to use this column:

CREATE TABLE TestTable
(
    FileID  UNIQUEIDENTIFIER NOT NULL ROWGUIDCOL UNIQUE DEFAULT(NEWID()),
    Pic     VARBINARY(MAX) FILESTREAM NULL
)

Now in EF Core code-first how can I create this column?

This is a question about generating the column, right? Not using the column? — gunr2171
– gunr2171, Commented Sep 18, 2019 at 19:47
Repeating what you said in your post when I ask a clarification question doesn't answer the question. — gunr2171
– gunr2171, Commented Sep 18, 2019 at 19:49
This is an answer from a previous version of EF. I doubt the functionally has changed. — gunr2171
– gunr2171, Commented Sep 18, 2019 at 19:50

B. Fuller · Accepted Answer · 2022-02-22 18:34:46Z

0

See this solution, in which the author shows how to modify the Up() and Down() methods in an EF migration (i.e. the initial migration) to add a FILESTREAM column, and also how to perform the read/write operations.

He's using EF6, but I would think that the same could be done with EF Core.

answered Feb 22, 2022 at 18:34

B. Fuller

17712 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ryan · Accepted Answer · 2019-09-19 05:14:30Z

-1

In EF core , you could not use FileStream to save file to database.

Instead, you need to convert the file to byte[](which will convert to varbinary(max) in sql server) and copy the file content over when uploading using a memory-stream for instance.

Model:

public byte[] Picture { get; set; }

Convert file to byte array:

using (var ms = new MemoryStream())
{
  file.CopyTo(ms);
  byte[] fileBytes = ms.ToArray();
  string s = Convert.ToBase64String(fileBytes);
  // act on the Base64 data
}

Refer to

Store files in database using Entity Framework Core

How to convert a file into byte array in memory?

edited Sep 19, 2019 at 5:14

answered Sep 19, 2019 at 3:31

Ryan

20.3k10 gold badges44 silver badges68 bronze badges

2 Comments

pantonis Over a year ago

so from your answer it means that EF Core cannot be used to store a file as a Filestream but instead only as varbinary?

dawid debinski Over a year ago

Response was not on the subject it was regarding mssql FileStream, not .net FileStream

Collectives™ on Stack Overflow

Using FileStream in SQL with code first in ASP.NET Core

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related