title: C# Command.ExecuteNonQuery(); Error Incorrect syntax near 'VALUE'
body: <p>I've tried a ton of different things with this, I keep getting the same error on my </p>
  
  <pre><code>cmd.ExecuteNonQuery();
  </code></pre>
  
  <p>It throws me this.</p>
  
  <blockquote>
    <p>An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll
    Additional information: Incorrect syntax near 'VALUE'.</p>
  </blockquote>
  
  <p>Code:</p>
  
  <pre><code>using System;
  using System.Collections.Generic;
  using System.Linq;
  using System.Text;
  using System.Threading.Tasks;
  using System.Data;
  using System.Data.SqlClient;
  using System.Configuration;
  
  namespace Server_Testing
  {
      class Program
      {
          static void Main(string[] args)
          {
              string conString = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString;
              SqlConnection con = new SqlConnection(conString);
  
              con.Open();
  
              SqlCommand cmd = new SqlCommand("INSERT INTO Test (Id, Name) VALUE (@Id, @Name)", con);
  
              if(con.State == ConnectionState.Open)
              {
                  //cmd.Parameters.Add(new SqlParameter("@Id", 1));
                  //cmd.Parameters.Add(new SqlParameter("@Name", "MyName"));
                  //cmd.Parameters.AddWithValue("@Id", 1);
                  //cmd.Parameters.AddWithValue("@Name", SqlDbType.NVarChar).Value = "MyName";
                  cmd.Parameters.AddWithValue("@Id", 1);
                  cmd.Parameters.AddWithValue("@Name", "Myname");
  
                  cmd.ExecuteNonQuery();
              }
          }
      }
  }
  </code></pre>
  
  <p>As you can see from the comments, I've tried some things, but non of if works for me, I cant seem to get it right, it must be the SQL string, but that should be fine as well.. Can anyone help me here?</p>