I am currently designing a web application where the data needs to be stored encrypted.
Planned technologies used:
- ASP.NET Core API
- ASP.NET Core Entity Framework
- MS SQL Server 2016
- any Web Frontend
Because of the specification we need to store all data encrypted in the database.
Which would be a good approach to achieve this while still be able to use the Entity Framework & LINQ, so the developer does not have to take care about the encryption.
Is it possible to encrypt the whole database?
To clarify, the encryption between the web frontend & the API isn't something that's related to this question.