INSERT语句后的@@ IDENTITY始终返回0

我需要一个在数据库上执行INSERT语句并返回Auto_Increment主键的函数。我有以下C＃代码，但是，尽管INSERT语句运行正常（我可以看到数据库中的记录，但PK正确生成并且行== 1），id值始终为0。关于可能发生的事情的任何想法错误？

public int ExecuteInsertStatement(string statement)
{
    InitializeAndOpenConnection();
    int id = -1;


    IDbCommand cmdInsert = connection.CreateCommand();
    cmdInsert.CommandText = statement;
    int rows = cmdInsert.ExecuteNonQuery();

    if (rows == 1)
    {
        IDbCommand cmdId = connection.CreateCommand();
        cmdId.CommandText = "SELECT @@Identity;";
        id = (int)cmdId.ExecuteScalar();
    }

    return id;
}
private void InitializeAndOpenConnection()
{
    if (connection == null)
        connection = OleDbProviderFactory.Instance.CreateConnection(connectString);

    if(connection.State != ConnectionState.Open)                 
        connection.Open();
}

为了回答这些问题，我尝试了：

public int ExecuteInsertStatement(string statement, string tableName) { InitializeAndOpenConnection(); int id = -1; IDbCommand cmdInsert = connection.CreateCommand(); cmdInsert.CommandText = statement + ";SELECT OID FROM " + tableName + " WHERE OID = SCOPE_IDENTITY();"; id = (int)cmdInsert.ExecuteScalar();

    return id;
}

但是我现在收到错误“ SQL语句结束后找到字符”

我正在使用具有OleDb连接，Provider = Microsoft.Jet.OLEDB.4.0的MS Access数据库

问题来源于stack overflow