EmployeeID FirstName ReportToEmployee
1 Andrew NULL
2 Nancy 1
3 Bob 2
I need to create list of employee and its manager first names *including*
employee Andrew. For Andrew, first name can be null or empty string.:
Andrew NULL
Nancy Andrew
Bob Nancy
I tried
Northwind db = CreateDB();
var query = from e in db.Employees
select new {
Name = e.FirstName,
ReportsTo = e.ReportsToEmployee.FirstName
};
var list = query.ToList();
But this returns only 2 members, without Andrew.
How to return 3 entities, including Andrew ?
Andrus.
Employee class is defined as
[Table(Name = "employees")]
public partial class Employee {
[AutoGenId]
private int employeeID;
[Column(Storage = "employeeID", Name = "employeeid", DbType =
"integer(32,0)", IsPrimaryKey = true, IsDbGenerated = true, CanBeNull =
false, Expression = "nextval('employees_employeeid_seq')")]
public int EmployeeID {
get
{
return employeeID;
}
set
{
if (value != employeeID)
{
employeeID = value;
}
}
}
private string firstName;
[Column(Storage = "firstName", Name = "firstname", DbType = "character
varying(10)", CanBeNull = false, Expression = null)]
public string FirstName
{
get
{
return firstName;
}
set
{
if (value != firstName)
{
firstName = value;
}
}
}
private int? reportsTo;
[Column(Storage = "reportsTo", Name = "reportsto", DbType =
"integer(32,0)", Expression = null)]
public int? ReportsTo {
get
{
return reportsTo;
}
set
{
if (value != reportsTo)
{
reportsTo = value;
}
}
}
[Association(Storage = null, OtherKey = "EmployeeID", Name =
"fk_emp_reportstoemp")]
public EntityMSet<Employee> Employees {
get
{
return null;
}
}
[Association(Storage = null, OtherKey = "EmployeeID", Name =
"employeeterritories_employeeid_fkey")]
public EntitySet<EmployeeTerritory> EmployeeTerritories {
get
{
return null;
}
}
[Association(Storage = null, OtherKey = "EmployeeID", Name =
"fk_order_product")]
public EntitySet<Order> Orders
{
get
{
return null;
}
}
private System.Data.Linq.EntityRef<Employee> reportsToEmployee;
[Association(Storage = "reportsToEmployee", ThisKey = "ReportsTo", Name =
"fk_emp_reportstoemp")]
public Employee ReportsToEmployee
{
get
{
return reportsToEmployee.Entity;
}
set
{
reportsToEmployee.Entity = value;
}
}
}