Allow Dapper to enforce 'required' properties are present

[Dreamescaper]

I would be nice to be able to configure Dapper to respect 'required' annotations:

public class DataResult
{
    public required string StringValue { get; set; }
    public required int IntValue { get; set; }
}

...

await connectionQueryAsync<DataResult>("[proc_MyStoredProc]");
// Should throw an exception if `StringValue` or `IntValue` are not provided

Suggested API changes:

SqlMapper.Settings.RespectRequiredModifiers = true;

[mgravell]

I doubt we would add this to vanilla Dapper, due to ever-increasing complexity - but: Dapper.AOT already detects required to ensure that the values get assigned appropriately; we could, perhaps, consider adding an attribute such as [EnforceRequired([true])] that enables this.