Everyone is different, but I told my wife that if she insisted upon ending our marriage this way -- by having an affair, and lying to everyone about it and refusing to try and work on the marriage -- that I had absolutely zero interest in being her friend, much less her BEST friend.
This seemed to shake her, and she told me later that it played a huge part of her deciding to try and reconcile.
