Some years ago I worked with a guy who was both gay and LDS. I recall asking how that was working out for him. He had a really interesting perspective...yes he was gay, but the LDS church didn't recognize homosexuality, and since you weren't allowed to have sex outside of marriage...he just happened to be a very celibate gay person, as his friends were very celibate straight people. When I knew him some twenty years ago...he just planned to stay unmarried.
A man I went to high school with is the same way. He is an honorable and serves faithfully in the LDS church, but will never marry.