如何捕捉SQL异常在微风js

Question

我在HotTowel模板有一个问题。我怎么能捕捉sql重复唯一键值异常在微风js和显示?

我的控制器:

[BreezeController]
[System.Web.Http.Authorize]
public partial class DataServiceController : ApiController
{
[System.Web.Http.HttpPost]
public SaveResult SaveChanges(JObject saveBundle)
{
SaveResult result;
try
{
result = this._contextProvider.SaveChanges(saveBundle, null);
}
catch (Exception ex)
{
throw ex;
}
return result;
}
}

Answer 1

当数据库返回该错误时，很难将其与引起问题的实体相匹配，因为MSSQL不会告诉您太多信息。可以这样做:

catch (Exception ex)
{
// if a "duplicate key" exception, extract the table name
var match = Regex.Match(ex.Message, "duplicate key.* object '([^']*)'");
if (match.Success)
{
var table = match.Groups[1].Value; // dbo.Customer
var entityType = table.Split('.').Last(); // Customer
throw new HttpException(409, "Duplicate key saving entity " + entityType, ex);
}
throw ex;
}

以便您得到409 Conflict响应代码和引起问题的实体类型。