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.employeeRowPa rent.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]]

Satish <si*********@cl ayton.comwrote:

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.employeeRowPa rent.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 employeeRowPare nt is null - how about:

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

--
Jon Skeet - <sk***@pobox.co m>
http://www.pobox.com/~skeet Blog: http://www.msmvps.com/jon.skeet
If replying to the group, please do not mail me too

[Satish]

Thanks Jon that works.
Jon Skeet [C# MVP] wrote:

Satish <si*********@cl ayton.comwrote:

>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.employeeRowPa rent.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 employeeRowPare nt is null - how about:

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