title: Access Database not updating with OleDb
body: <p>Here's my update method</p>
  
  <pre><code>public void Update(string query, List&lt;OleDbParameter&gt; parameters)
          {
              OleDbCommand cmd = new OleDbCommand();
              OleDbTransaction transaction = null;
              query = "UPDATE " + query;
  
  
              foreach (OleDbParameter parameter in parameters)
              {
                  cmd.Parameters.Add(parameter);
              }
  
              this._Connect();
  
              transaction = _connection.BeginTransaction();
              cmd.Connection = _connection;
              cmd.CommandText = query;
              cmd.Transaction = transaction;
              cmd.Prepare();
              int linesUpdated = cmd.ExecuteNonQuery();
              transaction.Commit();
  
              this._Disconnect();
  
          }
  </code></pre>
  
  <p>Full class </p>
  
  <pre><code> public class DBAdapter
      {
          private OleDbConnection _connection;
  
          private void _Connect()
          {
              this._connection = new OleDbConnection();
              _connection.ConnectionString = ConfigurationManager.ConnectionStrings[1].ConnectionString;
              _connection.Open();
          }
  
          private void _Disconnect()
          {
              _connection.Close();
          }
  
  
          public void Update(string query, List&lt;OleDbParameter&gt; parameters)
          {
              ...
          }
  
      }
  </code></pre>
  
  <p>When I launch my application, this works well : </p>
  
  <ol>
  <li>I select user by id</li>
  <li>I store data in an object, I display the user's name. Then I modify user's name property. </li>
  <li>I save it to database</li>
  <li>I select again the same user</li>
  <li>I display again the user's name : value displayed was changed, so the update method works. </li>
  </ol>
  
  <p>But when I close my app and launch it again, It displays me the old value, then the new value, like I didn't make any changes. What's wrong with my code ?  </p>
  
  <p><strong>EDIT :</strong> I found the problem. My .mdb file is located in //Assets/Database/, when I run my app, the file is copied in bin/Debug/assets/Databases/. 
  How should I update the original file ? </p>
  
  <p><strong>EDIT (2) :</strong> Solved! <a href="https://stackoverflow.com/questions/4677861/can-i-commit-changes-to-actual-database-while-debugging-c-sharp-in-visual-studio">Can I commit changes to actual database while debugging C# in Visual Studio?</a></p>