EntityFramework.Exceptions simplifies this by handling all the database specific details and throwing different exceptions. All you have to do is inherit your DbContext from ExceptionProcessorContext and handle the exception(s) such as UniqueConstraintException, CannotInsertNullException, MaxLengthExceededException, NumericOverflowException you need.