禁用SQLITE自动数据库创建-C＃

Question

我成功使用一种尝试 - 捕获方法来测试C＃与通用数据库的连接。 但是，在SQLite的情况下，当未检测到数据库时，它会创建一个新的，这在我的情况下是不需要的。 “当您连接到不存在的SQLITE数据库文件时，SQLITE会自动为您创建新数据库

SQLiteDataAdapter ad;
        DataTable dt = new DataTable();
        try
        {
            sqlite = new SQLiteConnection("Data Source=C:/Users/SKUL/Desktop/db/PatHist.db");
            SQLiteCommand cmd;
            sqlite.Open();  //Initiate connection to the db
            cmd = sqlite.CreateCommand();
            //-----------------
          
            picConnectionStatus.Image = Properties.Resources.icons8_database_view_64;
            lblConnectionEstablished.Text = "Connection Established";

            sqlite.Close();
           
        }
        catch (Exception ex)
        {
            picConnectionStatus.Image = Properties.Resources.icons8_delete_database_64;
            lblConnectionEstablished.Text = "Connection Error";
            lblConnectionEstablished.ForeColor = System.Drawing.Color.Red;
           
        }

。

Answer 1

在@rafael的建议之后，我检查了文件的存在。解决这个问题。

if (System.IO.File.Exists(@"C:\Users\SKUL\Desktop\db\nPatHist.db"))
            {
               sqlite = new SQLiteConnection("Data Source=C:\\Users\\SKUL\\Desktop\\db\\PatHist.db");
                SQLiteCommand cmd;
                sqlite.Open();  //Initiate connection to the db
                cmd = sqlite.CreateCommand();
                //-----------------

                picConnectionStatus.Image = Properties.Resources.icons8_database_view_64;
                lblConnectionEstablished.Text = "Connection Established";


                sqlite.Close();
            }