C#手动为数据库自增字段插入编号

C#手动为数据库自增字段插入编号

                string sqlstr = "SET IDENTITY_INSERT t1 ON;";
                lists.Add(sqlstr);
                sqlstr = "INSERT INTO t1       (id, name) VALUES ("+i.ToString()+", '" + i.ToString()+"');";
                lists.Add(sqlstr);
                sqlstr = "set identity_insert t1 off;";
                lists.Add(sqlstr);
                da.SqlCeExecuteNonQuery(lists);

SqlCeExecuteNonQuery

 public void SqlCeExecuteNonQuery(List<string> lists)
        {
            SqlCeConnection conn = new SqlCeConnection();
            SqlCeCommand comm = null;
            try
            {
                conn.ConnectionString = PDAConnectionLocStr;
                conn.Open();
                comm = new SqlCeCommand("", conn);
                for (int i = 0; i < lists.Count; i++)
                {
                    comm.CommandText = lists[i];
                    comm.ExecuteNonQuery();
                }
            }
            catch (SqlCeException ex)
            {
 
            }
            finally
            {
                conn.Close();
                conn.Dispose();
                comm.Dispose();
            }
        }

插入自增主键需要防止编号冲突