Union (LINQ, Entity Framework)

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

                // Get data from CUSTOMER and COUNTRY
                var ds = (from c in db.CUSTOMER
                          select new
                          {
                              DataCol1 = c.CUSTOMER_ID,
                              DataCol2 = c.NAME
                          }).Union(from d in db.COUNTRY
                                   select new
                                   {
                                       DataCol1 = d.COUNTRY_CODE,
                                       DataCol2 = d.COUNTRY_NAME
                                   }).OrderBy(o => o.DataCol1).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 from Entities
        Using db = New myDatabaseEntities()

            ' Get data from CUSTOMER and COUNTRY
            Dim ds = (From c In db.CUSTOMER Select New With { _
                Key .DataCol1 = c.CUSTOMER_ID, _
                Key .DataCol2 = c.NAME _
            }).Union(From d In db.COUNTRY Select New With { _
                Key .DataCol1 = d.COUNTRY_CODE, _
                Key .DataCol2 = d.COUNTRY_NAME _
            }).OrderBy(Function(o) o.DataCol1).ToList()

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