Join Clause (LINQ, Entity Framework)

                var ds = (from c in db.TABLE1
                          join d in db.TABLE2 on c.COL equals d.COL
                          select c).ToList();

        Dim ds = (From c In db.TABLE1
                  Join d In db.TABLE2 On c.COL Equals d.COL
                  Select c).ToList()

        private void frmMain_Load(object sender, EventArgs e)
        {
            // Create new entities Object
            using (var db = new myDatabaseEntities())
            {

                // Get data from CUSTOMER and join COUNTRY
                var ds = (from c in db.CUSTOMER
                          join d in db.COUNTRY on c.COUNTRY_CODE equals d.COUNTRY_CODE
                          select new
                          {
                              CusID = c.CUSTOMER_ID,
                              CusName = c.NAME,
                              CountryName = d.COUNTRY_NAME
                          }).ToList();

                // if found item rows
                if (ds.Count() > 0)
                {
                    this.myDataGridView.DataSource = ds;
                }
            }
        }

    Private Sub frmMain_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        ' Create new entities Object
        Using db = New myDatabaseEntities()

            ' Get data from CUSTOMER and join COUNTRY
            Dim ds = (From c In db.CUSTOMER
                      Join d In db.COUNTRY On c.COUNTRY_CODE Equals d.COUNTRY_CODE
                        Select New With { _
                         .CusID = c.CUSTOMER_ID, _
                         .CusName = c.NAME, _
                         .CountryName = d.COUNTRY_NAME _
                        }).ToList()

            ' if found item rows
            If ds.Count() > 0 Then
                Me.myDataGridView.DataSource = ds
            End If
        End Using
    End Sub

                var ds = (from c in db.TABLE1
                          join d in db.TABLE2 on new { c.XXX, c.YYY } equals new { d.XXX, YYY = d.ZZZ }
                          select c).ToList();

        Dim ds = (From c In db.TABLE1
                  Join d In db.TABLE2 On New With {c.XXX, c.YYY} Equals New With {d.XXX, .YYY = d.ZZZ}
                Select c).ToList()

                var ds = (from c in db.TABLE1
                          join d in db.TABLE2 on c.COL equals d.COL
                          join e in db.TABLE2 on d.COL equals e.COL
                          select c).ToList();

        Dim ds = (From c In db.TABLE1
                    Join d In db.TABLE2 On c.COL Equals d.COL
                    Join e In db.TABLE2 On d.COL Equals e.COL
                    Select c).ToList()