How do I check in SQLite whether a database exists C#

Question

I'm currently programming an app in C# and using sqlite as an embedded database. I have got my app to create a new database on start-up, but how do I get it to check if the database exists? If it does exist how do I get it to use it, and if not how to create a new database?

This is what i have so far:

private void MainWindow_Loaded(object sender, EventArgs e) {     SQLiteConnection sqlite_conn;     SQLiteCommand sqlite_cmd;     bool newdb = false;     if (newdb == true)     {         sqlite_conn = new SQLiteConnection("DataSource=database.db;Version=3;");         sqlite_conn.Open();         MessageBox.Show("31");     }     else     {         sqlite_conn = new SQLiteConnection("Data Source=database.db;Version=3;New=True;Compress=True;");         sqlite_conn.Open();             sqlite_cmd = sqlite_conn.CreateCommand();             sqlite_cmd.CommandText = "CREATE TABLE Client (id integer primary key, Title  varchar(100),Name  varchar(100),Surname  varchar(100),Dateofbirth DateTime , Propertyname varchar(100),Moveindate DateTime,Relationship varchar(100),Spouse  varchar(100),Gender  varchar(100), spTitle  varchar(100),SpouseName  varchar(100),SpouseSurname  varchar(100),spDateofbirth DateTime ,spRelationship varchar(100),spSpouse  varchar(100),spGender  varchar(100));";         sqlite_cmd.ExecuteNonQuery();     }         sqlite_conn.Close();     MessageBox.Show("dasdas");     } 

Answer 1

How about:

if(File.Exists("database.db")) 

Edit: Changed path to match source in original code.

Answer 2

public async Task<bool> IsDbExists(string fileName)     {         try         {             var item = await ApplicationData.Current.LocalFolder.GetFileAsync(fileName);             var db = new SQLiteConnection(DbHelper.DBPATH);             var tb1 = db.GetTableInfo("Domain");             var tb2 = db.GetTableInfo("Account");             var tb3 = db.GetTableInfo("Product");             var tb4 = db.GetTableInfo("Review");             if (item == null || tb1.Count == 0 || tb2.Count == 0 || tb3.Count == 0 || tb4.Count == 0)             {                 return false;             }             else             {                 return true;             }         }         catch         {             return false;         }     } 

This is one of the solution