Filestream with entity framework

Question

Hi, I'm developing a desktop application using entity framework 6 and sql to store different type of documents like Pdf, Word, Excel Image, etc.., I managed to activate Filestream with my SQL database and saved successfully the data as byte[] but now I need a way to retrieve it using also entity frame work so when I double click on file name in datagridview, it will open by default app in computer. help me please!.

Chittaranjan Swain · Answer

Hi Ali,   Refer below links, https://stackoverflow.com/questions/10055280/sql-filestream-entity-framework-store-large-files http://floatincode.net/blog/sql-file-stream-in-asp.net-mvc-with-entity-framework/ https://social.msdn.microsoft.com/Forums/en-US/631f7756-e44d-42cf-9426-d2a68d9aee4d/filestream-and-entity-framework?forum=adodotnetentityframework https://forums.asp.net/t/2014687.aspx?Store+Large+files+in+SQL+FileTables+using+Entity+Framework+in+MVC+5

Dinesh Gabhane · Answer

Please go through below articles, it will hopefully help you   https://www.aspsnippets.com/Articles/Entity-Framework-Upload-Files-Save-Insert-to-database-Retrieve-Display-and-Download-Files-from-database-in-ASPNet-MVC.aspx   https://www.aspsnippets.com/Articles/Upload-Insert-and-Download-Retrieve-Files-from-Database-using-Web-API-in-ASPNet-MVC.aspx   https://stackoverflow.com/questions/23822058/view-and-download-file-from-sql-db-using-entity-framework