retrieving identity upon insert using a strongly typed data set

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Serge Wautier - 14 Mar 2008 22:54 GMT

Env.: SqlCE 3.5, Windows Mobile 6

Hi All,

I use .xsd based strongly typed data sets to access my DB.
Is it possible to retrieve @@identity from an Insert method?

TIA,

Serge.

Reply to this Message

William Vaughn - 17 Mar 2008 17:51 GMT

Not with SQLCe. It can only process one operation at a time. It is possible
to use SELECT @IDENTITY post-INSERT however. Perhaps that's what you meant
in the first place...

Signature

__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________

> Env.: SqlCE 3.5, Windows Mobile 6
>
[quoted text clipped - 6 lines]
>
> Serge.

Reply to this Message

Serge Wautier - 19 Mar 2008 17:10 GMT

William,

Thanks for your reply.

> Not with SQLCe. It can only process one operation at a time. It is
> possible to use SELECT @IDENTITY post-INSERT however. Perhaps that's what
[quoted text clipped - 10 lines]
>>
>> Serge.

Reply to this Message