Error multiple properties with the same name in LINQ query

c# entity-framework-6 linq linqpad

Question

I am working on Linq query and I am getting error on functionNavigation_b.Title column. I am using LinqPad to test my queries initially,

Error

An anonymous type cannot have multiple properties with the same name

enter image description here

LINQ Query

from functionNavigation in Sys_Nav_Functions
join functionHierarchy in Sys_Nav_FunctionHierarchies on functionNavigation.Function_ID equals functionHierarchy.Function_ID 
join functionNavigation_b in Sys_Nav_Functions on functionHierarchy.Parent_Function_ID equals functionNavigation_b.Function_ID
 select new {
              functionNavigation.Function_ID, 
              functionNavigation.Title, 
              functionNavigation.Hierarchy_Level,
              functionHierarchy.Parent_Function_ID, 
              functionNavigation_b.Title 
            }
1
-3
6/24/2016 9:06:19 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

An anonymous object can't have two properties with the same name.

Change your anonymous projection, give a different name to the second Title property.

functionNavigation.Function_ID, 
functionNavigation.Title, 
functionNavigation.Hierarchy_Level,
functionHierarchy.Parent_Function_ID, 
TitleB= functionNavigation_b.Title //or ParentTitle, or whatever you want
4
6/24/2016 9:09:41 AM

Popular Answer

Error is clear, you have duplicate Title name.

Try specifying unique name.

functionNavigation.Function_ID, 
functionNavigation.Title, 
functionNavigation.Hierarchy_Level,
functionHierarchy.Parent_Function_ID, 
AnotherTitle= functionNavigation_b.Title
Hari Prasad

Related Questions

Order LINQ After that, by ChildrenCollection.Name.

It seems like you're trying to get a list of all departments ordered by group then department name. If so, then you probably want to do something like this:...var res = from c in _repository.GetActiveDepartmentGroupsWithDepartments() from d in c.Departments orderby c.DepartmentGroupName, d.DepartmentName select d; ...O...
c# entity-framework linq linq-to-entities
asked by dahlbyk

LINQ to Entities query using Sum on child object attribute has a problem.

You should check for it:...HeadCount = s.Reservations != null ? s.Reservations.Sum(r => r.PartySize) : 0,
.net c# entity-framework linq orm
asked by Ahmad Mageed

where clause in C# Linq based on property name

Looks like you need ...Dynamic Linq queries...:...http://weblogs.asp.net/scottgu/archive/2008/01/07/dynamic-linq-part-1-using-the-linq-dynamic-query-library.aspx
asp.net asp.net-mvc c# entity-framework linq
asked by Jakub Konecki

Using Entity Framework and a single LINQ query, delete numerous records

One way to have a batch delete is setting ON CASCADE DELETE on foreign keys. You need to set CASCADE on relation in designer and Set ON CASCADE DELETE on relation in database. ...To delete Products navigation property from Order EF will do (number of Products properties)+1 statements to database....I prefer to do it:...var order = context.Orders.In...
c# entity-framework linq
asked by Matija Grcic

C# LINQ to Entities query for the intersection of two different properties

int id = id_of_the_pen_that_i_am_holding; Pen p = db.Pens.Find(id); var penColorIds = p.Color.Select(m => m.Id).ToList(); var list = db.Pencils.Where(pencil => pencil.Color.Any(color => penColorIds.Contains(color.Id));
c# entity-framework linq-to-entities
asked by Raphaël Althaus

LINQ Query Using Navigation Properties Generates Multiple SELECT Statements

I have a POCO Domain Entity class that contains convenience methods to navigate to related records. I am using the AdventureWorks2008R2 database to demonstrate what I am attempting to accomplish. All of these queries can be run in LINQPad to observe the SQL statements generated....SalesOrderHeaders.Where(s => s.SalesOrderID == 43659) ...
c# entity-framework linq linq-to-entities sql
asked by Matthew at Critical Cognition

An anonymous type cannot have multiple properties with the same name

I want to bind gridview through entity framework but it throws error like-...An anonymous type cannot have multiple properties with the same name Entity Framwrok...Here is my method....public void UserList(GridView grdUserList) { using (TreDbEntities context = new TreDbEntities()) { var query =( from m in context.aspnet_Membership...
entity-framework
asked by Mukesh Bhagat

Entity Framework .net: "The Name value should be a valid navigation property name."

Hello I'm starting a project with ASP.Net and I'm following the Training Camps of Microsoft. I was trying to make a REST petition to my published api, and I got the next exception:...The ForeignKeyAttribute on property 'QuestionId' on type 'PlataformaTest.Models.AnswerModel' is not valid. The navigation property 'OptionModel' was not found on t...
asp.net c# entity-framework foreign-keys
asked by Andres Felipe

Searching for multiple strings using single database query with entity framework and LINQ

Assuming I have a database table (aTable) with two columns ...id : int...name: string ...Requirements: I want to retrieve entries where aTable.name is like a list of strings (stringsToSearchFor)....What I am doing: Currently I am using the following approach ...var result=new List<aTable>; foreach (var aString in stringsToSearchFor) { ...
c# entity-framework entity-framework-6 linq linq-to-sql
asked by Sari

LINQ query Where ID does not exist as a property in a list of objects

I have a list of objects that contain ID numbers. I want to query a table in my database to give me all the rows where the ID ...do not... match the ID of any of the objects in my list. ...List<Item> allItems = new List<Item>(); // Populate allItems ...An ...Item... is a simple object with a ...public int ItemID... and ...public string Name.......H...
c# entity-framework entity-framework-6 linq sql
asked by MSOACC

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow