public static List <Bid> FindLowestBid(int id) //find the lowest bid for a specific gig { // string sql = @"SELECT * FROM dbo.bids WHERE GigId = @OwnerId"; string sql = @"SELECT MIN(Price) AS Price FROM dbo.bids WHERE GigId = @Id"; return(SqlDataAccess.LoadNum <Bid>(sql, id)); }