FileTable performance test

In my last post I have described a workaround for using a FileTable in Entity Framework 6.0. In this post I would like to show you the results of performance test of storing big documents in sql FileTable. I have put in comparison storing 10 pdf documents 16MB each in database. First application is a Entity Framework Code First based app with mapped stored procedures. Those pro…

By Mirek on (tags: Entity Framework, FILETABLE, SQL, categories: architecture)

Using SQL FileTable in Entity Framework

FileTable is a great new feature in SQL Server 2012 which facilitates storing and working with unstructured blob data in SQL Server. Unfortunately is not yet supported in Entity Framework, so you cannot simply use FileTable in your entity model. But there is a workaround for this inconvenience, which I am going to show you in this post. FileTable is a fixed schema regular sql t…

By Mirek on (tags: Entity Framework, FILESTREAM, FILETABLE, SQL, categories: architecture, infrastructure, code)