Encryption of database cells using SQL commands and c #

There is a simple client application for the database created in SQL Server 2014 EXPRESS, it is required to encrypt the data in the cells. Found an algorithm and encryption commands, but using SQL Server. Tell me how to implement encryption and decryption of data in the client. Data is output using DataGredView, editing using TextBox.

Insert commands:

cvetTableAdapter.Insert(textBox2.Text); cvetTableAdapter.Fill(gIBDDDataSet.Cvet); 

Update commands:

 cvetBindingSource.EndEdit(); cvetTableAdapter.Update(gIBDDDataSet.Cvet); cvetTableAdapter.Fill(gIBDDDataSet.Cvet); 

Deletion commands:

 cvetTableAdapter.Delete(Convert.ToInt32(textBox1.Text), textBox3.Text); cvetTableAdapter.Fill(gIBDDDataSet.Cvet); 

Program code to create keys for demonstration. Keys are created in the database itself. There are no problems with this.

 USE [EncryptedDB] GO — Создание асимметричного ключа, зашифрованного — парольной фразой StrongPa$$w0rd! CREATE ASYMMETRIC KEY MyAsymmetricKey WITH ALGORITHM = RSA_2048 ENCRYPTION BY PASSWORD = 'StrongPa$$w0rd!' GO — Создание симметричного ключа, зашифрованного — асимметричным ключом. CREATE SYMMETRIC KEY MySymmetricKey WITH ALGORITHM = AES_256 ENCRYPTION BY ASYMMETRIC KEY MyAsymmetricKey GO 

Here is the insert itself with encryption. From here the problems begin, because I do not understand how to implement all this in c #.

 USE [EncryptedDB] GO DECLARE @SymmetricKeyGUID AS [uniqueidentifier] SET @SymmetricKeyGUID = KEY_GUID('MySymmetricKey') IF (@SymmetricKeyGUID IS NOT NULL) BEGIN INSERT INTO [dbo].[CreditCardInformation] VALUES (01, ENCRYPTBYKEY(@SymmetricKeyGUID, N'9876-1234-8765-4321')) 

Data output with decryption. Again, how to implement this in the functionality of the application.

 USE [EncryptedDB] GO SELECT [PersonID] CONVERT([nvarchar](32), DECRYPTBYKEY(CreditCardNumber)) AS [CreditCardNumber] FROM [dbo].[CreditCardInformation] GO 

Help, everything has already been covered. Nowhere is there anything sensible.