private void btnNavProp_Click(object sender, EventArgs e)
{
northwindEntities dc = new northwindEntities();
var query = from c in dc.Customers
where c.Orders.Count == 0
select c;
dataGridView2.DataSource = query.ToList();
}
private void btnWhereNot_Click(object sender, EventArgs e)
{
northwindEntities dc = new northwindEntities();
var query = from c in dc.Customers
where !(from o in dc.Orders
select o.CustomerID).Distinct().Contains(c.CustomerID)
select c;
dataGridView1.DataSource = query.ToList();
}
