title: Data Encryption in Data Layer with ASP.NET Core Entity Framework
body: <p>I am currently designing a web application where the data needs to be stored encrypted.</p>
  <p>Planned technologies used:</p>
  <ul>
  <li>ASP.NET Core API</li>
  <li>ASP.NET Core Entity Framework</li>
  <li>MS SQL Server 2012</li>
  <li>any Web Frontend</li>
  <li>Because of the specification, we need to store all data encrypted in the database.</li>
  </ul>
  <p>Which would be a good approach to achieve this while still be able to use the Entity Framework &amp; LINQ, so the developer does not have to take care of the encryption.</p>
  <p>Is it possible to encrypt the whole database?</p>