for循环中的C#ADO.Net事务未插入所有记录,而仅插入一条记录

我有以下代码。只插入第一条记录,不添加更多记录。 我的代码有问题吗?

foreach (var learningAimFund in learningDelivery.LearningDeliveryFAM)
{
    var fundingMonitoringType = learningAimFund.LearnDelFAMType;
    var fieldId = FundingMonitoringUtil.GetFundingMonitoringFieldId(fundingMonitoringType);
    await _databaseAccess.ExecuteScalarAsync(
        LearningAimFundingDataStoredProcedures.INSERT, 
        new List<Parameter>
        {
            new Parameter(nameof(LearningAimFundingData.LearnerId), newLearnerId),
            new Parameter(nameof(LearningAimFundingData.LearningAimFundingId), aimFundingId),
            new Parameter(nameof(LearningAimFundingData.FieldId), fieldId),
            new Parameter(nameof(LearningAimFundingData.Data), learningAimFund.LearnDelFAMCode)
        }, 
        transaction);
}

有人能帮我吗?