Through association not as expected

Hey, I am so sorry if this has been asked before or I am not understanding how through associations work.

I have set up an automatic generated through association, between two tables, Mux and Uploads. The Auto Through Entity is called MuxUploads.

I am using the following code to list through the uploads for the mux.

    For Each m As Mux In UnitOfWork.Muxes
        Debug.WriteLine("Mux: " + m.Name)

        For Each u As Upload In m.Uploads.ToList
            Debug.WriteLine("Upload: " + u.Name)
        Next

    Next

[output]
Mux: Preview
Mux: Clear Cast
Mux: VOD

However the number of uploads to any mux is zero.

I can use the following code and it works as expected

    For Each m As Mux In UnitOfWork.Muxes
        Debug.WriteLine("Mux: " + m.Name)

        For Each mu As MuxUploads In m.MuxUploads.Where(Function(a) a.MuxId = m.Id).ToList()
            Dim up As Upload = UnitOfWork.Uploads.Single(Function(a) a.Id = mu.UploadId)
            Debug.WriteLine("Upload: " + up.Name)
        Next
    Next

[output]
Mux: Preview
Upload: Testing
Mux: Clear Cast
Mux: VOD

I receive uploads to the muxes.

Am I doing something incorrectly or misunderstanding how the through associations work?

No this should work as per your expectation, but it implies that the MuxUploads are not being loaded in the first example. Are you able to send through a small repro project for this and I can have a look to see whats going on?

Jeremy

Hi Jeremy,

I separated the project, and I am still getting the same thing.

Repo: https://bitbucket.org/malcor88/lightspeedtest/

Thank you

Thanks for the repro, I can see the same result.

I will have to investigate further on whats occurring as it appears that the lazy load is not being triggered in this case. In the meantime the workaround for this is to convert the auto-through entity to an explicit one and then on the relationship between Mux and MuxUploads go to the properties for the relationship and then set the "Eager Load Collection" property to be true

Jeremy