I am trying to select fields from two tables using the Join clause with LINQ, but l am getting this error:

System.InvalidCastException: ‘Unable to cast object of type ‘<>f__AnonymousType213[System.Int32,System.Nullable1[System.Int32],System.String,System.String,,System.Nullable1[System.DateTime],System.Nullable1[System.Int32],System.Nullable1[System.Decimal],System.Nullable1[System.DateTime],System.Nullable1[System.Decimal],System.Nullable1[System.Decimal]]’ to type ‘ProjectA.Models.Planting’.’

Planting table

Harvest table

The codes below is what l had tried;

public class PlantingController : Controller
{
    private readonly dbContext _context;

    public PlantingController(dbContext context)
    {
        _context = context;
    }

    public IActionResult Index()
    {
        return View();
    }

    public IActionResult UrlDatasource([FromBody] DataManagerRequest dm)
    {
        IEnumerable DataSource = (from u in _context.Planting join c in _context.Harvest on u.CropID equals c.CropID
        select new { u.CropID, u.CropName, u.PlantDate, u.PlantQty
        c.HarvestDate, c.HarvestQty, c.Weight });           
        return dm.RequiresCounts ? Json(new { result = DataSource}) : Json(DataSource);
    }
    
}

Expected output