I m using Entity Framework with stored procedures for inserting/updating/deleting entities.
I m的工作是与FO/LIFO方法进行库存管理;这些加插/更新/删除进行几次检查并可能失败(有时是失败)。
The problem is I want to report back to .NET what went wrong and why. How can I do it?
目前,我喜欢这样作:
BEGIN --rollback
ROLLBACK TRAN
RAISERROR (N There s not enough items in stock. , -- message
16, -- severity
1) -- state
END;
我总是拿到“MSDTC错误”——“基本供应商在列入清单后失败”