protected void Page_Load(object sender, EventArgs e)
{
AdventureWorks2012_DataEntities adventureWorks2012_DataEntities =
new AdventureWorks2012_DataEntities();
var query = from emp in adventureWorks2012_DataEntities.Employees
select emp;
GridView1.DataSource = query.ToList();
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
AdventureWorks2012_DataEntities adventureWorks2012_DataEntities =
new AdventureWorks2012_DataEntities();
foreach (var employee in adventureWorks2012_DataEntities.Employees)
{
ListItem li = new ListItem();
li.Text = employee.BusinessEntityID + " ";
foreach (var pay in employee.EmployeePayHistories)
{
li.Text += "Pay Rate: " + pay.Rate + " ";
}
BulletedList1.Items.Add(li);
}
}