Most dining rooms require the light to be where food is been served & consumed,
so particular attention needs to be placed where you are dining.
The light above the table needs to be bright but unobtrusive; by using a dimmer to control the light will ensure you have control over the light setting.
Products to consider:-
Low voltage downlights, mains voltage downlights, & plaster uplighters.