Zend Framework, MSSQL 2008 R2, PDO -> insert lastInsertId?

Question

PHP

How to get lastInsertId if doing in zend

$model-&gt;insert(array(<br/>
 'data1' =&gt; $data1,<br/>
 'data2' =&gt; $data2,<br/>
));<br/>

$model->lastInserId(); - does not work…

Answer 1

zend-framework-community.634137.n4.nabble.com/mssql-pdo-lastInsertID-with-a-stored-procedure-td672685.html

Answer 2

php.net/manual/en/pdo.lastinsertid.php

Note:
This method may not return a meaningful or consistent result across different PDO drivers, because the underlying database may not even support the notion of auto-increment fields or sequences.

after such a notice in the documentation, the first thing that comes to mind is the need to take care of “your own, reliable” tool.
as an option - a comment from php.net/manual/en/pdo.lastinsertid.php - why not a workaround?
alternatively you can use

select IDENT_CURRENT('tableName');

or

select SCOPE_IDENTITY();

after a successful insert.
and, of course, don't forget about sessions and scope to get exactly what you need ( msdn.microsoft.com/en-us/library/ms175098.aspx )