LINQ Help

[Satish]

Hi
I an newbie to LINQ.

I have a dataset with one table employee which has a self referencing
foreign key manger id. I want to write a query to get all the employees
under a particular manager. I tried the following query

var results = from e in emp.employee
where e.employeeRowParent.name == "Doe"
select e;
but when I run this I get a null ref exception in the where. How should
I rewrite this query ?

 

[Jon Skeet [C# MVP]]

I an newbie to LINQ.

I have a dataset with one table employee which has a self referencing
foreign key manger id. I want to write a query to get all the employees
under a particular manager. I tried the following query

var results = from e in emp.employee
where e.employeeRowParent.name == "Doe"
select e;
but when I run this I get a null ref exception in the where. How should
I rewrite this query ?

Well, it looks like the employeeRowParent is null - how about:

var results = from e in emp.employee
where e.employeeRowParent != null &&
e.employeeRowParent.name == "Doe"
select e;

 

[Satish]

Thanks Jon that works.

Well, it looks like the employeeRowParent is null - how about:

var results = from e in emp.employee
where e.employeeRowParent != null &&
e.employeeRowParent.name == "Doe"
select e;