Unable to set foreign_keys pragma

[ghost]

I don't know why, but it just won't work for me. Am I doing something wrong?

using (var conn = new Microsoft.Data.Sqlite.SqliteConnection("Filename=./Data/database.db"))
{
  conn.Open();
  using (var tr = conn.BeginTransaction())
    {
      var com = conn.CreateCommand();
      com.CommandText = "PRAGMA foreign_keys = 1";
      com.ExecuteNonQuery();

      var com2 = conn.CreateCommand();
      com2.CommandText = "PRAGMA foreign_keys";
      await ReplyAsync(com2.ExecuteScalar().ToString());

      tr.Commit();
    }
}

[bricelam]

Looks like you figured it out. For others: PRAGMA foreign_keys doesn't work inside a transaction.