ShowTimes Query

We add the ShowTimes query to the Cinema.ShowOpens in a new tab class. The query includes the ID and StartTime properties from the Show class and TheaterName property from the Theater class. We only want show time information for a single film, so we are going to use a parameter in the query to select information for a specific Film object. We are also going to sort the results by the starting time of the show and (in case the film is playing at the same time at multiple theaters) by the theater name.

Let's create the query.