C# how to connect WPF and SQLITE database easiest way

Question

New to wpf and sqlite. I just want an internal database for my project. I want this project to be able to used by others so I cannot use mysql as a database. So I search for internal databases and decided to try sqlite. Im finding tutorial but they are really confusing. I'm familiar in database I know the queries but now I just need to know what are the necessary things to setup to start the connection between WPF and sqlite. Below is my code(I create a different class for my sqlite connection):

 sqlite class

 using System.Data.SQLite;
 namespace StartMyApps
 {
     class StartMyAppDb_sqlite
     {
       public SQLiteConnection myConn;
       public SQLiteCommand myComm;
       public SQLiteDataReader myReader;

       public void openConnection(string query)
       {
         myConn = new SQLiteConnection("Data Source=StartMyApplication.sqlite;Version=3;");
         myConn.Open();
         myComm = new SQLiteCommand(query, myConn);
         myComm.ExecuteNonQuery();
         myReader = myComm.ExecuteReader();
       }      
    }
 }

 Main class (has a button to trigger the connection and will pass a query)

   private void hide_btn_Click(object sender, RoutedEventArgs e)
    {
        sqliteDB.openConnection("select *from application where app_id='1' and app_name='chrome.exe';");

        bool hasAccount = false;
        while (sqliteDB.myReader.Read())
        {
            hasAccount = true;
        }

        if (hasAccount == false)
        {
            MessageBox.Show("Logged in");
        }

        else if (hasAccount == true)
        {
            MessageBox.Show("Username invalid");
        }
    }

With this code I got an error says

"An unhandled exception of type 'System.DllNotFoundException' occurred in System.Data.SQLite.dll Additional information: Unable to load DLL 'SQLite.Interop.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)"

Please help. Any help will be much appreciated THANKS!

Community · Accepted Answer · 2017-05-23 10:29:50Z

1

I think this is what your looking for: Unable to load DLL 'SQLite.Interop.dll'

Assuming you have:

SQLite installed (correct version for windows)
Appropriate references

edited May 23, 2017 at 10:29

CommunityBot

11 silver badge

answered Feb 20, 2017 at 4:59

James Nelson

78110 silver badges15 bronze badges

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

Comments

Dev Kumar · Accepted Answer · 2017-02-20 04:58:16Z

0

Follow below steps:

Add 2 folders in the project and name it x64 and x86.
Add SQLite.interop.dll for x64 and x86 respectively(google for the same)
In SQLite.interop.dll properties, set "Build Action" --> Content and "Copy to Output directory" -> Copy Always/Copy if newer.

answered Feb 20, 2017 at 4:58

Dev Kumar

761 silver badge11 bronze badges

2 Comments

Joseph Reyes Over a year ago

I don't have sqlite.interop.dll. Where is the right file in the internet to download?

Dev Kumar Over a year ago

Check the package directory when you install from Nuget. It will have the SQLite.interop.dll

Collectives™ on Stack Overflow

C# how to connect WPF and SQLITE database easiest way

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related