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

79,642
10
69
121

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