将foreach转换为select语句

我在foreach循环中编写了以下代码,我想将其转换为linq-select方法。

List<BidderDataDTO> bidsData = new List<BidderDataDTO>();

if(bidderDatas.Count > 0)
{
    foreach (var bidderData in bidderDatas)
    {
        var data = new BidderDataDTO();

        data.TenderId = bidderData.TenderId;
        data.ClosingDate = _context.Tenders.Where(x => x.Id == tenderid).Select(x => x.ClosingDate).FirstOrDefault();
        data.FullName = _context.Users.Where(x => x.Userid == bidderData.CreatedUser).Select(x => x.Firstname + " " + x.Lastname).FirstOrDefault();
        data.Price = bidderData.Price;

        bidsData.Add(data);
    }
}

我试着跟随,但不起作用。所以,对此有什么想法吗

 bidderDatas.Select(x => new BidderDataDTO()
 {
     TenderId = x.TenderId,
     ClosingDate = _context.Tenders.Where(x => x.Id == tenderid).Select(x => x.ClosingDate).FirstOrDefault(),
     CompanyName = _context.Companies.Where(x => x.Id == x.CompanyId).Select(x => x.CompanyName).FirstOrDefault(),
     FullName = _context.Users.Where(x => x.Userid == x.CreatedUser).Select(x => x.Firstname + " " + x.Lastname).FirstOrDefault(),
     Price = x.Price,
     Email = _context.Users.Where(x => x.Userid == x.CreatedUser).Select(x => x.Email).FirstOrDefault(),
 }).ToList();