StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
316403
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2008-11-25T04:59:15.207
FavoriteCount
0
LastActivityDate
2008-11-25T04:59:15.207
LastEditDate
LastEditorUserId
0
OwnerUserId
1865
ParentId
306992
PostTypeId
2
Score
4
ViewCount
0
LastEditorDisplayName
text
Body
Here is what I ended up with... I used WiX and DTF to created a managed code Custom Action to encrypt a given section of a config file: <pre><code> public static void EncryptConfig(Session session) { var configPath = session["APPCONFIGPATH"]; var sectionToEncrypt = session["SECTIONTOENCRYPT"]; var fileMap = new ExeConfigurationFileMap(); fileMap.ExeConfigFilename = configPath; var configuration = ConfigurationManager.OpenMappedExeConfiguration(fileMap, ConfigurationUserLevel.None); ConfigurationSection section = configuration.GetSection(sectionToEncrypt); if (!section.SectionInformation.IsProtected) { section.SectionInformation.ProtectSection("DataProtectionConfigurationProvider"); section.SectionInformation.ForceSave = true; configuration.Save(ConfigurationSaveMode.Modified); } } </code></pre> Part of my lack of understanding that prompted this question was not knowing that you can safely create custom actions in managed code using DTF. Documentation is sparse on DTF, but once you get it working, it is great. I found that this only worked if I scheduled the custom action after InstallFinalize. Here is the WiX config to make it happen: <pre><code><InstallExecuteSequence> <Custom Action="EncryptConfigurationFiles" After="InstallFinalize" /> </InstallExecuteSequence> <Fragment> <Binary Id="YourProject.CustomActions.dll" SourceFile="$(var.YourProject.CustomActions.TargetDir)$(var.YourProject.CustomActions.TargetName).CA.dll" /> <CustomAction Id="EncryptConfigurationFiles" BinaryKey="YourProject.CustomActions.dll" DllEntry="EncryptConfig" Return="check" /> </Fragment> </code></pre> These blogs/sites helped me get there and much of the code from above was derived from them: <a href="http://geekswithblogs.net/afeng/Default.aspx" rel="nofollow noreferrer">http://geekswithblogs.net/afeng/Default.aspx</a> <a href="http://blog.torresdal.net/2008/10/24/WiXAndDTFUsingACustomActionToListAvailableWebSitesOnIIS.aspx" rel="nofollow noreferrer">http://blog.torresdal.net/2008/10/24/WiXAndDTFUsingACustomActionToListAvailableWebSitesOnIIS.aspx</a> <a href="http://blogs.msdn.com/jasongin/archive/2008/07/09/votive-project-platform-configurations.aspx" rel="nofollow noreferrer">http://blogs.msdn.com/jasongin/archive/2008/07/09/votive-project-platform-configurations.aspx</a> @PITADeveloper... Thanks for the response. I found that I did not need to load the assembly to encrypt the config file. If you use this, you should use a try catch and return an ActionResult... The above is pseudo-code. Finally, I'm using the DataProtectionConfigurationProvider. For the RSA Provider, I think there are a couple more hoops to jump through. I hope this helps someone!
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow do I encrypt app.config file sections during install with WiX?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USJasonS
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. CONice! This will certainly help me in the future.
 singulars
 PostPostId
 PO
 UserUserId
 USAJ.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.