title: How to create virtual List to realize reference like one-to-many without foreign key on "many side"
body: <p>I'm using Entity Framework Core 5.0.0 with SQLite3 (Entity Framework 6.4.4 is also installed) on .NET Core application, and have these 2 tables:</p>
  <pre><code>CREATE TABLE string 
  (
      id     INTEGER NOT NULL,
      locale TEXT    NOT NULL,
      text   TEXT    NOT NULL,
      CONSTRAINT PK_string PRIMARY KEY (id, locale)
  );
  
  CREATE TABLE elem 
  (
      id      INTEGER NOT NULL PRIMARY KEY,
      name    TEXT    NOT NULL,
      titleId INTEGER NOT NULL,
      briefId INTEGER NOT NULL
  );
  </code></pre>
  <p>This scheme is correct and works, but in the context of the Entity Framework, this does not fully implement the convenience of EF: in the <code>elem</code> table, as a result, I only have an integer field, and not a <code>List&lt;string&gt;</code>.</p>
  <p>On the one hand, I have a many-to-many relationship here, but incorrect many-to-many because there is no intermediate table. This is also no one-to-many because <code>string</code> does not have any relations to <code>elem</code> (because of not only <code>elem</code> is referencing to <code>string</code>).</p>
  <p>Even many-to-many here will not be the most convenient, since I will have to create several intermediate tables...</p>
  <p>I want to have a <code>List&lt;string&gt;</code> in the class, not just an integer field.</p>
  <p>Is there any way to do it in EF without changing the schema (or with minimal changes, not like change to complete many-to-many relationship)?</p>