Hi there, i think an over night is more about company then constant sex
ive never had an overnight where that was expected and a guy couldn't pull that of himself either
even if he did want to, you can always say that thats not the idea of such a long booking
just be charming and fun and try both to have a good time with good conversation and flirts and you probably end up having sex for a hour and he will wonder of and fall a sleep
or sometimes you have sex before to take the tension of and maybe later a bit
there are no real rules, just what you both feel confortable with
goodluck
x silvia