Currently I have a c# silverlight business application. The application is hosted in Asp.net using the ADO.Net entity framework and a domain service class to read/write to/from my sql server database.
The structure of the database is as follow. I have three tables. Job, Audit & Image. One Job can have many Audits, and One Image can have many Audits - a fairly simple structure. In my Silverlight Client I have a datagrid which is bound to the Jobs table, I also have a listbox which I populate with the list of audit items directly related to the selected job in the datagrid. In order to do this I use the datagrids selection changed event to ensure that the audit listbox is populated with that particular set of audits for each job every time the job selection changes in the datagrid. The code for doing this is below:
private void dataGrid1_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
var auditJob = dataGrid1.SelectedItem as Job;
auditsList.ItemsSource = auditJob.Audit;
}
As you can see it's not rocket science, but of course this method works because of the one to many relationship between job and audit. (one job, many audits). I want to do something sort of similar but with the Image table (different relationship structure). This time I want to populate a listbox with the contents of my Image table, so that when a user selects a specific job in the datagrid, it shows the audits for that job and the list of images. However, since there is no direct link between job and image I am unsure of how to do this but would like to employ a similar method to the one I used above. Since one job has many audits and one image has many audits, the audit table thus contains its own AuditID primary key, as well as the JobID foreign key and the ImageID foreign key. My question is how do I go about setting that link up between Job and Image in order to produce a list of Images for each individual job?
Help would be greatly appreciated