in Amazon.QLDB.DMVSample.Api/Functions/AddSecondaryOwnerFunction.cs [129:148]
private IEnumerable<string> GetSecondaryOwners(TransactionExecutor transactionExecutor, string vin)
{
IIonValue ionVin = this.valueFactory.NewString(vin);
IResult selectResult = transactionExecutor.Execute("SELECT Owners.SecondaryOwners FROM VehicleRegistration AS v WHERE v.VIN = ?", ionVin);
IIonList secondaryOwners = selectResult.First().GetField("SecondaryOwners") as IIonList;
if (secondaryOwners != null)
{
List<string> secondaryOwnerIds = new List<string>();
foreach(var owner in secondaryOwners)
{
secondaryOwnerIds.Add(owner?.GetField("PersonId")?.StringValue);
}
return secondaryOwnerIds;
}
else
{
return Enumerable.Empty<string>();
}
}