Hi everybody,

I have Orders Table (PK Guid, OrderDate) I also added identity column to this table (though this change was not yet reflected in my DS).

Now, how can I add a new method to my TableAdapter to return both GUID and ID for my insert

(which I suppose should be insert into Orders (OrderDate) values (Getdate())

I need to return back SCOPE_IDENTITY() as well as NewID(). Or at least NewID() that I'm putting there as ID of the order may not be that important, though I may want to display it.

I can not use SP as it's SQL Server CE.

Appreciate your ideas.