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()