Open SQLite database in C# WITHOUT installing anything

Question

I am writing a portable C# application designed to be run as a single executable file on a USB. It needs to be able to extract some data from a SQLite database. Because it is portable, installing something locally is not an option. I have seen questions like this and this but they require installing third party software.

How can I get this data without losing the portability?

Edit: I tried using the System.Data.SQLite NuGet package. It works, but then suddenly I have gone from a single executable file to an executable, a .dll and two additional folders. I can deal (albeit unhappily) with a single dll addition, but that is too much.

You don't really need to install anything. Just download an additional dll and have it present with you program. — Vadim
– Vadim, Commented Sep 7, 2013 at 8:20
Since the source code is available - you could integrate the managed dlls (System.Data.SQLite.dll and System.Data.SQLite.Linq.dll) into your own dll. You'll still be left with 1 or 2 native dlls files. Why do you care so much for the number files? — Vadim
– Vadim, Commented Sep 7, 2013 at 12:37
@Vadim The idea of this program is that it can easily be transferred, copied, moved around, etc. as simply as possible. Having multiple files complicates things — Garrett
– Garrett, Commented Sep 7, 2013 at 14:28

Jury Soldatenkov · Accepted Answer · 2013-09-07 14:23:32Z

2

You have two options:

Use IlMerge.
Embed an assembly as a resource.

answered Sep 7, 2013 at 14:23

Jury Soldatenkov

4171 gold badge6 silver badges13 bronze badges

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

Comments

Garrett · Accepted Answer · 2013-09-07 09:36:52Z

0

Well I think is about as good as it is going to get: I got it down to a single executable and a single dll file.

To do this I changed the architecture of the executable from Any CPU to x86 only, and then installed the "System.Data.SQLite.x86" NuGet package.

If anyone knows how to keep the capability but in a single executable file, I would be very grateful.

answered Sep 7, 2013 at 9:36

Garrett

5,6302 gold badges35 silver badges48 bronze badges

Comments

dasjones · Accepted Answer · 2018-03-18 22:45:02Z

0

Try Costura.Fody (browse on Nuget Packages), i usually use this one and it packs everything in a single exe, i believe it should work.

answered Mar 18, 2018 at 22:45

dasjones

15 bronze badges

Collectives™ on Stack Overflow

Open SQLite database in C# WITHOUT installing anything

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related