Folks, in my attempts to get the EF4 and SQLite apps working on the server (it's still stuffed), I followed someone's advice about building for the x64 platform and linking to the 64-bit SQLite DLL. The result of this was a hour of mind-boggling compile and run-time errors, some so bizarre that you just couldn't make them up in a Star Trek movie script. It took me another hour to get the compile and platform settings back to normal again, mainly because I never needed to change the platform before and I was confused by forgetting the defaults and the multiple ways of settings the platform. You can set the platform in the Configuration Manager and in two places on the project properties page.
All that aside, I am left wondering when and why anyone would need to change the platform away from the defaults of Any CPU for libraries and x86 for applications. Has anyone changed their platform for a good reason? >From reading about the platform switch <http://msdn.microsoft.com/en-us/library/zekwfyz4(v=vs.80).aspx> it looks like the default of x86 for executables means that the images run emulated under WOW64, which can't be good since every machine we have here is a 64-bit OS. Does that imply perhaps that for top performance we need to always have a pair of projects, one for x86 and one for x64, but that's nuts as it defeats the point of the CLR. Uh! Greg
