>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.


You cannot batch calls to sqlce. the sample code shows how to do this..