Why 2 different entities reference the same object?

Question

4.50/5 (4 votes)

See more:

I use Linq To Entities to get 2 objects m1 & m2.
And I don't understand why 2 different objects reference the SAME Template table.

I suspect that the reason due to the connection between MConfigOnPage1, MConfigOnPage2 with MConfiguration. Maybe it should be splitted somehow?

Here is attached my ERD and the code.

I'll be grateful for explanation why this happens?

Thank you

var cxt = new Entities();
//this returns MConfiguration with Id=19
var m1 = (from mop in cxt.MConfigOnPage1
          where mop.SiteMapId == 15 && mop.HolderId == 13
          select mop.MConfiguration).FirstOrDefault();
//this returns MConfiguration with Id=40
var m2 = (from mop in cxt.MConfigOnPage2
          where mop.SiteMapId == 15 && mop.HolderId == 1
          select mop.MConfiguration).FirstOrDefault();

var t1 = m1.Holder.Template;
var t1.Code = 13;
var t2 = m2.Holder.Template;
//I expect that t2.Code to be 0, but it equals 13
//This behavior tells me that m1 & m2 reference the same Template object,
//   BUT shouldn't m1 & m2 to have their own Template objects?

Posted 9-Mar-11 0:21am

TheAteist

Updated 9-Mar-11 0:22am

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

sairam.bhat · Answer 1 · 2011-03-14T02:29:00

SQL

Link to Entities ensures, within a given context, if you fetch the same entity ( by primary key in DB) you will get the same object.

You will see this same behavior is you selected the row from the template table multiple times. You will always get the same instance back whenever you re-query for any object.

This gives you performance advantages through caching and prevents multiple edits to the same object in the same context from causing conflicts.