Oct 01, 2017 09:35 AM|ganesh123.shirsath|LINK
We have developed an application asp.net mvc with SQL server 2016 in place which uses
1 unit of work and entity framework while communicating with database, currently all CRUDE operations on UI are done with Unit of framework
2. We are using RDL report and we have written Views, stored procedures to fetch data for drawing reports
Currently we have requirement to secure PII (Personally Identifiable Information). We have checked the follow options
1> Always encrypted feature in SQL server 2016, it works perfectly with Entity elements but with stored procedure and views (where we are selecting encrypted columns ) it throws operand mismatch error?
Please suggest suitable approach with which all UI as well as reports will work?
Thanks in advance