Use EF Core to add each day from date range

I am trying to add all days from a date range in my database but I couldn't find a way to do that

I am getting the data range from View with

    

        

            Data de inceput
            
        
        

            Data de sfarsit
            
        
    
    

        

            
                Salveaza
            
        
    

but to add I could only test for one value

public async Task OnPostAddNewAsync(DateTime sdate, DateTime edate)
{
    var newData = new CMPAvDate()
    {
        CMPDate = sdate
    };

    if (await TryUpdateModelAsync(newData, "CMPAvDate"))
    {
        _context.CMPAvDates.Add(newData);
        await _context.SaveChangesAsync();
        return RedirectToPage("/CMP/CMPSchedule", new {sdate});
    }

    return RedirectToPage("/CMP/CMPSchedule");
}

I also tried without success

public static IEnumerable EachCalendarDay(DateTime sdate, DateTime edate)
{
    for (var date = sdate.Date; date.Date <= edate.Date; date = date.AddDays(1)) yield
    return date;
}

foreach (DateTime day in EachCalendarDay(sdate, edate))
{
    var newData = new CMPAvDate()
    {
        CMPDate= day
    };
    if (await TryUpdateModelAsync(newData, "CMPAvDate"))
    {
        _context.CMPAvDates.Add(newData);
        await _context.SaveChangesAsync();
        return RedirectToPage("/CMP/CMPSchedule");
    }
}