This is a tough question to answer, as everyone has vastly different experiences with their first encounter. For myself, I remember it being a bit of a disappointment after all of the hype, and no, it did not hurt. I have a friend that told me it felt like a pinch at first, and then wonderful. Your experience can be difficult, disappointing, or downright wonderful, and that will mostly depend upon how much preparation you and your partner are willing to go to. The bottom line is that nobody can really tell you whether or not it will hurt, but I can offer the following advice:

Make sure your partner takes his time and does not rush to the actual insertion point. He should, hopefully, be doing things like licking your most sensitive parts, playing gently with the clitoris, and very gently inserting a finger to make sure you are lubed-if not, douse said finger with a good lubricant and apply generously. Women, when aroused, produce lubrication in the vagina that help it to prepare for insertion. If it is not lubed enough, it can cause discomfort for both partners. My suggestion here would be a very good lube such as the water-based Astroglyde or the silicone-based Eros or Eros Woman, all of which are condom compatible.

There are other things that can effect the experience-your mood, the setting, the communication between the two of you beforehand. Candles and soft music can do a lot to enhance all of this.

Please, make sure you have discussed birth control and disease before hand. After the act is NOT a good time to think about these things.