Forum Discussion
Sample Always Encrypted application?
Good day Karen,
You can download my presentation about : New Security Features in SQL Server 2016 - Presentation & Demo
There you can see samples for always encrypted, and some links to samples
https://gallery.technet.microsoft.com/New-Security-Features-in-8c8ca84a
In addition you can see full example step by step tutorial developing the application, here:
https://azure.microsoft.com/en-us/documentation/articles/sql-database-always-encrypted/
https://msdn.microsoft.com/en-us/library/mt757097.aspx
Feel free to ask any question :-)
Good day Karen,
You can download my presentation about : New Security Features in SQL Server 2016 - Presentation & Demo
There you can see samples for always encrypted, and some links to samples
https://gallery.technet.microsoft.com/New-Security-Features-in-8c8ca84a
In addition you can see full example step by step tutorial developing the application, here:
https://azure.microsoft.com/en-us/documentation/articles/sql-database-always-encrypted/
https://msdn.microsoft.com/en-us/library/mt757097.aspx
Feel free to ask any question :-)
Thanks. Thats a great slide deck going over the DDL and the concepts, but I'm not seeing a web app or site in that.
Am I missing it?
Karen
Check the last link that I posetd above.
* I edit the message so maybe you check it before I add the last link
Anyhow, in my presentation you have links as well, I used C# simple console app for the DEMO by the way.
please informa me if still do not find the link to the app development.
Thanks. I have used the console app. I thought i'd seen a MSFT employee demo this with a website (Like Contoso), though. That's the sort of thing I'm looking for.
There is no reason for this. One of the power of using Always Encrypted is that it is almost totally transparent to the client app. You simply need to add one parameter to the connection string, and remember to use Framework 4.61 and above. The encription and decription is done in the client side (the application side), but not by your application, but by the provider (this is why we need to use the new framwork). Except of changing the connection string, there is nothing that the developer need to do in the app code.
* You do need to manage the certificate and so on, but this is not related to application and it is done the same way in any application. Therefore, if you succesfully created a console application, then you don't need to know anything more. You can create use any application that you have -> change the connection string -> and that is all, since your certificate already works with the provider (you checked in the console app).
* The only complex issue that developers might have is managing the certificate (IMO)