using LAST_INSERT_ID without being provider-specific

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for universal data access
Post Reply
linarms
Posts: 1
Joined: Tue 23 Aug 2005 01:33

using LAST_INSERT_ID without being provider-specific

Post by linarms » Tue 23 Aug 2005 01:34

Hi,

I'm considering purchasing unidirect.net but its usefulness will be limited if I can't get the last inserted primary key back in a generic way. Obviously the query for MySQL is SELECT LAST_INSERT_ID() and for SqlServer it's SELECT @@IDENTITY, but I don't want my application code to even need to check which provider it's using.

Any ideas?

Cheers,

Luke

Oleg
Devart Team
Posts: 264
Joined: Thu 28 Oct 2004 13:56

Post by Oleg » Wed 31 Aug 2005 08:11

UniDirect does not process SQL statements for different SQL servers. UniDirect just serves to provide universal data access. In the next versions we plan to work on this issue.

Post Reply