I'm using the BCS for reading/writing to a database. It all works well but a problem I have is that the DB uses various constraints to enforce data integrity.
If someone e.g., tries to insert some data which violates these constraints (e.g., unique key) then the DB correctly rejects it - but unfortunately SP just displays an ugly generic "it broke" message. The actual error (e.g., cannot insert duplicate key) is in the ULS.
Is there any way to pass the error message back to SP for display in the dialog so the user knows what happened?