[Route("Mode")]
    [HttpGet]
    public object Mode()
    {
        string query = "Select Sum(c.total) as Total, Sum(h.Qty) as Qty, Sum(c.Amount) as Amount, Count(c.Item) as Count, " +
            "c.Item, c.Model, h.Date From Cart c Left Join House as h On c.Id = h.Id Group By c.Item, c.Model, h.HarvestDate ";
        DataTable dt = new DataTable();
        string sqlDataSource = _configuration.GetConnectionString("DefaultConnection");
        SqlDataReader dr;
        using (SqlConnection con = new SqlConnection(sqlDataSource))
        {
            con.Open();
            using (SqlCommand cmd = new SqlCommand(query, con))
            {
                dr = cmd.ExecuteReader();
                dt.Load(dr);
                dr.Close();
                con.Close();
            }
        }
        return new JsonResult(dt);
    }

I want to rewrite the above code in LINQ. My requirement is to write LINQ query to fetch data from both tables.

House table

Cart table

This is what l have tried

IEnumerable DataSource = (from c in _context.Cart join h in _context.House on c.Id equals h.Id select t1).ToList();

Expected output table