AES128/256 C#. net AND SQL 2008/2012 encryption

Asked

Viewed 217 times

1

Greetings,

Does anyone know of any AES compliant encryption implementation between c# and SQL? I want to encrypt in C# and decrypt in SQL.

c# sql .net sql-server cryptography

1 answer

3

You can implement the encryption library in . NET and install it directly in your MS SQL Server service.

Once Assembly has been properly installed on the server, its classes can be configured and accessed as in the example below:

CREATE PROCEDURE teste
AS
EXTERNAL NAME Biblioteca.Classe.MetodoTeste

Source: 'Deploying CLR Database Objects', MSDN.

  • Good solution, but it doesn’t fit my case.... really needed an internal algorithm that performs the encryption. Thanks anyway.

  • 1

    @Pedro I went through a similar situation in the past, and my biggest problem was the lack of consistency between the algorithmic implementations between the two platforms. The installation of a CLR was the way found to ensure that the encryption and decryption methods followed the same parameters. Anyway, good luck in your search!

  • There is no way to do this using both platforms differently. You need to encode and decode the data "manually" by C#.

Browser other questions tagged c# sql .net sql-server cryptography

You are not signed in. Login or sign up in order to post.