Right Join (LINQ, Entity Framework)

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

                // Get data from CUSTOMER and CUSTOMER
                var ds = (from c in db.COUNTRY
                          join d in db.CUSTOMER on c.COUNTRY_CODE equals d.COUNTRY_CODE into d2
                          from f in d2.DefaultIfEmpty()
                          select new
                          {
                              CountryName = (c.COUNTRY_NAME == null ? "-" : c.COUNTRY_NAME),
                              CusID = f.CUSTOMER_ID,
                              CusName = f.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 CUSTOMER
            Dim ds = (From c In db.COUNTRY
                        Group Join d In db.CUSTOMER On c.COUNTRY_CODE Equals d.COUNTRY_CODE Into Group
                        From f In Group.DefaultIfEmpty()
                        Select New With { _
                             .CountryName = (If(c.COUNTRY_NAME Is Nothing, "-", c.COUNTRY_NAME)), _
                             .CusID = f.CUSTOMER_ID, _
                             .CusName = f.NAME _
                        }).ToList()

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