ASP.NET MVC controller join two tables: "An anonymous type cannot have multiple properties with the same name"

Question

I have the following code to join two tables in an ASP.NET MVC controller but I also want to display employee's supervisor name from the same table and same filed.

But I get an error:

An anonymous type cannot have multiple properties with the same name

Here is my code

public IHttpActionResult GetEmployees()
{
    var query = (from n in db.Employees
                 join c in db.tblCities on n.ProjectID equals c.CityID
                 into nc
                 from c in nc.DefaultIfEmpty()

                 join manager in db.Employees on n.ManagerName equals manager.Name
                 into pc
                 from managerin pc.DefaultIfEmpty()

                 select new
                         {
                             n.Name,
                             manager.Name,
                             n.Email,
                             c.CityName
                         });

    var employees = query.ToList();

    return Ok(employees);
}

What is the workaround to accomplish my goal?

Sami Kuhmonen · Accepted Answer · 2019-11-02 03:29:09Z

2

You need to give the properties (or at least conflicting ones) actual names so you know what is what. Which Name would be Name if you don’t? For example:

select new
{
  n.Name
  ManagerName = manager.Name,
  n.Email,
  c.CityName
}

Also often it’s better to use actual types instead of anonymous ones so you get type safety properly through the application, especially when this information is given out to views etc.

answered Nov 2, 2019 at 3:29

Sami Kuhmonen

31.4k9 gold badges67 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

ASP.NET MVC controller join two tables: "An anonymous type cannot have multiple properties with the same name"

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related