Originally, part of my story was to search for both the 32- and 64-bit versions of SQL Server CE. When you're on a very tight development cycle, one day is a big deal. I now have access, but I had to wait a day to utilize it. I had to submit a request to have the website approved through our network security department. My only complaint with the online WiX tutorial is that it does not have a copy (that I could find) that is based here in the US. It would have been extremely useful, had it been available from day one.
I was also able to get a copy of the book "WiX 3.6: A Developer's Guide to Windows Installer XML" which proved to be useful.
Again, this is an "it works sort of" solution to my problem. I had to go back to the documentation several more times and eventually discovered what I needed and what I was doing wrong. We were given a very short amount of time to come up with something, so this is what "works" for now. I was able to come up with the following solution. I'm learning, so I would appreciate as much constructive criticism as possible. I'm not able to correctly detect Microsoft Visual C++ 2010 x86 Redistributable OR Microsoft SQL Server Compact 3.5 Service Pack 2. NET 4.0 if it's installed, and it'll pass right over it.
#Sql server compact 3.5 sp2 download code
So far (thanks to a post from Rob Mensching), my code will detect.