LINQ - No output

Question

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();
   }

Mario Scheeren · Answer

I never use Linq this way (only calling the Methods for IEnumerable) But I think you need to join the second table somehow. var departments = from dept in dbcontext.Departments join emp in dbcontext.Employees ON dept.ID = emp.deptID where dept.Name == "IT" AND emp.Gender== "Male" select new { dept.Name, emp.Count() };

Rajeesh Menoth · Answer

Hi, If you are able to print the value of "dept.Name" then it's mean that dept object contain name property value. but dept.Employees.Count() is a different property of the dept object so before print you just check what value you have getting inside "dept.Employees". I think it's probably null and that's why you are getting count is zero.

Amit Kumar · Answer

Hi, you already filter data of IT Department then you get here count also. Because you r Printing only IT Department data they why you want to count it inside the For each loop. Where you are filtering IT Department data use there .Count () and get easily count.

Laxmidhar Sahoo · Answer

your code is currect .But check the connection string may authentication fail

Saurabh · Answer

Thanks Mario. But dept.Employees count is zero. So can't even work on simple select query for Employee table. It is even not working using Lambda Expression. My problem is why there are no records. In SQL its working fine.

Saurabh · Answer

Rajeesh, In QuickWatch I can see dept.Employees count 0.