Call SQL Server stored procedure from C# and determine commit or rollback

[MMock]

CREATE PROCEDURE xsp_DeleteThis
	@pk int
AS
BEGIN

SET XACT_ABORT ON

	BEGIN TRANSACTION
		
		UPDATE tblX SET ... WHERE pk = @pk
			
		UPDATE tblY SET ... WHERE pk = @pk
		
		UPDATE xtblZ SET ... WHERE pk = @pk

	COMMIT TRANSACTION

END