Left Join (LINQ, Entity Framework)

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

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

         private void frmMain_Load(object sender, EventArgs e)
        {
            // Create new entities Object
            using (var db = new myDatabaseEntities())
            {
                // Get data from CUSTOMER
                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
            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

         private void frmMain_Load(object sender, EventArgs e)
        {
            // Create new entities Object
            using (var db = new myDatabaseEntities())
            {
                // Get data from CUSTOMER
                var ds = (from c in db.CUSTOMER
                          join d in db.COUNTRY on c.COUNTRY_CODE equals d.COUNTRY_CODE into d2
                          from f in d2.DefaultIfEmpty()
                          select new
                          {
                              CusID = c.CUSTOMER_ID,
                              CusName = c.NAME,
                              CountryName = (f.COUNTRY_NAME == null ? "-" : f.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
            Dim ds = (From c In db.CUSTOMER
                      Group Join d In db.COUNTRY On c.COUNTRY_CODE Equals d.COUNTRY_CODE Into Group
                      From f In Group.DefaultIfEmpty() _
                      Select New With { _
                           .CusID = c.CUSTOMER_ID, _
                           .CusName = c.NAME, _
                           .CountryName = (If(f.COUNTRY_NAME Is Nothing, "-", f.COUNTRY_NAME)) _
                      }).ToList()
            ' if found item rows
            If ds.Count() > 0 Then
                Me.myDataGridView.DataSource = ds
            End If
        End Using
    End Sub