Entity structure returns invalid data from columns with the same name

I have several tables in my database that appear in edmx. Using an entity structure to return data from these tables, I ran into a problem when the value in the "name" column of one of my higher level data models is populated into each model below.

I pull out the data as follows:

var query = (from a in context.things where a.id == 1 select a); var model = query.Select(a => new modelA() { Name = a.name, Bs = a.Bs.Select(b => new modelB() { Name = b.name, Cs = b.Cs.Select(c => new modelC() { Name = c.name, Ds = c.Ds.Select(d => new modelD() { Name = d.name }) }) }) }).FirstOrDefault(); 

b.name, c.name and d.name return the same value as a.name, despite the fact that my database definitely has different values ​​in these tables.

Could this be a caching issue?


Update

After updating mySql connector to the latest version (6.7.4.0), I still encounter an error.

After the update, it seems that I can get 3 levels before the data in the name column appears again :(

+2
mysql-connector entity-framework
source share

No one has answered this question yet.

See similar questions:

8
How can I use Entity Framework on an object graph with depth 2 with MySQL Connector / NET?

or similar:

783
Entity Framework vs LINQ to SQL
630
The fastest way to embed Entity infrastructure
515
How can I get the ID of an inserted object in an Entity framework?
461
How to view SQL generated by Entity Framework?
443
SqlException from Entity Framework - No new transaction allowed because there are other threads in the session
401
Entity Framework service provider was not found for the ADO.NET provider with the invariant name "System.Data.SqlClient"
one
Entity Framework Database The first column not displayed in the model
one
Updating models from a database in Entity Framework 6.0
one
Creating the Entity Framework with Table / Column Lists
0
Column name changed in new database column added to entity structure

All Articles