How to add SQLite .db into C#.NET project

Question

I just started to learn C#, and currently trying to create a simple program that read 1 row of data from SQLite database.

I've successfully created the program, but i still have to refer to the .db file with full address like :

SQLiteConnection("Data Source=C:/Users/../SQLiteStudio/dbs/mk_ii.db; Version=3;")

But this way, the .db won't be included when i create an installer. I want to make it something like when i add an image to my Solution Explorer, i can use short address like :

res/img/logo.png  --i also have copy of .db file in res/ folder

So, is there any way to include the .db file to my project? I've tried to read current directory and using |DataDirectory|, but all of those referred to the .exe file's active folder, and didn't work when i debugging since when debugging the .exe file have different directory than the project directory.

For a note, i'm using VS Community 2015 and System.Data.SQLite. Also i've tried added the .db file to Solution Explorer, but i can't seem to access through it.

m0s · Accepted Answer · 2016-08-22 07:44:47Z

4

Include your database file in your project. Set the type to Content, that will make sure the file is copied to your output directory. Use relative path in connection string.

answered Aug 22, 2016 at 7:44

m0s

4,2809 gold badges43 silver badges64 bronze badges

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

1 Comment

Shira Ishikawa Over a year ago

Ah, you're right! 4 days thinking about this and turns out only problem in properties, somehow i feel so silly. Thank you. I'm using "./res/mk_ii.db" as the relative path in connection string.

Collectives™ on Stack Overflow

How to add SQLite .db into C#.NET project

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related