O'Reilly Community

<Function Name="PaymentsforContact" IsComposable="false" >
          <CommandText>
            SELECT Payments.PaymentDate,
            Payments.Amount,
            Reservations.ReservationDate,
            Contact.FirstName,
            Contact.LastName,
            Events.StartDate,
            Events.EndDate,
            Locations.LocationName
            FROM   Payments INNER JOIN
            Reservations ON Payments.ReservationID = Reservations.ReservationID INNER JOIN
            Contact ON Reservations.ContactID = Contact.ContactID INNER JOIN
            Events ON Reservations.EventID = Events.EventID INNER JOIN
            Locations ON Events.LocationID = Locations.LocationID
            WHERE Contact.ContactID = @ContactID
          </CommandText>
          <Parameter Name="ContactID" Type="int" Mode="In" />
        </Function>

var payments = context.PaymentsforContact(199).ToList();

var payments = context.PaymentsforContact(199).ToList();

                    foreach (var payment in payments)
                    {
                        Console.WriteLine("{0} {1}", payment.PaymentDate.ToString(),
                                                     payment.Amount.ToString());
                    }