D&C QUESTIONS!!!! help!!!

✨Cassidy✨👨‍👩‍👧‍👧👶🏼
Hey guys so im getting a D&C as my gyno saw something in my uterus that shouldnt be there, i was wondering if anyone has had one before and will i be in pain AND will i be more fertile?? Will a baby be more likely to stick after a D&C? PLEASE HELP