SQLite 3 ÔÓ¼Ç

1¡¢ÈçºÎµÃµ½×îºó²åÈëÏîµÄ×Ô¶¯Ôö³¤IDÖµ£¿ ¶ÔÓ¦µÄC#´úÂë¶ÎÈçÏ£º

using (SQLiteConnection cn = new SQLiteConnection (¡°data source = Test.db¡±))
{
      cn.Open ();

      SQLiteCommand cmd = new SQLiteCommand ("INSERT INTO TestTable VALUES (NULL, ¡®TestString¡¯); SELECT last_insert_rowid ()",  cn);
      int NewID = Convert.ToInt32 (cmd.ExecuteScalar ());

      cn.Close ();
}

NewIDֵΪ0±íʾ²åÈëδ³É¹¦¡£ 2¡¢ÈçºÎ½«²éѯ½á¹ûÖ±½Ó±£´æµ½±í£¿ ±£´æµ½±í֮ǰ£¬Ê×ÏȽ«±íÇå¿Õ¡£¶ÔÓ¦µÄC#´úÂë¶ÎÈçÏ£º

using (SQLiteConnection cn = new SQLiteConnection (¡°data source = Test.db¡±))
{
      cn.Open ();

      SQLiteCommand cmd = new SQLiteCommand ("DELETE from TestTable; INSERT INTO TestTable SELECT ID, Name from TestTable",  cn);
      cmd.ExecuteNonQuery ();

      cn.Close ();
}