Using Data Encryption with C# 2022 and SQL Server 2022

Edward Aymami

I am converting my networked desktop application from VB6 to C#. I have used MS SQL Server for my database for years. I need to encrypt certain columns in various tables, and be able to encrypt new data records when I Add one, and decrypt records as I retrieve them.

Is there an understandable tutorial shoeing how to do this, or a 3rd party application that will work for me?

Any help/information would be greatly appreciated.

Ed Aymamii

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Muhammad Imran Ansari2y ago
Accepted answer
Hi Edward,

Kindly check the below links for reference:

https://learn.microsoft.com/en-us/sql/relational-databases/security/encryption/transparent-data-encryption?view=sql-server-ver16&redirectedfrom=MSDN

https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2008/cc278098(v=sql.100)?redirectedfrom=MSDN
Jithu Thomas2y ago
For better understanding please refer -

Transparent Data Encryption (TDE) - https://learn.microsoft.com/en-us/sql/relational-databases/security/encryption/transparent-data-encryption?view=sql-server-ver16

Always Encrypted - https://learn.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted-database-engine?view=sql-server-ver16

3rd Party Applications as follows: -

DB Encryption - https://www.database-encryption.com/

netlibsecurity.com - https://netlibsecurity.com/