I have sung ,for years, at parties, nursing homes, and dances, but quiet dinners were more elevator type until dinner was over, then it would often start to liven up. If I had a rock n roll request, game on. I will have to keep using my own judgement about when and what to sing. John's idea about not singing in a high end dinner, may have merit. I, on the other hand, am a little rough around the edges, with 70's country my favorite. In between both ideas lie the answer for me.
" READ THE AUDIENCE" like Gary and others say.

For what it's worth: https://www.weddingwire.com/wedding-forums/singing-during-dinner/0e817c1857d2f39c.html