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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability