title: If EAV is evil, what to use for dynamic values?
body: <p>I need to create database where <code>Accountgroup</code> table will have dynamic fields so that <code>Accounts</code> can enter those dynamic field values when needed. It's probably not important but I'm using C# with EF and Linq.</p>
  <p>It's hard for me because I never done anything like that and since I did my research everyone is saying that EAV systems are horrible and <em>you should design it differently</em>, the problem is that nobody tells afterwards - how?</p>
  <p>So maybe you can help me out and tell how can I implement something similar without doing EAV?</p>
  <p>This is what I have so far.</p>
  <p><img src="https://i.stack.imgur.com/cBnhf.png" alt="enter image description here" /></p>
  <p><strong>2020 Edit:</strong></p>
  <p>I just want to edit this post because it's 2020 and there are clear answers to this: Postgres with jsonb type. EF Core supports it so you can actually save and query dynamic json without any problems.</p>