Dzień dobry,
Używam EF Cora do szyfrowania i deszyfrowania niektórych kolumn.
var keyBase = System.Text.Encoding.UTF8.GetBytes("xxxxxxxxxxxxxxxxxxxxxxxx");
var key = Convert.ToBase64String(keyBase);
_provider = new AesProvider(System.Text.Encoding.UTF8.GetBytes(key));
modelBuilder.UseEncryption(this._provider);
W celach testowych chciałbym napisać skrypt od odszyfrowania danych:
SET @keyBase = 'xxxxxxxxxxxxxxxxxxxxxxxx';
SET @encrypted_data = 'some encrypted data from column';
-- Decode the keyBase from Base64 encoding
SET @key = UNHEX(@keyBase);
-- Generate a random IV (Initialization Vector) or use a predetermined one if available
SET @iv = UNHEX(SHA2(UUID(), 128));
-- Decrypt the data using the key and IV
SET @decrypted_data = AES_DECRYPT(FROM_BASE64(@encrypted_data), @key, @iv);
-- Return the decrypted data
SELECT CAST(@decrypted_data AS CHAR) AS decrypted_data;
Niestety dostaję null-a