Do I need to set "ConnectionReset" parameter in the connection string when using isolation levels occasionally?
Probably the following allows you to use any isolation mode for your application:

BEGIN;
SELECT ... FOR UPDATE;   -- necessary if about to change a row
...
UPDATE ...;
UPDATE ...;
COMMIT;