System.Data.SQLite

There is no way to distinguish exception (constraint failed or others) through error code or something else. I have to check and parse returned messages to determine type of exception. E.g. I have some method that translates from a returned exception to my exception:

private Exception TranslateException(Exception e)
		{
			SQLiteException sqliteEx = e as SQLiteException;

			if (sqliteEx != null)
			{
				switch (sqliteEx.ReturnCode)
				{
					case SQLiteErrorCode.Constraint:
						if (sqliteEx.Message.EndsWith("may not be NULL"))
							return ErrorsProvider.GetException(ErrorType.NullNotAllowed, sqliteEx);
						if (sqliteEx.Message.EndsWith("foreign key constraint failed"))
							return ErrorsProvider.GetException(ErrorType.ForeignKeyViolation, sqliteEx);
						return ErrorsProvider.GetException(ErrorType.UniqueKeyDuplicate, sqliteEx);
					case SQLiteErrorCode.NotFound:
						return ErrorsProvider.GetException(ErrorType.ForeignKeyViolation, sqliteEx);
					case SQLiteErrorCode.Locked:
						return ErrorsProvider.GetException(ErrorType.Deadlock, sqliteEx);
				}
			}
			return null;
		}

It'd be nice to have a better ways than parse returned messages. Please provide ability to distinguish by error codes. Thanks.

I would like this option too. Now I am parsing the text of the message and I don't like so much this solution.