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? — Hardik Gondalia
– Hardik Gondalia, Commented Aug 17, 2017 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? — Hardik Gondalia
– Hardik Gondalia, Commented Aug 17, 2017 at 13:50

Zohar Peled · Accepted Answer · 2017-08-17 13:52:04Z

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, 2017 at 13:52

Zohar Peled

82.9k11 gold badges79 silver badges134 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Hardik Gondalia Over a year ago

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?

Zohar Peled Over a year ago

Not that I know of.

David Browne - Microsoft Over a year ago

Confirmed. The error returned from SQL Server contains that string, and there is no built-in API for extracting data from it.

Collectives™ on Stack Overflow

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

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related