I Need to know is there a common AES-256 algorithm which support Encryption and decryption from Both C# and SQL server ?
1) Master Key
3) Symmetric Key
Above are already in place in the database for specific columns like password
How do I make the application compatible with Encryption handling data from such columns on the front end.
Eg: Password for a user (in terms of login authentication, change password such operations done through SP calls from the app)
The main question is, can I inherit or derive the symmetric key created in the above method to be used in the app for encrypt/decrypt compatible between the app and db?
I needed to encrypt and decrypt data from both end (SQL and Application)
Can anybody help me with this ?