private void button3_Click(object sender, EventArgs e)
{
adwenturecontext = new AdventureWorks2017Entities();
var people = from a in adwenturecontext.Addresses
where a.City == listBox1.SelectedItem.ToString()
join b in adwenturecontext.BusinessEntityAddresses
on a.AddressID equals b.AddressID
join c in adwenturecontext.BusinessEntities
on b.BusinessEntityID equals c.BusinessEntityID
join d in adwenturecontext.People
on c.BusinessEntityID equals d.BusinessEntityID
select d;
try
{
dataGridView1.DataSource = people.ToList();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
adwenturecontext = new AdventureWorks2017Entities();
try
{
listBox1.DataSource =
(from p in adwenturecontext.Addresses.OrderBy(k => k.City).ToList()
select p.City).Distinct().ToList();
listBox1.DisplayMember = "City";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}