Update: I tired to use CAUSALITY_TRACKING, but I am not familiar with it too much and I believe I would have had to add another event like sql_statement_starting and I couldn't figure out how to filter it.
Looking back through requests, though... I found this little gem:
(@0 char(3),@1 decimal(6,2))INSERT [dbo].[TowBatch]([TowBatchStatus], [GeneratedRoute], [Distance])
VALUES (@0, NULL, @1)
SELECT [TowBatchID]
FROM [dbo].[TowBatch]
WHERE @@ROWCOUNT > 0 AND [TowBatchID] = scope_identity()
I believe this to be the culprit. How I love Entity Framework!
Jared
CE - Microsoft