Microsoft.Data.Sqlite 10.0.11 breaks .NET Framework builds via SQLitePCLRaw.lib.e_sqlite3 2.1.12 missing win-arm native

[tschettler]

Description

Microsoft.Data.Sqlite 10.0.11 pulls SQLitePCLRaw.bundle_e_sqlite3 2.1.12, which depends on SQLitePCLRaw.lib.e_sqlite3 2.1.12. That package has a bug where the buildTransitive\net461\SQLitePCLRaw.lib.e_sqlite3.targets file references runtimes\win-arm\native\e_sqlite3.dll, but the win-arm native binary was removed from the package contents in that version.

This breaks any multi-target project (e.g. net472;net10.0) that references Microsoft.Data.Sqlite 10.0.11 during the .NET Framework build.

Upstream issue: ericsink/SQLitePCL.raw#678

Error

Could not copy the file "C:\Users\...\.nuget\packages\sqlitepclraw.lib.e_sqlite3\2.1.12\runtimes\win-arm\native\e_sqlite3.dll" because it was not found.

Workaround

Pin Microsoft.Data.Sqlite to version 10.0.10, which pulls SQLitePCLRaw.lib.e_sqlite3 2.1.11 (where the file exists).

Ask

Once the upstream fix is released (likely as SQLitePCLRaw.lib.e_sqlite3 2.1.13), please update Microsoft.Data.Sqlite to reference the corrected version in a servicing patch.

Environment

• .NET SDK: 10.0
• Project target frameworks: net472;net10.0
• OS: Windows x64
• Microsoft.Data.Sqlite: 10.0.11 (broken), 10.0.10 (works)

[tschettler]

The upstream fix has been released as SQLitePCLRaw.lib.e_sqlite3 2.1.13. Adding an explicit PackageReference to that version resolves the build failure while continuing to use Microsoft.Data.Sqlite 10.0.11:

<PackageReference Include="SQLitePCLRaw.lib.e_sqlite3" Version="2.1.13" />

This works as a workaround until Microsoft.Data.Sqlite is updated to reference the fixed transitive dependency.

[ericsink]

Version 2.1.13 of SQLitePCLRaw.bundle_e_sqlite3 and its dependencies have now been published.

[jchernin4]

@AndriySvyryd is there a roadmap available that shows when Microsoft.Data.Sqlite will be updated to reference SQLitePCLRaw.lib.e_sqlite3 2.1.13?

[AndriySvyryd]

@AndriySvyryd is there a roadmap available that shows when Microsoft.Data.Sqlite will be updated to reference SQLitePCLRaw.lib.e_sqlite3 2.1.13?

The fix will be released in 10.0.13 on October 13. 10.0.12 is already closed for changes.