If you're using Entity Framework, and it's running ad-hoc SQL against the DB, no. Handle the error in your application and present to the user something meaningful.
If you have a stored procedure, use TRY... CATCH and RAISERROR
Many thanks for your reply