Executing Query
suggest changeusing (SQLiteConnection conn = new SQLiteConnection(@"Data Source=data.db;Pooling=true;FailIfMissing=false"))
{
conn.Open();
using (SQLiteCommand cmd = new SQLiteCommand(conn))
{
cmd.CommandText = "query";
using (SqlDataReader dr = cmd.ExecuteReader())
{
while(dr.Read())
{
//do stuff
}
}
}
}
Note: Setting FailIfMissing
to true creates the file data.db
if missing. However, the file will be empty. So, any required tables have to be recreated.
Found a mistake? Have a question or improvement idea?
Let me know.
Table Of Contents