Pain during sex

I’m in my late 20s and I’ve been experiencing dryness and pain during sexual activity almost my entire sex life and it’s negatively impacting my relationship. I currently have same sex partner so it’s usually just the fingering and still hurts. I thought of trying some supplement or stimulating gel but I don’t know how good they are. Anyone tried any product that work/didn’t work for you? Any other suggestion appreciated.