Error calling AsyncUpdate against SQL Server database with identity primary keys

[MoxiePoxy]

The UpdateAsync method in version 2.0.1 attempts to write primary key values on update. This causes an exception on SQL Server where the primary keys are identities.

This fix is in the main branch of PetaPoco’s Database class in the ExecuteUpdate method:

// Don't update the primary key, but grab the value if we don't have it
if (string.Compare(i.Key, primaryKeyName, true) == 0)
{
    if (primaryKeyValue == null)
        primaryKeyValue = i.Value.GetValue(poco);

        continue;
}

AsyncPoco/AsyncPoco/Database.cs

Line 1305 in 02863e6

if (primaryKeyValue == null && primaryKeyValuePairs.ContainsKey(i.Key)) {