tags:

views:

19

answers:

0

Joining two tables in LinQ and VB.

Hello, I have a listview and I am binding based on a linq query. It it is just one table it is working fine. If I join the 2nd table it is not displaying any records

How do I add join two tables in this linq query?

I have commented the join query as it is not working

Dim db As New SettlementsDataContext
        'Dim apps = From a In db.ApplicationSources, b In db.ViolationsDataSourceConfigs Where a.ApplicationIDPK = b.ApplicationID _
        'Select a, b
        Dim apps = From a In db.ApplicationSources _
        Select a

            lvApps.DataSource = apps
            lvApps.DataBind()