That's too bad Caryn. It doesn't matter if it's a relationship between a client and an SP or not. To lead someone on, saying and doing the things one does when in love, only to spring on you they are married, is just plain mean. It might be different if you knew he was married and you both still developed a relationship based on him maybe one day leaving his wife (evidently his marriage can't be a good one). We all know that sometimes things happen in life we can't control when it comes to affairs of the heart.
I know that the last thing you need right now is people telling you to forget him and move on. From experience I know it is never that simple but in a few days things will seem better. Call up a real friend, go to a comedy club/movie, treat yourself to a spa treatment, eat chocolate and move on.