title: Joining Events with options
body: <p>Database Architecture Question</p>
  
  <p>I've got following classes:</p>
  
  <pre><code> public class Member
  {
      public int ID { get; set; }
      public Char Gender { get; set; }
      public string FirstName { get; set; }
      public string LastName { get; set; }
  }
  
  public class Event
  {
      public int ID { get; set; }
      public virtual ICollection&lt;Option&gt; Options { get; set; }
  }
  public class Option
  {
      public int ID { get; set; }
      public virtual ICollection&lt;Event&gt; Events { get; set; }
  }
  </code></pre>
  
  <p>Now i wonder how to reach my goal:</p>
  
  <p>There should be Events, with options attached. Now a Member should have the possibility to "join" an Event and select some options.</p>
  
  <p>That means options were attached to an event and members can be attached to an event with many options.</p>
  
  <p>Example:</p>
  
  <p>User A joins event "A" with options One and Two
  User B joins event "A" just with option One</p>
  
  <p>Any ideas / help for me?
  I'm working with Fluent API, but have no idea about the Relationships i have to do</p>
  
  <p>╔═══╦═════════╦═════════╦═════════╦═════════╦═════════╗
  ║   ║ EventID ║ Option1 ║ Option2 ║ Option3 ║ Option4 ║
  ╠═══╬═════════╬═════════╬═════════╬═════════╬═════════╣
  ║   ║ Event1  ║ Members ║ Members ║ Members ║ Members ║
  ╠═══╬═════════╬═════════╬═════════╬═════════╬═════════╣
  ║   ║ Event2  ║ Members ║ Members ║ Members ║ Members ║
  ╠═══╬═════════╬═════════╬═════════╬═════════╬═════════╣
  ║   ║ Event3  ║ Members ║ Members ║ Members ║ Members ║
  ╚═══╩═════════╩═════════╩═════════╩═════════╩═════════╝</p>