if you are only retrieving them for display, then you have more options.



If you need to secure them, delete them, update them, and add new ones then you need to have a system in place to handle that.



you can use a dbms to do that, and it is probably a bit easier to do it that way. longer term it will be more expensive and seriously slow down backups. I recommend against that for a production application.



If you are using a cloud infrastructure such as azure or aws, then you will want to use the azure/aws blob storage service. storage costs are much lower than storing in a database, and have better/automatic backups etc. it is all rest api based.



if hosting on your own hardware, you can still use the blob services. but you can also write your own in c# to handle the uploads/deletes/retrieves and then just store them on the server. You have to figure out your own backups etc.

Thank you.

Will you share a sample of how to go about with DBMS?

you use selectblob and updateblob sql statements to select and update a blob column where you store your files.

syntax is dependent on your database