Building a .Net 6 web app and storing data in On-Prem database. I collect some sensitive data that needs to be stored in the database in a format that is not easily readable. I also need to retrieve that data and display it in my application.
Security is not really an issue, I just want to make sure someone browsing the database cant read the data. So a simple encrypt/decrypt.
I want to use a single key for Encrypt/Decrypt that will be stored in the web.config file. The application is used by multiple people in the organization and they all need to be able to read/write/edit the sensitive data.
I have looked at a few examples in the MSDN docs and they all seem like overkill for my scenario. What would you suggest?