What would be the best way to store user files according to the requirements below:
- The user can send one or several files at a time;
- The types of files supported by the application are: mp3, jpg, png, xls, doc, ppt and pdf;
- The architecture is all based on WCF services where there are 2 projects. The UI project that is done in ASP NET MVC 4 with the framework version 4.5 and the WCF project also in .NET 4.5. The database is Sql Server 2012;
My question is this: Given this scenario what would be the best way to store these files? Serializing the files and storing in the database, save the file direct to the server hd (common upload) and store the basic file information to relate to a user or work with FileTables of Sql Server 2012?