Installing a C# Windows Form Project with a NuGet Package on Visual Studio

Question

I've created a simple windows form project that creates a database (SQLite) and displays data on the window.

I've downloaded System.Data.SQLite package. During debug, the system shows the database correctly.

Now I want to create an installable application to share with friends, so I added a setup project on the solution.

When I run the installation from the setup project, nothing happens. I get the following error from Windows Event Viewer

Application: SimpleDB.exe Framework Version: v4.0.30319 Description: The process was terminated due to an unhandled exception. Exception Info: System.DllNotFoundException at System.Data.SQLite.UnsafeNativeMethods.sqlite3_config_none(System.Data.SQLite.SQLiteConfigOpsEnum) at System.Data.SQLite.SQLite3.StaticIsInitialized() at System.Data.SQLite.SQLiteLog.PrivateInitialize(System.String) at System.Data.SQLite.SQLiteLog.Initialize(System.String) at System.Data.SQLite.SQLiteConnection..ctor(System.String, Boolean) at System.Data.SQLite.SQLiteConnection..ctor(System.String) at SimpleDB.SQLiteDatabase.ExecuteNonQuery(System.String) at SimpleDB.FormMain..ctor() at SimpleDB.Program.Main()

The Application installs in Program Files(x86), but it doesn't show any window when I click on the installed executable. These are the files there:

Am I missing something?

When I don't use dependencies (eg SQLite), the program is correctly installs and shows a window.

I think it may be because you did not package SQLite.Interop.dll when you packaged the msi. Many times "System.DllNotFoundException" is not because the dll does not exist, but because it cannot be found. SQLite.Interop.dll helps locate other sqlite packages. You can try to package SQLite.Interop.dll into msi. Will there still be errors in the future? — Wenbin Geng
– Wenbin Geng, Commented Dec 4, 2023 at 9:37
Thanks, I copy pasted SQLite.Interop.dll into the installation folder. When I examine Windows Event Viewer, I see a System.BadImageFormatException exception. — Hex Heager
– Hex Heager, Commented Dec 5, 2023 at 7:21

Hex Heager · Accepted Answer · 2023-12-05 10:21:07Z

1

What worked for me is:

Set the build property for preferring 32-bit
Add SQLite.Interop.dll (the one in the bin/Release/x86 folder, you can also use debug) to the main project
Add SQLite.Interop.dll (the one in the bin/Release/x86 folder, you can also use debug) to the setup project

answered Dec 5, 2023 at 10:21

Hex Heager

1499 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Installing a C# Windows Form Project with a NuGet Package on Visual Studio

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related