I've been around the block with this one.
I've been in a relationship and escorted in private. I look back with regret. The job meant more to me than he did and how I behaved within the relationship demonstrated that. I held back as I knew ultimately it was a dead end. He didn't deserve to be lied to given that I was putting his sexual health at risk.
I have been in a relationship in which my other half knew. I struggled to trust him as I was always waiting for vengeance. I felt that it lessened our relationship but that was the dynamic in that particular relationship.
I have also been in the other woman with a married man who had been a client. He knew what I did and got very involved. It was nice to be able to be honest with someone and not feel guilty but again, it was always going to be a dead end relationship.
I have left the job for someone I loved the bones of and was honest about my past and he accepted it. He loved my stories.
I have found that I just can't mix the two and be at peace with it within myself. It really is an individual experience.