title: SQLite Error: no such table
body: <p>I use System.Data.SQLite to work with my database. Here is how I've created tables:</p>
  
  <pre><code>CREATE TABLE spare_samples (
      sampleId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
      sampleNr INTEGER UNSIGNED UNIQUE NOT NULL,
      sampleName VARCHAR(255) UNIQUE NOT NULL COLLATE NOCASE,
      spareState VARCHAR(255) NULL,
      sides VARCHAR(255) NULL,
      notes TEXT,
      dispatch VARCHAR(32) NULL,
      ebayId VARCHAR(255) NULL
  );
  
  CREATE TABLE spare_sample_photo_examples (
      exampleId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
      exampleType VARCHAR(32) NOT NULL,
      exampleImage VARCHAR(128) UNIQUE NOT NULL COLLATE NOCASE,
      exampleTitle VARCHAR(128) NULL,
      exampleDescr TEXT,
      exampleOrder INTEGER NOT NULL DEFAULT 0,
      sampleId INTEGER NOT NULL,
      FOREIGN KEY (sampleId)
          REFERENCES spare_samples(sampleId)
          ON UPDATE CASCADE ON DELETE CASCADE
  );
  </code></pre>
  
  <p>To add new row I'm using this:</p>
  
  <pre><code>SQLiteConnection conn = new SQLiteConnection(LoadForm.connString);
  SQLiteCommand command = conn.CreateCommand();
  command.CommandText = "Insert Into spare_sample_photo_examples (exampleType, exampleImage, exampleTitle, exampleDescr, exampleOrder, sampleId) values('"
                  + spareSamplePhotoExampleToUpdate.exampleType + "', '"
                  + spareSamplePhotoExampleToUpdate.exampleImage + "', '"
                  + spareSamplePhotoExampleToUpdate.exampleTitle + "', '"
                  + spareSamplePhotoExampleToUpdate.exampleDescr + "', "
                  + spareSamplePhotoExampleToUpdate.exampleOrder + ", "
                  + spareSamplePhotoExampleToUpdate.sampleId + "); Select last_insert_rowid();";
  Clipboard.SetText(command.CommandText);
  try
  {
      conn.Open();
  }
  catch (Exception ex)
  {
      MessageBox.Show(ex.Message, "Connection Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
      return;
  }
  
  try
  {
      spareSamplePhotoExampleToUpdate.exampleId = Convert.ToInt16(command.ExecuteScalar());
  }
  catch (Exception ex)
  {
      MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
      return;
  }
  finally
  {
      if (conn.State.ToString() != "Closed")
      {
          conn.Close();
      }
  }
  </code></pre>
  
  <p>And spareSamplePhotoExampleToUpdate is the instance of object:</p>
  
  <pre><code>public class SpareSamplePhotoExample
  {
      public int exampleId { get; set; }
      public string exampleType { get; set; }
      public string exampleImage { get; set; }
      public string exampleTitle { get; set; }
      public string exampleDescr { get; set; }
      public int exampleOrder { get; set; }
      public int sampleId { get; set; }
  }
  </code></pre>
  
  <p>I don't actually know what's wrong with this code, with me and anything else, but when I got generated code from app and ran it in the FF SQLite Manager it was executed successfully. Also I have read another similar questions but all of them concern android and ios. </p>
  
  <pre><code>Insert Into spare_sample_photo_examples (exampleType, exampleImage, exampleTitle, exampleDescr, exampleOrder, sampleId) values('image', 'images\c438ldpuojpywln1.jpg', '', '', '0', '32'); Select last_insert_rowid();
  </code></pre>
  
  <p>Thanks a lot for any help.</p>
  
  <p><strong>Comments:</strong></p>
  
  <p>This code checks database at start:</p>
  
  <pre><code>SQLiteCommand command = conn.CreateCommand();
  command.CommandText = "SELECT count( name ) FROM sqlite_master WHERE (type = 'table' AND name = 'cars')"
                  + " OR (type = 'table' AND name = 'makes')"
                  + " OR (type = 'table' AND name = 'models')"
                  + " OR (type = 'table' AND name = 'spares')"
                  + " OR (type = 'table' AND name = 'spare_brands')"
                  + " OR (type = 'table' AND name = 'spare_samples')"
                  + " OR (type = 'table' AND name = 'export_templates')"
                  + " OR (type = 'table' AND name = 'users')"
                  + " OR (type = 'table' AND name = 'user_meta')"
                  + " OR (type = 'table' AND name = 'spare_sample_photo_examples')";
              if (Convert.ToInt16(command.ExecuteScalar().ToString()) != 10)
              {
                  //something like exit with some stuff
              }
  </code></pre>
  
  <p><strong>And definitive update for my problem.</strong> As you can see I have another tables in database, so before I start adding photo examples, all functions works properly. After I get error, I can't do anything, which involves database operations. All operations return the same error, but for their tables. </p>