C# SQL kommandoer

HEj

Hvordan virker det entlig med at sende SQL kommandoer ?? Gøres det altid via en String??

JEg skal have lavet autoincrement af min Key colonne, men hvordan gør jeg det?? jeg har lavet nedenstående kode.


class DatabaseWrite
    {
   
        OleDbConnection MyConnection = null;
        private void Autoinc()
        {
          CREATE TABLE LOGTABEL
        (
            Key PRIMARY KEY AUTOINCREMENT,
            b varchar(255) NOT NULL,
            c varchar(255),
            d varchar(255),
            e varchar(255),
            f varchar(255),
            g varchar(255),
            h varchar(255),
            i varchar(255),
            j carchar(255)
        )
        }
        public void DatabaseConnection(int a,String b, String c, String d, String e, String f, String g, String h, String i, String j)
        {

            String Log = "INSERT INTO LOGTABEL VALUES (" + a + "," + "'" + b + "'" + "," + "'" + c + "'" + "," + "'" + d + "'" + "," + "'" + e + "'" + "," + "'" + f + "'" + "," + "'" + g + "'" + "," + "'" + h + "'" + "," + "'" + i + "'" + "," + "'" + j + "')";
            MessageBox.Show(Log);
            MyConnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0; User Id=; Password=; Data Source=C:\LogDatabase.mdb");
            MyConnection.Open();
            OleDbCommand odbcom = new OleDbCommand(Log, MyConnection);
       
            int i=odbcom.ExecuteNonQuery();
            MessageBox.Show(i.ToString());
            MyConnection.Close();
           
        }
    }