Before you have your CS you will have a pre-op visit with the surgeon and the anaesthetist. This is a really good time to bring up your fear, the anaesthetist may be able to offer you some reassurance, and if it's still a problem you can request some happy drugs to take the edge off before hand.