I have a join in entity framework connecting the Order table and the OrderItem table. All Orders will have multiple OrderItems. I’m trying to return all the Orders, but only the orderItemStatus column from the OrderItem list.
In my Order model I have a property
public List<int>? orderItemStatus { get; set; }
I’m joining the 2 tables ok, but it’s returning all columns from the OrderItem.
orderList = await _context.Order.Include(orderItem => orderItem).ToListAsync();
How do I get a list of the Orders with just the OrderItem.orderItemStatus values?