I have Items and Bids table with one to many relationship between them (an item can have many bids).

Item table primary column is ItemID.

Bids table has the following columns:
1. BidID (primary key)
2. ItemID (forgien key)
3. Is Successful (boolean column to denote if the bid was successfult).


In Item class, I want to map a property called successfulBid to the Successful bid identified in Bids table.

Please let me know how to map such a property.

Thanks