SQL Server Compact Edition - Any way to compile the code in AnyCPU?

Either v3.5 or v4.0...it seems that there is either an x86 version or x64 vers开发者_如何学编程ion - is there a way to compile my c# code with the AnyCPU flag? I'd hate to have to peg my app to a certain architecture.

Yes. There is a way. I assume you want to do a "private deployment" for SQL CE.

In which case, you put x86 versions of the SQL CE assemblies into a subfolder of your deployment named x86. You put the x64 assemblies into a subfolder of your deployment named AMD64.

I did this a while ago, but I believe the key links were here and here. I also think there was a key bit of a doco in the SQL CE Books Online on how to extract the x64 assemblies if you're only using an x86 development machine.

The AnyCPU flag should work, you will have to install the appropriate version of sqlce for your platform, the application will automatically run in that configuration.