• 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