Code first filetable in SQL Server

You can add custom SQL in a Code First Migration.

• Create a migration Add-Migration
• Put In some Custom SQL to Enable Filestreams
• Update the db with Update-Database

Example migration with custom SQL:

public partial class AddFileStreamMigration: DbMigration 
{ 
    public override void Up() 
    { 
        var customSql = @"ALTER DATABASE Photos
                          SET FILESTREAM (NON_TRANSACTED_ACCESS = FULL)
                          GO

                          etc...";
        Sql(customSql ); 
    } 

    public override void Down() 
    { 
        //Make sure you put in roll back SQL too!
    } 
}