I have the following table that does not have a primary key.

public class Person
{
  public string PersonId { get; set; }
  public string ConfirmationNumber { get; set; }
  public string Sid  { get; set; }
}

I insert a record with these values

Person p = new Person();
p.PersonId = 0;
p.ConfirmationNumber = "ABC-DEF-GHJ";
p.Sid = "19240";

await DatabaseAsync.InsertAsync(p);

I then need to update this record with these vaues

p.PersonId = 2047;
p.ConfirmationNumber = "ABC-DEF-GHJ";
p.Sid = "19240";

SQLight does not have an Update.With()

I thought about deleting the rec and re-inserting it with the new values but
SQLight does not have a Delete.With()
and I can’t use Replace() since this table doesn’t have a primary key.

Note:
The combination of ConfirmationNumber and Sid does uniquely identify every record with no duplicates.