using (SQLiteConnection connection = new SQLiteConnection("Data Source=test.db"))
            {
                connection.Open();
                using (SQLiteTransaction tran = connection.BeginTransaction())
                {
                    using (SQLiteCommand cmd = connection.CreateCommand())
                    {
                        cmd.CommandText = "DELETE FROM test_tbl WHERE id=@id";
                        cmd.Parameters.Add("@id", DbType.UInt32);
                        cmd.Parameters[0].Value = id;
                        cmd.Prepare();
                        cmd.ExecuteNonQuery();
                    }
                    tran.Commit();
                }
            }