title: Cannot see changes in database without running manually the commit command
body: <p>I'm trying to save the data I'm inserting into a local Firebird database.</p>
  
  <p>I've tried running an sql command, in the C# code, containg <code>commit;</code> after inserting the data but it doesn't seem to work. The informations are sent but the database isn't saving them.</p>
  
  <p>This is the code I'm using for inserting the data.</p>
  
  <pre><code>FbConnectionStringBuilder csb = new FbConnectionStringBuilder
              {
                  DataSource = "localhost",
                  Port = 3050,
                  Database = @"D:\db\DBUTENTI.FDB",
                  UserID = "SYSDBA",
                  Password = "masterkey",
                  ServerType = FbServerType.Default
              };
  
              using (FbConnection myConn = new FbConnection(csb.ToString()))
              {
                  if (myConn.State == ConnectionState.Closed)
                  {
                      try
                      {
                          myConn.Open();
                          Console.WriteLine("CONNECTION OPENED");
                          string Id = txt_Id.Text;
                          string Utente = txt_User.Text;
                          string Password = txt_Password.Text;
                          FbCommand cmd = new FbCommand("insert into utenti(id,utente,password)values(@id, @utente, @password)", myConn);
                          cmd.Parameters.AddWithValue("id", Id);
                          cmd.Parameters.AddWithValue("utente", Utente);
                          cmd.Parameters.AddWithValue("password", Password);
                          cmd.ExecuteNonQuery();
                          myConn.Close();
                          Console.WriteLine("CONNECTION CLOSED");
                      }
                      catch (Exception exc)
                      {
                          Console.WriteLine(exc.Message);
                      }
                  }
              }
  </code></pre>
  
  <p>The code runs without any errors/exceptions, but I have to manually commit in the ISQL Tool to see the changes.</p>
  
  <p>Thanks to anyone who is willing to help.</p>