I can do this if I leave the Entity's Insert method as 'Use Runtime' and have it deal with the inserts directly, but I need to use an SP.
I have tried to simply return the @@Identity from sql server and then assign this to the ID but this causes a change notification and LinqToSql thinks it has changed, even though it's just the ID.
So basically I need a way of assigning the primary key on inserts via an sp, without it triggering the change notification.
Is this possible, if so how?
thanks.