Issue Publishing with SQLite #97

New Issue

claunia · 2026-01-29T16:30:48Z

claunia commented

2026-01-29 16:30:48 +00:00

Originally created by @jfaquinojr on GitHub (Dec 29, 2017).

Originally assigned to: @GregorBiswanger on GitHub.

How can I change this so `dotnet electronize start` uses win7-x64 instead of win-x64?

How to repro:

setup getting started code:
https://docs.microsoft.com/en-us/ef/core/get-started/netcore/new-db-sqlite

after everything is said done:

dotnet publish -r win-x64 --output ".\published"

cd \published
dotnet run

Error:

Unhandled Exception: System.TypeInitializationException: The type initializer for 'Microsoft.Data.Sqlite.SqliteConnection' threw an exception. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.DllNotFoundException: Unable to load DLL 'e_sqlite3': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
at SQLitePCL.SQLite3Provider_e_sqlite3.NativeMethods.sqlite3_libversion_number()
at SQLitePCL.SQLite3Provider_e_sqlite3.SQLitePCL.ISQLite3Provider.sqlite3_libversion_number()
at SQLitePCL.raw.SetProvider(ISQLite3Provider imp)
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at Microsoft.Data.Sqlite.Utilities.BundleInitializer.Initialize()
at Microsoft.Data.Sqlite.SqliteConnection..cctor()
--- End of inner exception stack trace ---
at Microsoft.EntityFrameworkCore.Storage.Internal.SqliteRelationalConnection.CreateDbConnection()
at Microsoft.EntityFrameworkCore.Internal.LazyRef1.get_Value() at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected) at Microsoft.EntityFrameworkCore.Storage.Internal.SqliteRelationalConnection.Open(Boolean errorsExpected) at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.BeginTransaction(IsolationLevel isolationLevel) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(Tuple2 parameters)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable1 commandBatches, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IReadOnlyList1 entriesToSave)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess)
at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess)
at ConsoleApp.SQLite.Program.Main() in C:\Users<username>\Source\Repos\temp\sqlite_test\Program.cs:line 12

Temp Solution:

dotnet publish -r win7-x64 --output ".\published"

How can I change this so dotnet electronize start uses win7-x64 instead of win-x64?

Environment

.NET Command Line Tools (2.1.2)

Product Information:
Version: 2.1.2
Commit SHA-1 hash: 5695315371

Runtime Environment:
OS Name: Windows
OS Version: 6.1.7601
OS Platform: Windows
RID: win7-x64
Base Path: C:\Program Files\dotnet\sdk\2.1.2\

Microsoft .NET Core Shared Framework Host

Version : 2.0.4
Build : 7f262f453d8c8479b9af91d34c013b3aa05bc1ff

Thanks in advance!

Originally created by @jfaquinojr on GitHub (Dec 29, 2017). Originally assigned to: @GregorBiswanger on GitHub. ### How can I change this so `dotnet electronize start` uses win7-x64 instead of win-x64? -------- ### How to repro: setup getting started code: https://docs.microsoft.com/en-us/ef/core/get-started/netcore/new-db-sqlite after everything is said done: ``` dotnet publish -r win-x64 --output ".\published" cd \published dotnet run ``` ### Error: > Unhandled Exception: System.TypeInitializationException: The type initializer for 'Microsoft.Data.Sqlite.SqliteConnection' threw an exception. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.DllNotFoundException: Unable to load DLL 'e_sqlite3': The specified module could not be found. (Exception from HRESULT: 0x8007007E) > at SQLitePCL.SQLite3Provider_e_sqlite3.NativeMethods.sqlite3_libversion_number() > at SQLitePCL.SQLite3Provider_e_sqlite3.SQLitePCL.ISQLite3Provider.sqlite3_libversion_number() > at SQLitePCL.raw.SetProvider(ISQLite3Provider imp) > --- End of inner exception stack trace --- > at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) > at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) > at Microsoft.Data.Sqlite.Utilities.BundleInitializer.Initialize() > at Microsoft.Data.Sqlite.SqliteConnection..cctor() > --- End of inner exception stack trace --- > at Microsoft.EntityFrameworkCore.Storage.Internal.SqliteRelationalConnection.CreateDbConnection() > at Microsoft.EntityFrameworkCore.Internal.LazyRef`1.get_Value() > at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected) > at Microsoft.EntityFrameworkCore.Storage.Internal.SqliteRelationalConnection.Open(Boolean errorsExpected) > at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.BeginTransaction(IsolationLevel isolationLevel) > at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(Tuple`2 parameters) > at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection) > at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IReadOnlyList`1 entriesToSave) > at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess) > at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess) > at ConsoleApp.SQLite.Program.Main() in C:\Users\<username>\Source\Repos\temp\sqlite_test\Program.cs:line 12 ## Temp Solution: `dotnet publish -r win7-x64 --output ".\published"` How can I change this so `dotnet electronize start` uses win7-x64 instead of win-x64? ### Environment .NET Command Line Tools (2.1.2) Product Information: Version: 2.1.2 Commit SHA-1 hash: 5695315371 Runtime Environment: OS Name: Windows OS Version: 6.1.7601 OS Platform: Windows RID: win7-x64 Base Path: C:\Program Files\dotnet\sdk\2.1.2\ Microsoft .NET Core Shared Framework Host Version : 2.0.4 Build : 7f262f453d8c8479b9af91d34c013b3aa05bc1ff Thanks in advance!

claunia referenced this issue

2026-01-29 16:57:10 +00:00

[PR #97] [MERGED] Grammer Changes #1082

claunia referenced this issue

2026-01-29 16:57:11 +00:00

[PR #97] Grammer Changes #1087

Sign in to join this conversation.