Code first filetable in SQL Server

Question

Trying to take advantage of the FileTables feature in SQL Server 2012 in my current MVC5 project. Does anyone have any examples of how to create the file table "table" using code first? All of my tables, indexes, etc. are done using code first and I'd like to continue that practice here.

Atchitutchuk · Accepted Answer · 2015-01-29 13:08:04Z

1

Unfortunately I cannot help you with FileTable, but this example of FileStream (similar thing in many ways) works quite well.

answered Jan 29, 2015 at 13:08

Atchitutchuk

1841 silver badge5 bronze badges

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

Comments

Mentor · Accepted Answer · 2015-04-14 13:51:06Z

1

The decision is available here: "WEB API FILE UPLOAD WITH MS SQL SERVER FILETABLE" https://damienbod.wordpress.com/2014/04/08/web-api-file-upload-with-ms-sql-server-filetable/

answered Apr 14, 2015 at 13:51

Mentor

3,3652 gold badges24 silver badges30 bronze badges

Comments

DarcyThomas · Accepted Answer · 2016-05-02 00:03:22Z

1

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!
    } 
}

```

edited May 2, 2016 at 0:03

answered Apr 14, 2016 at 1:48

DarcyThomas

1,28815 silver badges33 bronze badges

Collectives™ on Stack Overflow

Code first filetable in SQL Server

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related