约SQLite的查询

Question

我使用在SQLite &我使用下面的查询 -

INSERT INTO Contact(FirstName, LastName, MobileNumber, IsArchive) VALUES('mina', 'Ambani', '9874587458', 1); SELECT last_insert_rowid() AS 'Identity'; 

此查询插入记录&也给身份列的最后插入行的ID在我的表，但最初它产生错误 -

The following errors were encountered while parsing the contents of the SQL pane: 

Unable to parse query text 

如何移除此错误？

谢谢。

Answer 1

Sqlite似乎在一个查询中不支持多个SQL语句。运行一个单独的后续查询。类似于

SQLiteCommand IDCmd = new SQLiteCommand("Select last_insert_rowid();", conn); 
cmd.ExecuteNonQuery(); // EXECUTE INSERT HERE 
long id = (long)IDCmd.ExecuteScalar(); 

此示例中缺少连接打开/关闭和错误处理。