public Dinner Find(int id) { using (var connection = MvcApplication.GetOpenConnection()) { var sql = @"SELECT * FROM Dinners WHERE DinnerId = @id SELECT * FROM RSVP WHERE DinnerID = @id"; Dinner dinner; using (var multi = connection.QueryMultiple(sql, new { id = id })) { dinner = multi.Read().FirstOrDefault(); // Dinner Exists if (dinner != null) { dinner.RSVPs = multi.Read().ToList(); } } return dinner; } }