How to handle Exception and display appropriate message using C#?

Question

I am working in MVC3 Dot Net project Using EF.

We are catching all the Exceptions in an object of Exception (i.e ex) From this how can I get (or filter) SQlExceptions and I like to show the meaningful message.

facing problem : I am not getting System.Data.UpdateException class

Brijesh Mishra · Accepted Answer · 2011-12-29 06:53:05Z

1

loop through exception/inner excetion and check if(ex is SQlException) { } Maybe you missed adding reference to System.Data.Entity so you dont see System.Data.UpdateException class

edited Dec 29, 2011 at 6:53

answered Dec 29, 2011 at 6:45

Brijesh Mishra

2,7581 gold badge21 silver badges36 bronze badges

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

2 Comments

Ranjit Over a year ago

Thank u friend i got solution for System.Data.UpdateException

Ivo Over a year ago

If the answer was the solution, please mark it as the definitive :)

Adam Tuliper · Accepted Answer · 2011-12-29 14:59:33Z

1

You shouldn't be catching Exception first (or at all unless you are specifically doing something with all exceptions)

If you want only UpdateExceptions, then you should only catch that exception. This catch should be above any other handlings that are more generic, for example

try
{
}
catch(System.Data.UpdateException ex)
{

}
catch(Exception ex) //optionally 
{
///less generic handling
}

Also consider for general logging ELMAH http://code.google.com/p/elmah/

answered Dec 29, 2011 at 14:59

Adam Tuliper

30.2k4 gold badges56 silver badges71 bronze badges

2 Comments

Ranjit Over a year ago

you appose is very nice but want if (e.Exception != null) { if (e.Exception is SqlException) { SqlException sqlExcep = (SqlException)e.Exception; switch (sqlExcep.Number) { case SqlExceptionNumber.ForeignKeyConstraint: this.ExceptionDetails.Text += "Error : Foreign Key Violation.The Contract cannot be inserted."; break; case SqlExceptionNumber.UniqueKeyConstraint:

Adam Tuliper Over a year ago

Post some code above I'm not fully understanding. You want to check if e.Exception is of that type rather than a thrown exception?

Collectives™ on Stack Overflow

How to handle Exception and display appropriate message using C#?

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related