How to get Column name in exception for constraints violation in c#

Question

I have constraints over currency field that negative value is not acceptable. Constraints is all working fine and I am getting error when constraints violated as per below.

Unable to update row. Reason: The UPDATE statement conflicted with the CHECK constraint "CK_Product_StandardCost". The conflict occurred in database "AdventureWorksLT", table "SalesLT.Product", column 'StandardCost'. The statement has been terminated.

I am getting this error in catch block because I am updating incorrect data in table.

What I want is to get Column name on particular this constraint fires. Here it would be : StandardCost. Is there any way that I can find column name in my C# code?

@Rahul - You mean I need to fetch from exception message by some logic? — Ubiquitous Developers, Aug 17 '17 at 13:47
even thought I fetch from the string, what could be the best logic for it? I can think about substring text between last '' (single quote pair). Is it best solution? — Ubiquitous Developers, Aug 17 '17 at 13:50

score 2 · Answer 1 · answered Aug 17 '17 at 13:52

2

A simple Substring with IndexOf on the exception message:

var message = ex.Message;
var column = message.Substring(message.IndexOf("column '") + 8, message.IndexOf("'", message.IndexOf("column '") + 9) - message.IndexOf("column '") - 8);

answered Aug 17 '17 at 13:52

Zohar Peled

76,346
9
62
111

this is working. But is there anyway to get column name in exception stack? and no need to do this kind of manipulation over message? – Ubiquitous Developers Aug 17 '17 at 14:01
Not that I know of. – Zohar Peled Aug 17 '17 at 14:03
3

Confirmed. The error returned from SQL Server contains that string, and there is no built-in API for extracting data from it. – David Browne - Microsoft Aug 17 '17 at 14:56

How to get Column name in exception for constraints violation in c#

1 Answers1