I've had the same issue before and resorted to using a query that does the insert then returns @@identity. You can do it without a full blown stored procedure and just using an SqlCommand, IIRC.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results