title: Insert to MySql from c# failed
body: <p>I have a problem with a MySql insert ... this is my Code:</p>
  
  <pre><code>    public class struc
      {
          public string Product;
          public string Underproduct;
          public string Version;
      }
  
      static void DatabaseConection(List&lt;struc&gt; Data)
      {
      string connString = "right connection info";
          string insertQuery = "Insert into freigabedaten (produktname,unterprodukt,version,freigabestatus) values (productInfo.Product,productInfo.Underproduct,productInfo.Version,'4')";
          MySqlConnection conn = new MySqlConnection(connString);
  
          conn.Open();
  
          foreach (var productInfo in Data)
          {
                  MySql.Data.MySqlClient.MySqlCommand Command = new MySql.Data.MySqlClient.MySqlCommand(insertQuery, conn);
  
                  try
                  {
                      Command.ExecuteNonQuery();
                  }
                  catch (Exception)
                  {
                      throw;
                  }
          });
  
          conn.Close();
      }
  </code></pre>
  
  <p>But i get always the Exeption: </p>
  
  <blockquote>
    <p>MySql.Data.MySqlClient.MySqlException: "Unknown column
    'productInfo.Product' in 'field list'"</p>
  </blockquote>
  
  <p>My Database table structure is: 
  <a href="https://i.stack.imgur.com/5gh7H.png" rel="nofollow noreferrer">Databasetablescreen</a></p>
  
  <p>can someone help me please?</p>