Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>K. I think I found the cause of this kind of issue. I have a situation with a many to many in my EF diagram (Scholarhip table, Survey table, ScholarshipSurvey table {this is a bridge table}). Well after some serious soul searching I found this in my ScholarshipSurvey table entry in the EDMX:</p> <pre><code> &lt;EntityType Name="ScholarshipSurvey"&gt; &lt;Key&gt; &lt;PropertyRef Name="ScholarshipID" /&gt; &lt;PropertyRef Name="SurveyID" /&gt; &lt;/Key&gt; &lt;Property Name="ScholarshipID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" /&gt; &lt;Property Name="SurveyID" Type="int" Nullable="false" StoreGeneratedPattern="Identity"/&gt; &lt;/EntityType&gt; </code></pre> <p>I was thinking, no way! Why did the EF make these "identities". They are not in the data model from whence the came. So, when I openned the EDMX using a XML editor (instead of the default double click), I removed the entry <strong>StoreGeneratedPattern="Identity"</strong> for both the scholarship id and survey id. Then, I tried my normal code for adding items into the collection and removing items from the collection and it WORKED!</p> <p>All I can think is that this is a bug in EF4 that shouldn't have been. The only other way to solve this is to make the bridge table an object by adding an identity of its own to the table. Gee. Hope this helps some poor soul out there.</p> <p><strong>Update</strong> (rwwilden): There is a <a href="https://connect.microsoft.com/data/feedback/details/540058" rel="nofollow noreferrer">Microsoft Connect report</a> for this issue.</p>
    singulars
    1. This table or related slice is empty.
    1. POEF 4.0 UpdateException
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USRonald Wildenberg
    1. USNate T.
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks, this definitely helped.
      singulars
      1. PO
      1. USRonald Wildenberg
    2. COYes, nasty bug, and your workaround works until MSFT fixes the problem.
      singulars
      1. PO
      1. USIan Mercer
    3. COThank you. This fixed the problem for me.
      singulars
      1. PO
      1. USbgs264
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload