Not sure where to report this issue. I could not find a bug database on Microsoft Connect. Although I found a work around, I'm wondering if anyone has any other ideas.
When using nunit-x86.exe and VS 2010 + .NET 4.0 to debug unit tests using SQL Server Compact Edition 4.0 privately deployed, I get the following error:
"Unable to load the native components of SQL Server Compact corresponding to the ADO.NET provider of version 8482. Install the correct version of SQL Server Compact. Refer to KB article 974247 for more details."
(Note that it would be nice if the article actually applied to SQL Server CE 4.0 - but that's another topic.)
I spent lots of time trying to track this down, and finally was able to work around the issue by changing my unit test dll to compile for x86 instead of Any CPU. Note that the issue does not manifest itself when I'm not running under the VS 2010 debugger.
To confirm that I'm running in 32 bit mode, I checked the System.Environment.Is64BitProcess property.
I'm pretty sure that SQL Server CE 4 is looking for the amd64 dlls because when I added them to the private deploy directory, I began getting the BadImageFormatException. And this seems obviously incorrect, since we are running in 32 bit mode.
I guess it would be nice to know more specifically what heuristic S
View Complete Post