I am unble to find records for Employees table in the following code. I have used Entity data model.
Here for Console.WriteLine("Department Name = " + dept.Name ); output is coming but for dept.Employees.Count() is 0.
using (EmpDBContext dbcontext = new EmpDBContext())
{
var departments = from dept in dbcontext.Departments
where dept.Name == "IT"
select dept;
foreach (var dept in departments)
{
Console.WriteLine("Department Name = " + dept.Name );
Console.WriteLine("count is " + dept.Employees.Count());
//var employees = from e in dept.Employees
// where e.ID == dept.ID && e.Gender == "Male"
// select e;
}
Console.ReadKey();
}
{
var departments = from dept in dbcontext.Departments
where dept.Name == "IT"
select dept;
foreach (var dept in departments)
{
Console.WriteLine("Department Name = " + dept.Name );
Console.WriteLine("count is " + dept.Employees.Count());
//var employees = from e in dept.Employees
// where e.ID == dept.ID && e.Gender == "Male"
// select e;
}
Console.ReadKey();
}

Amit KumarPosted Apr 23, 2019, 11:40 AM
Laxmidhar SahooPosted Apr 23, 2019, 10:34 AM
SaurabhPosted Apr 23, 2019, 8:45 AM
SaurabhPosted Apr 23, 2019, 8:41 AM
Mario ScheerenPosted Apr 23, 2019, 8:26 AM
Rajeesh MenothPosted Apr 23, 2019, 8:19 AM