title: How to model more entities to reference same kind of collections within single table
body: <p>I'm not very experienced with EF and I'm trying to figure out what is the proper way or what are the options for creating entity, collection of which can be contained in other entities (different tables).
  Let's say I have three existing classes (ModuleA, ModuleB, ModuleD) that I want to contain its own collection of Data entities.
  I wanted a single table for Data entities but I don't like the idea of three nullable Guid columns for each FK.
  That also gives me error on applying migration ("...may cause cycles or multiple cascade paths") - which could by probably solved by removing cascade delete and deleting Data manually, but I don't like that idea.</p>
  
  <p>What I would like most is the single (shared) Guid property on Data for FKs to all three modules, which is not possible at least not without same ID existing in all three main tables at the same time (since it creates three FKs in DB).</p>
  
  <pre><code>class Data
  {
      public int Id {get; set;}
      public byte[] Values {get; set;}
  
  }
  
  class ModuleA
  {
      public Guid Id {get; set;}
      public ICollection&lt;Data&gt; Data {get; set;}
      // some other stuff...  
  }
  class ModuleB
  {
      public Guid Id {get; set;}
      public ICollection&lt;Data&gt; Data {get; set;}
      // ...
  }
  class ModuleC
  {
      public Guid Id {get; set;}
      public ICollection&lt;Data&gt; Data {get; set;}
      // some different other stuff...
  }
  </code></pre>