wp-dapper-04.cs

var hamilton = new Driver
{
    FirstName = "Lewis",
    LastName = "Hamilton",
    ChampionTitleCount = 4
};

string sql = $@"INSERT INTO [Drivers] ([FirstName], [LastName], [ChampionTitleCount]) VALUES (@FirstName, @LastName, @ChampionTitleCount);
                SELECT CAST(SCOPE_IDENTITY() AS int);";

hamilton.Id = (await connection.QueryAsync<int>(sql, hamilton)).FirstOrDefault();