(NorthwindEntities ne = new NorthwindEntities())
{
var result = from c in ne.Customers
join o in ne.Orders
on
new { ID = c.CustomerID,Sehir = c.City }
equals
new { ID = o.CustomerID,Sehir = o.ShipCity }
select new { MusteriID = c.CustomerID, Adi = c.ContactName, MusteriSehir = c.City, SiparisSehir = o.ShipCity };
GridView1.DataSource = result;
GridView1.DataBind();