Adding encrypted file into a database and retrieving them

Question

Hi,

I'm trying to write an encrypted XML file into a database table and also read from it.
I use Microsoft SQL server management studio 18 and have a very basic database with a table containing XML digital signature file in one of its columns as a string(nvarchar(MAX)).
And now I want to encrypt it so it wouldn't be saved as a plain-text and with some added security.
I followed this walkthrough on Microsoft Learn: walkthrough-creating-a-cryptographic-application but I can't seem to get it working it throws "unable to read, invalid characters" exception when trying to read the file.

So my question is: How should I change the code provided in the walkthrough to correctly read the encrypted file from my database?

Thank you for your time.
Regards,
Enkhbold.

Answer 1

Hi Enkhbold,
try following demo.

  <Window.DataContext>  
    <local:ViewModel/>  
  </Window.DataContext>  
  <StackPanel>  
    <Button Content="Create datatable on SQL Server" Command="{Binding Cmd}" CommandParameter="Create"/>  
    <Button Content="Insert encrypted xml to datatable" Command="{Binding Cmd}" CommandParameter="Insert"/>  
    <Button Content="Read from datatable and encrypt" Command="{Binding Cmd}" CommandParameter="Load"/>  
    <Button Content="Test encrypt - decrypt" Command="{Binding Cmd}" CommandParameter="Test"/>  
    <TextBlock Text="{Binding Info}"/>  
  </StackPanel>  

--------------------------------------------------------------------------

The forum software deny show whole code. I will prepare upload.

Sorry, in this buggy forum include link is prohibited, see pictures:

You can find demo in Github under https://github.com/fips1950/EnDeCrypt_Demo_EnkhboldMunkhbold-5136

Answer 2

Hi,

.NET development is currently not supported in the Q&A forums, the supported products are listed over here https://learn.microsoft.com/en-us/answers/products (more to be added later on).

You can ask the experts in the dedicated .NET development forums over here:
https://dotnet.microsoft.com/platform/community

https://social.msdn.microsoft.com/Forums/vstudio/en-US/home?category=netdevelopment

(Please don't forget to accept helpful replies as answer)

Best regards,
Leon