Compact Flash connector pin broke. Can it be fixed?

So, I tried to put in my compact flash card, only to keep getting error messages that the card was not in. I did not want to force it, so I looked to see if a pin was bent. It turns out, it had broken off completely, and fell out.

A friend of mine borrowed my camera, and mentioned nothing about it being broken. I do not want to point a finger, but, now I cannot use my camera, as I cannot get a a compact flash memory card to connect and save photos.

Is there a way to replace that connector? Approximately how much would it cost?

Thanks!