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 :(
mysql-connector entity-framework
Elliott
source share