`Insert` method always returns 0 when using [ExplicitKey].

If your table has a user generated key you need to generate the key property with the [ExplicitKey] attribute as per the Contrib docs. Example:

public class Employee
{
    [ExplicitKey]
    public int Id { get; set; }
    public string Name { get; set; }
    // etc etc etc
}

However the Dapper.Contrib Insert method always returns 0 meaning there is no (easy) way to determine whether or not the record was written successfully. Can you change this please so that the Id is returned to indicate success or 0 is returned for failure as it does when using a system generated key.

Locate the Dapper.Contrib Insert entry point and inspect how it handles the ExplicitKey attribute, comparing it with the system-generated-key path. Done means a successful insert returns the explicit Id and a failed insert returns 0, with the existing behavior preserved for generated keys.