I have downloaded a project (file table) from GITHUB, now i have my File tables in sql-server
i have added a type named filestream to my FileTableDBNew which is my current database that is holding the filetables.

now there is an issue related to deleting a row from my filetable, the problem is that i can delete a record of data but i expect it to get deleted from the physical path on my computer, but somehow it doesnt get deleted as i expected !!!

im glad to see any suggestions that might solve my problem, thanks ✌

i have tried multiple ways such as giving all the permissions to all folders on my system, i have used a transaction as a command to delete a row and expect to not have it in the physical location, in sql server configuration management i have set all the configs related to filestream but it seems that none of them is working …