We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

SQLServerProvider that use Filetable instead of Filestream

Hello,

i looking for a save way to handle 'documents' (upload, download, change) on an IIS. So i create an ASP.Net Core hosted Blazor Wasm with Authentication via ASP.Net Identity and a SQL Server Database. Most info is stored in the database.

But there is a need for a 'document-store' = directory-hierarchies and files secure handeled on the server and up- and download functions on the Blazor Wasm.

So i think the SF File Manager is the ideal component for the Wasm!

But now i have to chose what is the best Provider on the Server!

The requirements are:

  1. Each user has it's own 'document-structure' and 'document-store' on the server

2. The transfer of 'documents' between Wasm and server should be as save as possible 

So there are 3 possible provider available:

ej2-aspcore-file-provider

ftp-aspcore-file-provider

sql-server-database-aspcore-file-provider

My preference is the SqlServer-provider but instead of Filestream i think the 'FileTable'-feature of SQLServer is the ideal choice! 

So my question:

Do you have any sample that use FileTable?

Do you have any recommandation for a secure transfer of files between Wasm and server?

Thanks for support

Patric



Loader.
Live Chat Icon For mobile
Up arrow icon