Thanks all for your comments, I appreciate that most are very open and honest. And yes, I can be a "silly gemini" at times.
But please don't misunderstand my words. It's difficult to condense two years in just some brief sentences, so it's hard to bring across the entire situation.
I think we really do have a connection - although will admit it probably means more to me than to him (which I guess is what I needed to express on this forum). But at the same time, I think it's unfair to reduce it from my side to a simple "he's married, ergo attractive to weak minded women".
Lastly, he has not crossed the line, so I don't see him trying to take advantage of the situation. My desire for a "date" is more a desire for a situation where we could actually openly talk about all this, and clarify what's going on. Which I guess is not what he would want, or at least be interested in, considering all the above.
I appreciate the perspective and see the truth in your words. I need to decide if I can live with the situation, or not.