How to add a filestream column in the first Entity Framework 4.0 model designer?

Question

I use the EF 4.0 constructor to create the database by clicking "Create Database from Model". I will not use the sql 2008 column type of type "filestream". Unfortunately, I cannot select "filestream" from the Type DropDownList of a particular column.

So, how do I use a filter with EF 4.0 first?

So far I have been looking for some SQL scripts to manually add such columns, but adding them through an SQL script means that I do not have them in my model. What should I do?

Answer 1

Entity structure does not support Filestream . Even if you add it, it will still be used like any other varbinary(max) column. To use Filestream during database generation, you must use custom structural annotation and modify the generation template .

Answer 2

Varbinary (max) binary large binary file (BLOB) data is stored as files on the file system. There is no sql type named FILESTREAM. This is an attribute for BLOB data stored in varbinary (MAX) columns.