Wondering if anyone has compiled SQLite for the Windows for ARM release that's required to run a Windows VM on M1 macs. I haven't turned anything up in my searching just yet and am beginning to wonder if it's a platform limitation due to the architecture.

That's a fair point. So not a limitation but maybe just hasn't been compiled just yet.

Do you actually have a Windows VM that running on an M1 Mac ? If so, which one ?

There's nothing to prevent SQLite to run on such a thing. The SQLite amalgamation code runs on M1 Macs under macOS. SQLite runs on Windows VMs. In both cases you just have to add it to an appropriate project and use a compile that understands its C code, not C++ code.

Yes I have a VM running Windows 11 Pro Insider Preview OSBuild 22483.1011

I just stumbled across DockCross and it looks like they have a windows-arm64 distro so I'm currently seeing if that's going to get me the single dll we need for the ODBC connector like we're currently using.

Did you find the dll for arm64 windows in the end?

SQLite is published as C code. It has no dependencies. If you can compile C code for a platform, you can compile SQLite for that platform.

Do you have a specific problem you encountered trying to compile SQLite ?

Later:

I see you aren't actually trying to compile SQLite into your project. You're looking for a pre-compiled DLL for your specific platform. As far as I can tell, there's nothing stopping someone from making one for the platform you described. I can confirm that SQLite works fine on both Apple M1 and Apple M2 computers.

I tried to compile the dll for windows on arm (64) to use but unfortunately I was not successful. is it possible that the precompiled dll for windows on arm is posted on github or sqlite-site for the community to use?

I was able to compile it by updating the target framework in <repo>\System.Data.SQLite.Linq\System.Data.SQLite.Core.2017.csproj to 4.8.1, and then opening the sln and letting VS 2022 update everything else to 4.8.1, or in the case of the C/C++ VS updated the platform toolset to v141, but that'd probably depend on whether you're compiling from windows 10 or 11.

And then in the sln properties, I added an ARM64 cpu architecture. And it built

Then I was able to build the release natives. I've had issues with building normal release mode though.

But the problem I ran into with building it myself was that the version I built couldn't be used with SEE encryption. But if you're not using that, I didn't personally run into any problems using my version of SQLite.Interop with the nuget version of system.data.sqlite

It would be much easier if it would be supplied/maintained as part of the nuget package though. now that net framework 4.8.1 is released, which supports windows on ARM

The only piece missing is SQLite.Interop.dll for ARM64 in the nuget package. But I have no idea how to build that Interop dll.

hi, any update on this? I've got the same issue (missing SQLite.Interop.dll)

Same issue here. Running VS C# code in Win 11 Ent ARM on Apple M2 with VMWare Fusion 13. Getting the SQLite.Interop.dll or dependency could not load error. Any assistance getting this into the NuGet package would be greatly appreciated!

Hi,

Recently I required an ARM64 build of System.Data.SQLite so I could run some of my toy C# projects on my home Raspberry Pis. I fumbled my way through until I ended up with System.Data.SQLite .dlls that worked on the Pis. I've made the dockerfile, etc available on GitHub; you may find these helpful in building System.Data.SQLite for your own use, however note the warning - I've not tested this approach beyond my own basic testing. Use at your own risk.

https://github.com/tkf144/System.Data.SQLite-ARM64

Regards, Tom

Any way to share you build ?

Cheers