codequest
asked on
Encrypt in c# into sql server, read, xml-serialize, download and decrypt in local windows PC
What are some options for doing the local decryption?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Do you just need to encrypt the data or are you looking to encrypt it before the data leaves the server?
Also what is your target environment on the local windows 7 pc?
Can you describe your workflow in more detail?
Also what is your target environment on the local windows 7 pc?
Can you describe your workflow in more detail?
What is it that you want to encrypt? Do you want to use certificates for symmetric encryption/decryption ? How do you envision things to be working?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the questions and inputs.
I am building an ASP net application. It will produce work products in SQL Server. A user function is to be able to convert certain data sets to XML and download them. One of the options will be to encrypt these data sets prior to download. After they are downloaded, one workflow is to re-upload them, provide the password to decrypt them, and we load them into the database for further use. I have already implemented that.
What I'm hoping to find out is if there is any way that the document could be downloaded encrypted and then locally decrypted, so that it could for example be converted to an Excel document.
I appreciate that the person doing the download could do that on a secure line, so that they might not need to encrypt it. I'm imagining some use cases though where they might want to download it encrypted and then locally decrypt it later for some other purpose.
I'm thinking that one possible scenario is to create a little local .net app that they could use to decrypt with, because at least would have the same .net technology, which might work the same way both in a server application and in a local .net application. in that case however I would be stuck with the .net dependency which could be some limitation.
Another option may be that they have to download one of the work products decrypted and then encrypt it themselves locally if that's what they need (like to distribute it via email).
In fantasyland it could be decrypted in Excel.
It is possible that there is no solution for this that is not highly convoluted and if that is the case it would be good to at least get that resolved. So answers that might indicate that are welcome.
I am building an ASP net application. It will produce work products in SQL Server. A user function is to be able to convert certain data sets to XML and download them. One of the options will be to encrypt these data sets prior to download. After they are downloaded, one workflow is to re-upload them, provide the password to decrypt them, and we load them into the database for further use. I have already implemented that.
What I'm hoping to find out is if there is any way that the document could be downloaded encrypted and then locally decrypted, so that it could for example be converted to an Excel document.
I appreciate that the person doing the download could do that on a secure line, so that they might not need to encrypt it. I'm imagining some use cases though where they might want to download it encrypted and then locally decrypt it later for some other purpose.
I'm thinking that one possible scenario is to create a little local .net app that they could use to decrypt with, because at least would have the same .net technology, which might work the same way both in a server application and in a local .net application. in that case however I would be stuck with the .net dependency which could be some limitation.
Another option may be that they have to download one of the work products decrypted and then encrypt it themselves locally if that's what they need (like to distribute it via email).
In fantasyland it could be decrypted in Excel.
It is possible that there is no solution for this that is not highly convoluted and if that is the case it would be good to at least get that resolved. So answers that might indicate that are welcome.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the inputs. Many good ideas. It's clear that there are a variety of solutions, so there is do-ability here. I need to think about the use cases that are made possible by these options. For practical purposes, this is answered, so I'm rewarding points now.
ASKER