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.